Symantec Developer Group

 View Only
Back to discussions
Expand all | Collapse all

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

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

    Posted Jan 30, 2014 02:44 PM

    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?



  • 2.  RE: SQL Query to determine when Report last ran in Altiris CMDB 7.1

    Broadcom Employee
    Posted Apr 29, 2014 01:58 AM

    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.