How can I list all my devices which have never uploaded any patch inventory? |
This can be achieved by using a Free Query in BCM.
SELECT DISTINCT DeviceName from Devices WHERE TopologyType='_DB_DEVTYPE_CLIENT_' AND DeviceID NOT IN (SELECT DeviceID FROM InventoryIntegrationData WHERE InventoryType = 'PatchInventory')
|