Creating a report that shows all history associated with an incident
|Article:HOWTO6155|||||Created: 2006-12-26|||||Updated: 2007-10-18|||||Article URL http://www.symantec.com/docs/HOWTO6155|
How can a report be configured to show an incident's entire comment history?
While custom reports are outside the realm of Altiris Support, here is some information about the database that provides a starting point.
To retrieve all comments related to an incident, query the Workitem table or the workitem_detail_view view. It may be helpful to show the version and modified time of the incident for each comment.
Workitem table syntax:
select version, modified_on, comment from workitem where number = <insert desired number here>
select workitem_version, workitem_modified_on, workitem_comment from workitem_detail_view where workitem_number = <insert desired number here>.
For more information about designing reports using Notification Server, see the documentation installed to \Program Files\Altiris\Notification Server\NSCap\Help.
In addition, Altiris Consulting Services can help with more complex reports.
Article URL http://www.symantec.com/docs/HOWTO6155