Reporting for Critical Application Dependency

Paul Glenn
Tera Contributor

‎08-23-2023 07:43 AM

Our DR manager is looking for a way to get a list of servers that are required for our top 25 applications.  I've looked in APM and BCM and I'm not seeing an easy way to get him this information.  Anyone know how I can get him this info?  I know I could go into each application and manually write down each server, however, that isn't optimal.

 

TIA,

Paul

0 Helpfuls
  • 436 Views
1 REPLY 1

Community Alums
Not applicable

‎08-25-2023 11:26 PM

Hi @Paul Glenn ,

Your Question is more of a CMDB related !!

It seems a requirement that can be achieved by using CMDB Query Builder.

Second the CMDB Query Builder! You can quickly grab the nodes and adjust filters to each tables.  From there you can actually create a schedule and then a report that will establish a data source for you to leverage dot walk.

SandeepDutta_0-1693031206878.png

 

SandeepDutta_1-1693031206888.png

 

 

You can check out table svc_ci_assoc table where all applications related to a service is listed. You can fetch applications and servers associated with a service from there.

 

Then you can query the cmdb_rel_ci table to check for all the relationships of that particular servers.

Scripting on these two tables can help you achieving your goal

Below article will help you if you need help in GlideAjax

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