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

book

Article ID: 212671

calendar_today

Updated On:

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

 

Attachments