How to obtain a list of devices from Data Aggregator along with their respective polled item count
book
Article ID: 18148
calendar_today
Updated On:
Products
CA Infrastructure Performance
Issue/Introduction
Description:
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.
Solution:
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.
Run:
select device_item_id, device_name ,count(*) from v_poll_item group by device_item_id, device_name order by count(*) desc;