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. 

[SanjivMeher]

You need to create report on cmdb_ci table and then expand the field you have on cmdb table pointing to the custom table. Then you should be able to add fields from the custom table to your CI Report

[John Prahn]

Unfortunately it does not have the + sign next to it

 

[SanjivMeher]

Is that a reference field on your cmdb_ci table or just a string field?

Also is the table 'Additions' extended from Task table?

If it doesnt work out, You will have to create a Database view

[John Prahn]

It's a list field referencing the Additions table, which is actually extended from the Contract table. 

[SanjivMeher]

Ok. You need a database view then to join the two tables.

You can get some help using below blog

https://community.servicenow.com/community?id=community_blog&sys_id=0b5eeaaddbd0dbc01dcaf3231f96198d...