How can i extract the Downstream Relationship details and Upstream relationship details from cmdb_ci_server table for each server.
basically i am trying to know the relationship between cmdb_ci_server,cmdb_ci_cluster and cmdb_ci_service_discovery
If i go to the cmdb_ci_server table there is tab called Relations and under that i have two heading like below Downstream relationships and Upstream relationships i need to have those details(Depends On) and used By for each servers
I can't upload the exact screenshot but this one is similar
In the navigation filter type cmdb_rel_ci.list - this will pull up all relationships. Then add a filter where Parent class - is Windows Server. That will give you all relationships and type of relationships:
In the navigation filter type cmdb_rel_ci.list - this will pull up all relationships. Then add a filter where Parent class - is Windows Server. That will give you all relationships and type of relationships:
