Need more information related to ci_type and ci_identifier columns in ServiceNow Events (em_event) table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-24-2022 11:07 AM
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?
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.
- Labels:
-
Event Management
-
Service Mapping
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-26-2022 05:21 AM
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