Reporting on table and pulling values from a related list

[John Prahn]

Hi All, 

I am trying to report off of a custom table and also pull values from the related list. 

As shown below, for the report I am pulling values from the table and I will also need to know how many CIs are related to this table. On the CI record, I have the ability to associate the record to the CI, which shows up on the custom table at the bottom. 

[Alikutty A]

Hi,

You can directly create a list report on the cmdb_ci table and add a filter on the reference column to your custom table. This should list all CIs that are related to your custom record.

Thanks!

[John Prahn]

Thank you. I was able to do that, but the issue is that I need specific information from the custom table, such as different fields. Is that there another way I can get this info?

[Alikutty A]

Yes definitely, you could double click on the reference column and dot walk to all fields available on your custom record and add it on the report.

[John Prahn]

The field on the cmdb_ci form is actually a list with a reference qualifier built in. Could that be the reason why I am not getting the + sign and the ability to dot walk to other fields?