The Zurich release has arrived! Interested in new features and functionalities? Click here for more

How to extract and get Related List data from any server in reports

SD_Akshay
Giga Guru

4 weeks ago

Hello All,

 

Need your help in the following requirement

 

We want to generate report of Servers lets say Windows server and want to extract all windows report with the related Database names or Domain or whatever the data which is useful and there in Related Item list.

 

SD_Akshay_0-1756729588501.png

 

We tried to create Database view report but the issue is that we are not able to find connection as those are not present on respective tables.

 

Example:- Windows table does not have any field which have database info or Database table does not have any field which will have which server it is related with. 

 

All details are there in Related Items. So we are not able to do this and consolidate all details in single Report.

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.
Regards
Akshay Kamble (SD_Akshay)
ServiceNow Developer
LinkedIn: https://www.linkedin.com/in/akshay-kamble-1504/
****************************************************************************************************************
0 Helpfuls
  • 251 Views
1 REPLY 1

RaghavSh
Kilo Patron

4 weeks ago

This report need to be build on cmdb_rel_ci table. Filter by relationship type.


Raghav
MVP 2023
LinkedIn
0 Helpfuls