SQL to pull a report from the logs for auditing

[mbmarciniak]

I'm looking to pull information from the logs on anything that was "modified" or "changed" in the last month and put it to a flat file so I have this information for our year end auditing. We have just upgraded to 6.2. Any help would be appreciated - thanks

[opsteamprod1]

We have this issue as well, looking forward to responses.  Thank you.

[Derrick Au]

Hi all,

Here's a simple query against the Admiral database: msglog and jobmst tables, and please feel free to make any adjustments to fit your reporting needs.

SELECT jobmst.jobmst_prntname, jobmst.jobmst_name, msglog.* FROM msglog
JOIN jobmst ON jobmst.jobmst_id = msglog.jobmst_id
WHERE msglog_text LIKE '%modified%'
AND msglog_crtdt <= getdate()-30                        -- looks back 30 days
ORDER BY msglog_crtdt

Regards,

Derrick Au

[mbmarciniak]

Thank you - that worked.