all the possible columnname values in the AlertHistory table

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

Customer is trying to integrate SOI with third party product.

He is creating SQL queries to pull data from the AlertHistory table but the values in the colunmname use numeric values to represent the actual column name in the Alerts tab.

 

Customer is requesting all possible numeric values and their actual column names.

 

Example:

The column value for the attribute5 is 76549

The column value for Ticket is 73762

Environment

Release : 4.2

Component : Service Operations Insight (SOI) Manager

Resolution

Here are all the possible values for the columnname in the AlertHistory table

 

ACKNOWLEDGED           = 73549 
ALARM_FILTER_MH        = 76374 
ALARM_ID               = 73628 
CREATION_DATE          = 73550 
ESC_RESTART_DATE       = 73551 
ALARM_TITLE            = 76620 
ALARM_CLASS            = 73552 
DESCRIPTION            = 76104 
DEVICEID               = 76105 
MODEL_ELEMENTID        = 76112 
ALERTDETAIL            = 77585 
PRIMARY_ALARM          = 73556 
SEVERITY               = 73558 
PRIORITY               = 76045  
QUEUE                  = 76046 
TICKET_ID              = 73762 
TICKET_PROPS           = 73763 
TICKET_URL        = 73764 
ASSIGNED               = 73559 
ANNOTATION             = 76130 
ANNOTATION_COUNT       = 73670 
UPDATE_HISTORY_COUNT   = 76418 
EVENT_SOURCE           = 73627 
EVENT_SOURCE_ID        = 76137 
EVENT_OCCURRED         = 76098 
LIC_URL                = 76294 
SITUATION_TYPE         = 76296 
CONNECTOR_ID           = 73557 
CLEARED_DATE           = 76297 
CLEARED_BY             = 76304 
USERATTRIBUTE1        = 76545 
USERATTRIBUTE2         = 76546
USERATTRIBUTE3         = 76547
USERATTRIBUTE4         = 76548
USERATTRIBUTE5         = 76549
USERATTRIBUTE6         = 76593 
USERATTRIBUTE7         = 76594 
USERATTRIBUTE8         = 76595 
USERATTRIBUTE9         = 76596 
USERATTRIBUTE10        = 76597

MDR_TICKET             = 76550 
ELAPSED_TIME      = 76551 
IS_CLEARABLE     = 76552 
REPEAT_COUNT      = 76553 
RETIRE_TIMESTAMP     = 76554 
SEVERITY_TREND     = 76555  
SA_CLEARED     = 76556 
SSA_ACKNOWLEDGED    = 76557 
SSA_ASSIGNED        = 76558 
IS_CLEARED_FLAG     = 76559   
UNMANAGED_FLAG      = 76697 
PENDING_CLEAR_FLAG    = 76698  
IS_EXEMPT     = 76696  
LAST_UPDATE_TIME    = 76580   
SERVICE_IMPACT_COUNT   = 76800 
SERVICE_NAME           = 76801 
ROOT_CAUSE_FLAG        = 76572 
SYMPTOM_FLAG           = 76573 
UNCLASSIFIED_FLAG      = 76574  
MDR_IS_ROOT_CAUSE     = 76802 
MDR_IS_SYMPTOM      = 76803 
MDR_SYMPTOM_LIST    = 76804 
MDR_ROOTCAUSE_LIST    = 76805  
PRIMARYIPV4ADDRESSWITHDOMAIN = 76560 
MODIFICATIONTIME      = 76561 
PRIMARYIPV4ADDRESS     = 76562  
PRIMARYIPV6ADDRESS     = 76563  
PRIMARYIPV6ADDRESSWITHDOMAIN    = 76564  
PRIMARYMACADDRESS     = 76565  
PHYSSERIALNUMBER     = 76566 
BIOSSYSTEMID      = 76567 
VENDOR              = 76568  
ASSETNUMBER      = 76569  
PRIMARYDNSNAME      = 76570  
SYSNAME      = 76571 
SYSTEMTYPE                   = 76575 
CUSTOMER_IMPACT_LIST         = 76576  
CUSTOMER_IMPACT_COUNT        = 76577  
CUSTOMER_MAX_IMPACT          = 76578 
CUSTOMER_MAX_PRIORITY        = 76579