Need more information related to ci_type and ci_identifier columns in ServiceNow Events (em_event) table

Milan Parmar
Kilo Explorer

Hey everyone,

Can someone help me to understand what is the ci_identifier and ci_type columns in ServiceNow Events (em_event)  table?  Can anyone share some examples that what kind of data/values can be populated in ci_identifier and ci_type columns? 

find_real_file.png

I was looking at one of the docs (https://docs.servicenow.com/bundle/sandiego-it-operations-management/page/product/event-management/concept/c_EMIntegrateRequirementEvent.html) and it seems like ci_type is a JSON string that represents a configuration item. For example, {"name":"SAP ORA01","type":"Oracle"}. However, I do not find the information related to ci_identifier column in this doc.

If someone please enlight me with the use-cases of ci_type and ci_identifier column in Events (em_event) table and the possible values of the ci_identifier column with an example then that would be really really helpful to me.

 

Thanks in advance.

1 REPLY 1

Shreya Jain1
Tera Guru

Both fields ci_type and ci_identifier are used for Alert CI binding. In ci_type you can provide class value like cmdb_ci_apache_web_server or whatever class you want CI to bind to. 

ci_identifier should be in JSON format to uniquely identify CI, like {"key":"value","key":"value"}

So basically it will bind alert to Apache Web Server CI based on ci_identifier.

 

Regards,

Shreya