question Re: How to view 2 different CI Relationships Types in the single report in CMDB forum

How to view 2 different CI Relationships Types in the single report

Nurulaslah Anua — Fri, 18 Oct 2024 10:56:40 GMT

Hi,

I would like to create a report from 'cmdb_rel_ci' table and combination of 2 different types:
1) 'Used by::Uses' (to list all esx servers under Child) and
2) 'Registered on::Has registered' (to list all VMs under Parent field).

The report should list all VMs (available in the Parent field) within the same vCenter (available in the Parent field).

I created a db view, but unable to get this view.

sample:

Can I use db view? if yes, what would be the appropriate WHERE clause?

Thank you

Re: How to view 2 different CI Relationships Types in the single report

Dr Atul G- LNG — Fri, 18 Oct 2024 12:34:01 GMT

Hi @Nurulaslah Anua

I tried :

The format shared is not possible but above should work.

Re: How to view 2 different CI Relationships Types in the single report

Nurulaslah Anua — Mon, 21 Oct 2024 03:12:10 GMT

Hi @Dr Atul G- LNG ,

Thank you for your response.

However, this is not what I mean.

If you see the screenshot, I captured from the cmdvb_rel_ci table,

First, I will search for the vCenter name under the Parent field using the type "Used by::Uses." Then, it will list all the ESX hosts under the child.

After that, from one of the ESX hosts, I can list all VMs using the type "Registered on::Has registered." The VM name will be listed under the parent's name again.

In a single report, with just one search, I can see vCenter (Parent column) , ESX host (child column) and VMs (Parent column).

Thank you.

Re: How to view 2 different CI Relationships Types in the single report

Dr Atul G- LNG — Mon, 21 Oct 2024 14:01:32 GMT

Hi @Nurulaslah Anua

You cant get the same view , means the cell merging and all not possible in SN.