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.

  1. Don't forget that, first you can find an answer for your question in Knowledge base
  2. If answer solves your question, then please mark as solution to close a thread