management report to extract all CI

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

I am looking for a report the can extract all of the servers (CI) for SOI with as much related information as possible to a csv or spreadsheet. 

would also be nice to show where in the services it is located. 

Environment

Release : 4.2

Component : Service Operations Insight (SOI) Manager

Resolution

Basically, he will need to create SQL queries to get the info from the SOI Database.

 

The info are in the CIStaging table which would require other tables like ConnectorConfiguration, etc.

 

I provided the link to the SOI Data Dictionary.

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/service-operations-insight/4-2/reference/ca-soi-4-2-data-dictionary.html