How can I get a count of devices in the Data Repository?

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

How can I get a count of devices in the Data Repository?

Environment

Release : 3.7

Component : IM Reporting / Admin / Configuration

Resolution

Access vsql by choosing the Connect to Database option in adminTools on the Data Repository then get a count of the device table:

select count(*) from dauser.device;