Hi Angie,
I made a report not too long ago that is somewhat like what you are referencing. The attached .rpt file report contains two parameters that work in conjunction with the Select Expert to only report on changes that were made within a specific time period. The report selects records with AuditTrail.EnteredDate greater than or equal to the first date that you select and AuditTrail.EnteredDate less than the second date that you select. The AuditTrail.Entereddate field was altered in a formula in order to compare it against the date selected in the parameters.
This report does not select newly created object records though. I use an advanced query to find those.
Hope this is of some help. Feel free to call if you have any questions or email me direct [log in to unmask].
_________________________________
BRIAN MACELHOSE
Collections Database Administrator
Office: 214-922-1322 | Fax: 214-969-5913
DMA
Dallas Museum of Art | 1717 N. Harwood St. | Dallas TX 75201
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Angela Battalio-Bunker
Sent: Wednesday, June 05, 2013 12:06 PM
To: [log in to unmask]
Subject: Audit trail report by user by date range
Hi,
I am looking to create an audit trail report that is organized by user and with date ranges. Right now when I go to the Objects module, then Maintenance tab, then choose Audit Trail it only seems to bring up the object(s) I’ve chosen on the Object Query screen.
What we are looking for is a report documenting any creation of TMS records as well as changes to existing TMS records by a specific user in a specific date range.
Thanks much,
Angie Bunker
Registrar
Wenatchee Valley Museum & Cultural Center
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.