Good Afternoon everyone,

I apologize if this quesiton has already been answered. I'm looking for a quick way to view devices that do not have action policies attached.  I'm currently using Dynamic Groups to look at Systems with specific action policies.  For example:

SELECT DISTINCT Device.nDeviceID
FROM Device
JOIN ActionPolicy
ON Device.nActionPolicyID = ActionPolicy.nActionPolicyID
WHERE ActionPolicy.sPolicyName LIKE N'%Generic Priority%'
AND Device.bRemoved = 0

And this works great for specific priorities, but for auditing purposes, I'd like to be able to see if there are any systems that were added without action policies.

What might be easier (and more accurate for what I'm looking for) is to be able to display devices that do not have specific action policies applied.  For example: Let's say we have a total of 5 action policies that we utilize.  Could we say something like "WHERE ActionPolicy.sPolicyName NOT LIKE N'%Priority1%' or N'%Priority2%'" etc etc?

Thank you for any help you can supply.

~Jeeves