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

Products

• CA Performance Management - Usage and Administration

Issue/Introduction

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.

 

 

Environment

DxNetOps Performance Management 20.2.x

 

Resolution

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