Need to get an list view of Windows & Linux Servers with business application

[RustamS]

Hi Team,

We need to get an list view of Windows & Linux Servers with end of life operating system with business application. I can get the data for end of life operating system but how can i information for business application as it is tied to an application service. 

Regards,

Rustam S

[AndersBGS]

Hi @RustamS 

@this is the exact usecase for the CMDB query builder.

[RustamS]

Hi AndersBGS,

Thanks, I ended up creating the query builder.

1. First Connection => Added Business application as Parent table => Added Application Service as Child  table => Added relationship levels

2. Second Connection => Parent Application Service => Added Windows Server table as child table => Added relationship levels

After clicking on Run button, it gives me the results for which business application is mapped

However, I am looking for an report where it shows both windows servers with business application and one without business application.

I cannot create a query in reverse order from Windows (Parent) => (Child)Application Service (Parent)=>(Child)Business application.

Is it possible anyway to show both.

Regards,

Rustam Shaikh

[pavani_paluri]

Hi @RustamS ,

In ServiceNow, servers don’t usually point straight to business apps. Instead, the link goes like this:

Server → Application Service → Business Application

So the trick is to follow the relationships in the CMDB.

1. Start with your EOL server list.
2. Use the CMDB relationship table (`cmdb_rel_ci`) to see which application services those servers are tied to.
3. From the application services, roll up to the business application CIs.
4. Build a report or list view that shows all three together:
- Server name + OS version (EOL flag)
- Application service it supports
- Business application linked to that service

If you have Service Mapping in place, this is easy because those relationships are already discovered. If not, you may need to rely on manually maintained CMDB relationships or work with app owners to validate the mapping. Once you’ve got the links, you can automate the report so management sees exactly which business apps are at risk because of outdated servers.

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for

Kind Regards,

Pavani P

[Tanushree Maiti]

Hi @RustamS 

The most efficient, no-code way to generate this view is using the CMDB Query Builder.

1. Navigate to Configuration > Query Builder and create a new query.
2. Add the Server class  and filter it to show EOL Operating Systems (e.g., Lifecycle Stage = End of Life).
3. Add a relationship tie (Runs on / Hosted on) to the Application Service class.
4. Add another relationship tie (Consumes / Depends on) to the Business Application class.
5. Click Save and Run to export this data into a comprehensive list view

refer: https://www.servicenow.com/community/cmdb-forum/list-all-the-application-which-are-linked-to-any-ser...