/build/static/layout/Breadcrumb_cap_w.png
05/19/2019 192 views

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

Comments


All Answers

0

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


Answered 05/20/2019 by: chucksteel
Red Belt