How to get a device count of devices being shown in the NetOps Portal that come from the Data Aggregator

Products

• Network Observability
• CA Performance Management

Issue/Introduction

I am looking to obtain a count of the devices being shown in the NetOps Portal that come from the Data Aggregator

Environment

All supported releases

Resolution

This can be accomplished through a NetOps Portal MySQL call:

select count(*) from netqosportal.dst_device where sourceid=(select sourceid from netqosportal.data_sources2 where sourcetype=262144);