SQL Query to determine when Report last ran in Altiris CMDB 7.1
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?