A query can be run on the Data Repository (Vertica) system to output a list of all monitored devices along with their total polled item count.
The query to run on the Data Repository system and how to run it:
- Log into the DR system.
- su to the database admin user account (dradmin by default)
- Change diretcory to /vertica/bin (under whichever directory vertica was installed in)
- Run: ./vsql
*The password will be the database password. (dbpassword in the example from the documentation) orthe same password required in the adminTools UI when reviewing or administering the vertica database.
select device_item_id, device_name ,count(*)
group by device_item_id, device_name
order by count(*) desc;