Recently one of the VP's at the company I work for wanted me to find out if user's were running a specific report that they were required to look over before a meeting. Many were stating that they were but were arriving at the meetings unprepared. So great thing that RS stores this information and with a simple join you can tell who ran what, and at what time, as well as parameters sent to the report.SELECT c1.Name, e1.UserName, e1.Format, e1.Parameters, e1.TimeEndFROM [Catalog] c1 INNER JOIN ExecutionLog e1 ON c1.ItemID = e1.ReportID
Check out BOL or the actual database for other fields you may need.I simply created a report displaying the Name of the report found in the Catalog database, the user name, format, parameters if any, and the time the report executed (end time) all found in the ExecutionLog table.Thought I'd post it if anyone else had a similiar requirement.Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url]
Are My Users Running That Report!
Posted - 2005-06-02 : 13:50:42
