need a report with business applications, server and software installed on server

[Tanya Rathor1]

Hi All,

Need a report with business application name, server name, software installed on server.

these are three tables : cmdb_ci_business_app , cmdb_ci_server, cmdb_software_instance

please advice 

its very critical for me

Thankyou,

[Rahul Priyadars]

see this thread-

https://community.servicenow.com/community?id=community_question&sys_id=8cd6b963db5c4d10847d5ac2ca9619f1

Regards

RP

[Jim Palmer]

Tanya,

If you follow the thread from Rahul, you'll get the CI links through the relationships table but according the CSDM v3.0 theres no direct link between the Business Application and the server CIs, you have to go though the Application Service, which is an Instance (e.g. dev/test/prod or geographical instances) of a Business Application.

https://community.servicenow.com/community?id=community_article&sys_id=b96b84e7db5fd85011762183ca9619c9

(v4.0 changes it even further, but that's in draft)

so you'll have to add the relationships from the cmdb_ci_service_auto (Application Service) table as well if you want to source from Business Application.

[Tanya Rathor1]

Thanks for your reply,

can we create a database view for these three tables for fetching out the data in report ?

if yes, please suggest

[Rahul Priyadars]

If you have the connection key between 3 tables then seems a nice idea