Writing reports to show the correct closed date instead of the last date modified.

Article:HOWTO9939  |  Created: 2009-03-25  |  Updated: 2009-09-08  |  Article URL http://www.symantec.com/docs/HOWTO9939
Article Type
How To


Question
Some reports that show the closed date show the date incorrectly. Since the incident can continue to be modified even after the incident is closed, the date shown on the report is the date last modified. How can the report be modified to show the date the incident was actually closed?

Answer
To get the exact date that incident was last closed, use the action field of the incident:

select number, max(version), modified_on
from dbo.workitem
where status_lookup_id = 600
   and action = 'Closed' 
order by number


Legacy ID



46261


Article URL http://www.symantec.com/docs/HOWTO9939


Terms of use for this information are found in Legal Notices