Impact and Urgency fields on Service Desk tickets

book

Article ID: 16627

calendar_today

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

Understanding how the Impact and Urgency fields on Service Desk tickets are stored



What value is stored on the ticket for the Impact and Urgency fields

Environment

WINDOWSLINUX

Resolution

For the impact and Urgency fields on tickets, we store\save the 'enum' value from the respective reference tables.

 

bop_sinfo -dq cr | find "impact"                                                         bop_sinfo -dq cr | find "urg"

RESULT:                                                                                                RESULT: 
impact SREL -> imp.enum                                                                      urgency SREL -> urg.enum

 

However on the GUI we display the 'sym' field that corresponds to the enum value.

The below extracts for the Urgency and Impact tables. This should help with the mapping of what value will be displayed on the GUI based on the enum filed

 

pdm_extract -f "SELECT enum, sym FROM Urgency"

RESULT: 
TABLE Urgency 
enum sym 
{ "0" ,"1-When Possible" } 
{ "1" ,"2-Soon" } 
{ "2" ,"3-Quickly" } 
{ "3" ,"4-Very Quickly" } 
{ "4" ,"5-Immediate" }

 

pdm_extract -f "SELECT enum, sym FROM Impact" 

RESULT: 
TABLE Impact 
enum sym 
{ "0" ,"None" } 
{ "1" ,"5-One person" } 
{ "2" ,"4-Small Group" } 
{ "3" ,"3-Single Group" } 
{ "4" ,"2-Multiple Groups" } 
{ "5" ,"1-Entire organization" }