What the values of operation field mean in usp_kpi_ticket_data table?

Document ID : KB000015452
Last Modified Date : 14/02/2018
Show Technical Document Details
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.

Question:

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
Answer:

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