We are on SAP BO 4.1 version.
There are a number of Crystal reports scheduled to save under the default location. Most of our users access these reports only through the successful report instances. They don’t run them by themselves.
Now, we have a requirement to identify all those reports which haven’t been used in the past 6 months. When i queried the CMS database, there is no event, that identifies who clicked on the instance link. It only has events about who clicked the report, but not who right clicked the report -> History -> Clicked on a past instance.
You should use Event Type - as “View”. Then use Object Name, User, Event Status, Event Details, Event Date, etc to get the info you need.
Looks like Object name is not clear for event “View”.
In that case you may have to use Query builder to get all report ids and then link to Parent document id from “View” event results.
In above post I forgot to mention about BO auditing. You have to use BO auditing universe and then create new report for Event type “View”. Then follow other steps as per post.
And you also have to have auditing turned on. I highly recommend turning on the “Path” option for auditing as well. That way when you run this list of reports you can easily find reports that might have the same name but that actually live in different folders without having to use the SI_CUID to look up the report in QueryBuilder and then manually determine where it is.
(BOB member since 2007-04-16)