What the values of operation field mean in usp_kpi_ticket_data table?

Article Id: 15452
Status: Published
Updated On: 14-02-2018 07:49
Legacy Id: TEC1740643
Products:
SUPPORT AUTOMATION- SERVER , CA Service Desk Manager - Unified Self Service , KNOWLEDGE TOOLS , CA Service Management - Asset Portfolio Management , CA Service Management - Service Desk Manager
Issue/Introduction:

The "operation" field of the usp_kpi_ticket_data table in Service Desk Manager is used to record the operation types of the KPI data.

Very often system administrators would need to write reports using this field for the KPI reports. The tech doc explains what those

values mean.



what the values of operation field mean in usp_kpi_ticket_data table?

Environment:

windows, Unix/Linux, Service Desk Manager/CMDB 17.0, 14.1, 12.9

Resolution:

There are 5 values for this "operation" field. They are:

0: create/insert
1: delete
2: reopen
3: regular field updates
4: close and any update when the ticket is closed