Mike Rockwell (Progress Software) asked a question.
Devices with a specific Action Policy assigned
[Originally posted by Christian Lawson]
This group shows all devices that have a particular action policy assigned to the device. Replace the "My Policy" text with the name of your policy. Note: This only displays devices that have the action policy assigned to the entire device. It will not display devices that have said policy assigned directly to an active monitor assigned to the device.
- SELECT DISTINCT Device.nDeviceID
- FROM Device
- JOIN ActionPolicy
- ON Device.nActionPolicyID = ActionPolicy.nActionPolicyID
- WHERE ActionPolicy.sPolicyName = N'My Policy'
- AND Device.bRemoved = 0
Ok that returns the device id from devices which the policy is assigned to (on device level). But if the action policy is assigned to a specific monitor on a device it does not show up. Is for that also a solution availbale?
Could someone suggest how I would need to modify the above query to show the devices which have no specific Action Policy applied? I'm trying to filter my devices so that I can see which devices do not have any specific Action Policy applied.
https://community.progress.com/s/question/0D54Q0000A9qkuSSQQ/devices-without-an-action-policy
Works like a charm! Thanks Mike.