What the values of operation field mean in usp_kpi_ticket_data table?

Products

• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• 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