Report on Application to Server Mapping

[debajyoti]

Hello,

How can I pull out a report with the details of applications to CI (Server) mapping?

My requirement is to identify which all applications are related to/ installed/ mapped on which server.

[bbhd]

I created a report to show that in our environment with two filter conditions:

• Parent.class is Application
• Child.class is Server
  • or Child.class is Linux Server
  • (And repeat the "Or" clauses for each server class you have in your environment

(To filter it down to fewer applications, use "Parent.name is" and give it the application name)

[debajyoti]

Thanks Bill. Can you please let me know which data I need to select on the table? Is it Configuration Item [cmdb_ci]? Apologies on asking so many questions as I am a new user for SNOW.

[bbhd]

Good point!   I forgot to mention that the data table is "CI_Relationship" (cmdb_ci_relationship).

At a minimum, you'll want to select the parent and child columns for your report.   I recommend using the "type" column, too, as that will confirm the relationship type is "Runs on::Runs" (or you can add that as a filter (Type is "Runs on::Runs").

Other than parent/child (and maybe type), your needs and your site's configuration will determine which other columns you add.

Bill

[gyedwab]

Hi Bill,

This report is great, but it's important to note that it'll bring you back any servers that are directly associated to applications. But if the server is related to another server that is related to the application, it won't show up.

For example, in the following relationship:

Database Server > Application Server > Email Application

You'll only pick up the application server in that report.

To run reports that walk the whole hierarchy, you can use Explore Analytics' Business Service Reporting functionality.