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.

[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