Video Screencast Help

SQL Query to determine when Report last ran in Altiris CMDB 7.1

Created: 30 Jan 2014 | 1 comment

I have a windows service that can create a ticket through webservices in our ticketing sytem we currently use and would like to automatically create tickets for certain exceptions that come up as emailed reports. While I was able to connect to the Symantec CMDB for the Altiris 7.1 NS with the application, I am not sure what tables to check to see the current report results from the last run and when that report was last run.

I am guessing the last run of a report is stored in Inv_Audit, but I don't know where the custom report guid is. Currently the report is emailed, but what I would like to do is have it automatically scrape the report and create a ticket for anything that doesn't already have a ticket. Not creating a duplicate ticket is easy since the webservice has an intermediate database to keep track of what it has already made a ticket for, however I just need an SQL query to pipe the data to the webservice from the Altiris NS 7.1 CMDB.

Any ideas on what table's I can pull this info from?

Operating Systems:

Comments 1 CommentJump to latest comment

Igor Perevozchikov's picture

Hi

as far as I can see, SMP already has such default report "Report execution on Selected Day":

  • Open SMP Console ⇒ Reports ⇒ expand "Notification Server Management" ⇒ expand "Report History" ⇒ Report Execution on Selected Day.

Looks like "Evt_NS_Report_Run" table will help you to create such custom SQL Query and include it in new "Automation Policy".

Thanks,

IP.

iddqd idkfa idclip