How to create Alert Correlation rule for hierarchical level

[Ayush Goyal]

Hello,

I have to create Alert Correlation rule for hierarchical level like if there is a fault in one CI then the CIs that are connected to it physically will also get impacted, so the Primary Alert will get created for main CI and dependent CI will create the secondary Alert.

I have CI when selecting Dependency Type as Physical Network Connections then it will show us the dependency view but the relationship for Physical connections is not available in cmdb_rel_ci table, here in below image you can see the relationship as dependes on : used by but its not available in cmdb_rel_ci table,

How can i access these physical dependencies in my Alert correlation rule?

[Art Guerrante]

I also had the same doubt. I understand that ServiceNow does not actually create these relationships. The system interprets a chain of references between the netgear and router interface, the actual Connects To relationship between the interfaces, and another reference on the other side as a fictional relationship of the type "Depends on/Used By".

The worst part is that, since this relationship does not actually exist, i cannot use it in the suggested relationships table for alert correlation. 

Any help here would be helpful.