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

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?

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


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

Terms of use for this information are found in Legal Notices