Archiving outdated incidents

The number of outdated incident records is constantly increasing every day, and after years of usage the system accumulates thousands of such records. Not many outdated incident records are actually used, whereas the remaining records, which are no longer used, have a negative impact on performance. For such cases, Matrix42 Software Asset and Service Management provides the archiving functionality. This section describes the working principle of this functionality.

Let's assume that a large company would like to improve its incident management process by archiving incidents that have the Closed status, with the closure date that is older than two years. To implement the archiving functionality, the administrator should log into Matrix42 Software Asset and Service Management and do the following:

1. Click Administration > Schema > Configuration Items.
2. In the Name field under the search criteria, enter Incident, and then press <Enter>.
3. Double-click the Incident configuration item to open it.
4. Click the Advanced dialog page.
5. Under Archiving, select the Enabled checkbox, and then enter the following ASQL expression in the ASQL Expression field:

   "RelatedSpsCommonClassBase.State = 204 AND RelatedSpsActivityClassBase.ClosedDate < DATEADD(yy, -2, GETDATE())"

   where 204 means that the status is Closed.

   It is possible to change the incident status and the date of this status in the ASQL expression. For example, if you want to archive the incidents that were created more than two months ago, but have not been closed yet, the expression will be as follows:

   "RelatedSpsCommonClassBase.State = 200 AND RelatedSpsActivityClassBase.CreatedDate < DATEADD(mm, -2, GETDATE())"

   where 200 means that the status is New. In addition, if you want to archive a specific incident, for example, INC00003, use RelatedSPSActivityClassBase.TicketNumber='INC00003'.
   
   
6. Click DONE at the bottom to save and close. 
7. Click Administration > Services & Processes > Engine Activations and run the Archiving Activation engine activation to check if archiving is enabled for incidents. If it is enabled, then the incidents that meet the previously defined ASQL criteria will be archived and moved to the Archived Incidents sub-tabulator of the Incidents tabulator.