I want to Create an individual report for each separate Business Application in the CMDB

[seanosull]

I would like to have a report(s) that gathers details from the Business Applications in the CMDB.  It's sort of unique in that I want a separate report for each Business App.  These will be directed to a folder named after the application.     To be clear, I dont want one report with all my Business Applications in it..... I want one report for each application.   There are 2500 of them.   

This is to feed a cyber recovery process.   Putting the details into a cyber vault.   Each application would have a folder in the vault.  We would put collect details from CMDB about that application and drop it to the folder.   We might pull app details, app service details, dependency info, and even knowledge.   

My issue is that I dont know how to have a process that would write a report for each app....without writing a specific report for each application....    

[Kieran Anson]

Hi,

For clarification, what should each of these reports contain? Just a list report with a set number of columns? Do you have a template of a report you'd effectively like to carbon copy for each app?

[seanosull]

I want to pull information about the application from CMDB.  This would be things like dependancies, Related Servers, Application Support contacts, we also have related knowledge with things like recovery procedures.   

In short I want to create a little package of details for each application.   The details collected for each app would be the same.....but I want individual reports for each application.   

This is for a cyber vault...in case the worst happens.   Imagine SNOW not available and my corporate network gone.....these are details for the rebuilding in a worst case scenario.   

[Kieran Anson]

Because you're wanting to pull different kinds of structured data, and from multiple locations within SN, I'd recommend building a pulling mechanism rather than a push.

Some sort of scheduled job that

1. Looks up all the business applications
2. For each application, looks up related records based on your definition
3. Saves to a folder / location of your choosing

This could be something done by a middleware platform, or just a small python/powershell script.

Because you're wanting these on a per application bases, something like Schedule an export (servicenow.com) isn't going to cut the mustard.

[seanosull]

Thanks for your help!   We were just starting to look at scheduled export to pdf...   because if I do one manually  I  can make it looks exactly as I need it....   Just have to run a bunch of them....

You dont think that is possible as a scheduled scripted job?