Is there a way to tell who added/removed or changed a given report?
I have tried the message center, but there's no luck.
If this information is stored somewhere in the DB, I could probably query it out.
I've seen many other changes audited in the main events log, such as 'node xxx added', 'user changed suchandsuch threshold'. I've not looked for anything around reports, but it may well be listed in there.
Hope that helps!
EDIT: I just checked and on NPM 11.01 there is no such event category for reports, so unless this was added in NPM 11.5, I don't think that reports are currently audited by Orion.
Checked dbo.AuditingActionTypes and found nothing report related.
Worse - it seems while dbo.reportdefinitions has an owner field it does not have any sort of created/modified date
So it would seem your best bet might to subscribe to that table
I wonder if Server and Application Monitor's 'AppInsight for SQL' would do something similar to DLM, i.e. tracking changes in tables?...
That's genius, bluefunelemental, kudos to you for thinking out of the box, sir!
I recommend you log a call with support to get the definitive answer, tragicpixel. If you do, could you post their response in here for others to benefit from our epic fail at working it out ourselves?
Cheers & good luck!
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.