locked
incident activation history data RRS feed

  • Question

  • Hello, I'm familiar with the IncidentResolution table which stores incident resolution information. However, do you know if the CRM DB has a table that stores a record when a CRM incident is activated?

    An incident can be activated and resolved many times. The business wants to be able to query a history of periods between incident activation and resolution. I don't think CRM stores activation history for an incident OTB.

    Can you please confirm that CRM does not store activation history anywhere? Obviously, the incident createdon date would be the first activation date, but I'm looking for a queryable history of subsequent activation dates.

    Tuesday, April 8, 2014 7:56 PM

All replies

  • You could turn on auditing for Cases and then query the audit log for incident StateCode changes.

    The postings on this site are solely my own and do not represent or constitute Hitachi Solutions' positions, views, strategies or opinions.

    Tuesday, April 8, 2014 8:19 PM