How to fetch report on Business Application and associated Application Services and Servers.

[Viraj]

I want to create a report where I can have all the incidents created under each Business App under both these Application Service and windows servers linked to it.

For ex- If I select Business App "A" it should show all the incidents created with underlying application services and servers as their CI.

How to go about it?

[jmservicenow]

You may want to take a look at Defined Related Lists here:

https://docs.servicenow.com/bundle/quebec-platform-user-interface/page/administer/form-administration/task/t_CreateDefinedRelatedLists.html

These allow you to build your own scripted query to return results as a related list on whichever table you'd like, in this case, the Business Application table.

[Viraj]

Hi,

Related list won't suffice my purpose as I am looking for reporting based upon the relationship.

For ex- If I select Business App "A" it should show all the incidents created with underlying application services and servers as their CI.

Additionally App Service is L1 relationship and Servers are L2 relationship.

Regards,

Viraj

[rotem1]

A table called "svc_ci_assoc" map ci to application service association.

I tend to believe this should be the direction of basing your report

[Viraj]

Hi,

I checked the table you have mentioned but couldn't find anything constructive.Could you please elaborate a bit more.

Regards,

Viraj