How to create a dynamic label to capture all Windows machines with more drives than just C:
Hi There,
I need help creating a dynamic label that captures all Windows machines that have more mounting points/volumes/disks other than the C: drive. I am deploying Bitlocker with Kace and just realised some machines have a different combination of drive letters (C:-D:, C:-H:, C:-Z: etc). I tried creating the labels but it seems I am missing something as I am always getting machines that don't have any additional drives for some reason. Can anybody help, please?
Thanks.
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
chucksteel
5 years ago
This SQL query should work for your smart label:
SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP,
MACHINE.MAC, MACHINE.ID as TOPIC_ID,
count(D.ID) as DISKCOUNT
FROM ORG1.MACHINE
JOIN MACHINE_DISKS D on MACHINE.ID = D.ID
WHERE MACHINE.OS_NAME like "%Windows%"
GROUP BY MACHINE.ID
HAVING DISKCOUNT > 1
