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.



NOTICE: The information contained in this electronic mail message and any attachments hereto is intended only for the personal and confidential use of the designated recipients. This message and any attachments hereto may contain confidential information and communications. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this message in error, and that any review, dissemination, distribution, use or copying of this message and any attachments hereto is strictly prohibited. If you have received this message in error, please notify the sender immediately. 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.