Reports for Mapped Application Services to Server Hosts

[Anessa Lindenmu]

When we have incidents that happen at one of our data centers, the big question our organization needs to know is what applications are impacted by the outage.  We have quite a bit of our service mapping done and discovery is auto populating the location of our servers from the discovery schedules.  There doesn't seem to be a good report that ties this information together and it does not seem easily accessible.  I started trying to build a CMDB query builder and even found that we don't have a relationship to the application service, it creates a relationship to the HTTP endpoint.  In some scenarios, we can't use the URL and we have it manually mapped which I found creates the relationships another way.  What is the best way to get this information tied together and easily accessible for our end users to understand? 

[Jaya5]

We have also same process and did you got resolved this issue.

[James Behrens]

I would definitely like to know how people are addressing this. We've had database views created, they are super slow. We use SnowMirror to replicate to an MSSQL database locally. I generally just rely on that. We've built several reporting engines outside of ServiceNow. It just feels incredibly wrong on every level.

[Jaya5]

Thank you James for the update, can you please help me to know what was the condition you have given for the database view, it will be really a great help if u could provide me the screenshot steps please.