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.

Need the ability to export devices with their associated Data Collector from CAPC


Article ID: 212671


Updated On:


CA Performance Management - Usage and Administration


We are currently under an audit and require to show inventory per each of our Data Collectors.  Requesting help building a query via Vertica (Aggr) or MySQL (console) to pull inventory for each of the DC.




DxNetOps Performance Management 20.2.x



1. Go to http://DA:8581/odata/api/getDataCollectors and note the 'ID's'

2. Build the following query in OdataQuery

Where 7710 represents the ID of a collector captured from step #1

The 'select' can be tweaked as needed to add different fields.  This will give you a list of devices per collector