Devices Without an Action Policy

Mike Rockwell (Progress Software) asked a question.

March 9, 2023 at 6:35 PM

This will return devices with no action policy assigned at the device level

SELECT DISTINCT nDeviceID
FROM            Device
WHERE        (bRemoved = 0) AND (nDeviceID NOT IN
     (SELECT DISTINCT Device.nDeviceID
      FROM  Device INNER JOIN
      ActionPolicy ON Device.nActionPolicyID = ActionPolicy.nActionPolicyID
      WHERE (Device.bRemoved = 0)))

WUG Dynamic Groups

Related Questions