ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
What the values of operation field mean in usp_kpi_ticket_data table?
Article ID: 15452
Updated On:
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
Feedback
Yes
No
Powered by
