/build/static/layout/Breadcrumb_cap_w.png

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)

Posted by: chucksteel 4 years ago
Red Belt
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


Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ