We're looking for reporting to be able to display in a single report per record/per line containing All Database Instances and its attributes/fields on the form, the parent MSFT SQL Instance that contains the database instance, the Server that hosts MSFT SQL Instance, and the Business Applications that depends on::Used by MSFT SQL Instance as columns on the report.
What is the best way to report on all these in a single report? Is there anything we have not thought of?
We've attempted database view but can only show the parent MSFT SQL Instance of database instance. How would we get the Server that hosts the MSFT SQL Instance? What would the where clauses look like?
This solution got us what we were looking in terms of having it on one record/per line all the details. However, we don't have oversight of the server and/or business application.
We've attempted Configuring the List Layout in the cmdb_ci_rel table however the records are next to each other by parent class rather than in the same record/per line like database view.
This solution could get us all the data but multiple records if grouped by parent class or child class but not in the format we were looking for in one line.
Any other solutions we may not have entertain or consider for this use case?
