You are viewing limited content. For full access, please sign in.

Question

Question

Daily reports on audit trail database

asked on September 2, 2016

What would be the best way to make daily scheduled reports on the Audit Trail Database possible?  To my knowledge, you have to manually specify which date range you want to populate the database, but I was hoping there was a way to automatically look at the data for the day prior.

0 0

Replies

replied on September 2, 2016

It's true that Audit Trail reports don't allow for dynamic or relative values for date criteria.  The two options I can think of would be to 1) query the database directly with a SQL statement that includes GETDATE(), or 2) have a program generate a link to Audit Trail that includes the desired dates in the url; see this answer for more information.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.