As per the question, does anyone know where LANDesk stores the lifecycle actions for each Incident, e.g. "Created", "Resolved", "Stop Clock" ?
Specifically I'd like to be able to iterate through the stored lifecycle actions, for a given Incident, and be able to identify the date/time at which they occurred. I don't mind if this is via LANDesk directly, or via Crystal Reports, the key thing I need to know is where this data is stored in the database.
I'm assuming that these lifecycle actions are stored somewhere within the database because I can view the Audit Trail for a given Incident via the LANDesk Console. If they are not stored within the database, then how does the LANDesk Console go about constructing the Audit Trail for a given Incident ?
All help much appreciated, to avoid me having to tear out what is left of my hair!