Central management console

[former_member722026]

I need a report that tracks the duration of each report that is scheduled in CMC...Is there any report template or log out there to track this? Thanks

[DellSC]

There is data for this in the Audit database, so you should be able to create a report using the Audit universe. You're looking for Event Type = 'Run'. In the ADS_EVENT table, there is a field called "Duration_ms" that should contain the info you're looking for.

-Dell

[former_member722026]

I tried to create a crystal reporting using Audit db, but I don't see that db, so I poked around in CMC and saw this...so does this mean I dont have that Audit Db option?screenshot-2021-01-04-135727.jpg

[DellSC]

Possibly - if that's the only CMS in your system, then yes. On that same screen, lower on the right side is connection information for the audit database that should have been configured during your install. I would verify that that information is correct, including the database password. If you need to make any changes, you'll need to restart the SIA for it to take effect.

-Dell