Report device count per collector

[RSAAdmin]

Hi all, I am struggling in generating a report for getting count of total devices integrated with each collector. Can anyone help me to generate this report? Also, how can I trigger an alert if device count is reached the license limit. Thanks,

[RSAAdmin]

Can anybody help me on the above query..

[RSAAdmin]

If all you need is the counts, you can do this right from the Manage Monitored Devices screen. At the top, set up a filter by Collector then after you hit "Apply" you will see the count of devices on the left just above the displayed device list. To get the alert on reaching your device limit, just set up an alert to watch for NIC System events 400025 & 450025

[RSAAdmin]

Thanks Matt, I have congirued the alert. Can you help me, how can I generate the report for this? Yes, I can see the count directly in Monitored devices, but I need to schedule the report every 4 hours.

[RSAAdmin]

Try creating a report with these settings:

Table: NIC System
Fields: count(Device)
SQL where clause: MessageID IN ('508100')
Time Frame: Last Complete Minute


This should reflect the number of devices monitored.