CMDB - Get all CI related indirectly related to a starting CI

Giovanni Eggidi
Tera Contributor

‎03-26-2024 08:39 AM

Hi,

through Discovery we have populated CMDB with Server Storage, Datastore etc.

From the Storage Server I can navigate this relationship:

"Server Storage --> (Downstream) Storage Volumes --> (Downstream) Datastore Disk --> (Upstream) Vmware Vcenter Datastore --> (Upstream) Vmware Vcenter Datacenter --> (Upstream) ESX Server"

 

I would like to get the list of ESX Servers starting from the storage server (with a report).

I tried creating a CMDB Query Builder, but downstream and upstream relationship in same query generate an error.

Is there a way to use the query builder for this purpose?

 

Thanks & Regards, Giovanni

 

0 Helpfuls
  • 191 Views
1 REPLY 1

AJ-TechTrek
Giga Sage
Giga Sage

‎03-27-2024 04:43 AM

Hi @Giovanni Eggidi ,

 

This is possible if you have discovered the all CI classes and having a relationship with all Child or Parent Classes.

 

ServiceNow Discovery is not populating couple of relationship, you need to merge the two Classes and then you need to use the CMDB Query builder for reporting.

 

Like Esx Server to Virtual Machine  to Host- Network -

                                                                 Host- storage etc -

 

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

 

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/

ServiceNow Community Rising Star 2024

0 Helpfuls