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|
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
where status_lookup_id = 600
and action = 'Closed'
order by number
Article URL http://www.symantec.com/docs/HOWTO9939