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