Mike Gill (Customer) asked a question.
How can I make 2 Dynamic Groups: One group that contains all devices that have Monitoring "Setup Critical" enabled, and one group that contains all devices that have Monitoring "Setup Critical" disabled
Here is the Query for devices with Critical Monitoring Enabled:
- SELECT DISTINCT nDeviceID FROM Device
- WHERE (bPollingOrder = 1)
This means that the "Enable critical monitor polling for this device" button it turned on but you may or may not have any critical monitors set.
Here is the query for devices with Critical monitoring NOT enabled:
- SELECT DISTINCT nDeviceID FROM Device
- WHERE (bPollingOrder IS NULL) OR (bPollingOrder = 0)
Thank you so much! I was dreading trying to get the schema and all.. really appreciate it, worked perfect
Here is the Query for devices with Critical Monitoring Enabled:
This means that the "Enable critical monitor polling for this device" button it turned on but you may or may not have any critical monitors set.