I’ll second that! We’ve been looking for solutions to find the reports that aren’t used in more than a year and so on. We have too many users and too many reports for a person by person audit as Jeri suggested, though I like the certainty that method provides. --Jessica Jessica Milby Assistant Director for Collection Information t 215-684-7283 f 215-235-0035 Philadelphia Museum of Art PO Box 7646, Philadelphia, PA 19101-7646 www.philamuseum.org From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Bethany Bannister-Andrews Sent: Thursday, July 14, 2016 4:40 PM To: [log in to unmask] Subject: Re: TMS Report Audit Thanks, Chad! That would be excellent! Although it wouldn’t help me now, having this subreport included in reports could help this process in the future and I’d be all for it. A webinar, instructions on how to do this, etc, would be great! Thanks, Bethany From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Chad Petrovay Sent: Thursday, July 14, 2016 4:32 AM To: [log in to unmask]<mailto:[log in to unmask]> Subject: Re: TMS Report Audit Bethany, This information is not natively tracked in TMS. I believe that Danielle Uchitelle has developed a process where you insert a subreport into a Crystal Report, and that subreport calls a stored procedure. The stored procedure takes data (like the date, time, report, etc) and writes it to a custom table in TMS. Since this is called every time the report is run, you get a running log of report usage. She has mentioned this to me on a few occasions, but I have never seen it in action. Nevertheless, in my professional opinion, there is nothing science-fiction-y about this and it is entirely plausible. But she could provide you with more details. I'm sure if this thread garners enough attention, it might even become a Gallery Systems webinar. ~Chad On Wed, Jul 13, 2016 at 10:17 PM, Bethany Bannister-Andrews <[log in to unmask]<mailto:[log in to unmask]>> wrote: Hi, everyone, Attempting to revive this thread from 2014 -- is there an SQL query that will pull report usage data? Is this at all tracked in TMS? I'm cleaning up our reports and this would be incredibly helpful. Thanks! Bethany Bethany Bannister-Andrews Registrar, Shangri La Doris Duke Foundation for Islamic Art 4055 Papu Circle Honolulu, Hawaii 96816 808-792-5505<tel:808-792-5505> [log in to unmask]<mailto:[log in to unmask]> www.shangrilahawaii.org<http://www.shangrilahawaii.org> To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed.