ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

management report to extract all CI


Article ID: 238471


Updated On:


CA Service Operations Insight (SOI)


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. 


Release : 4.2

Component : Service Operations Insight (SOI) Manager


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.