/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


How to create a dynamic label to capture all Windows machines with more drives than just C:

05/19/2019 260 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

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