/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Kace Report - low space on C: drive

05/17/2016 1648 views
I am trying to report on desktops within my environment that have C: drives that are 85% or more full. I have tried using the oob reports as well as attempted to modify or create a fresh report without much success. I can get a listing of computers with 85% or higher utilization, but I cant seem to narrow it to only showing ones that the C drive is getting full.

I need to see machines that are 85% full on their C drive only, and do not contain the label "Servers". Alternatively, I could limit it to not include server O/S if I could find a way to create a custom inventory rule.

Any assistance would be greatly appreciated.
Answer Summary:
0 Comments   [ + ] Show comments

Comments


Answer Chosen by the Author

0
This finds machines that do not have a Server OS and are 85+ percent full

select MACHINE.NAME as MACHINE_NAME, 
MACHINE_DISKS.DISK_FREE as DISK_FREE_SPACE_GB
from MACHINE_DISKS  
left join MACHINE on MACHINE_DISKS.ID = MACHINE.ID
where  MACHINE_DISKS.PERCENT_USED > '85' AND MACHINE_DISKS.NAME LIKE 'Drive C:%' 
AND OS_NAME not like '%server%'
 group by MACHINE_DISKS.ID
 order by MACHINE_NAME
 
Answered 05/17/2016 by: rockhead44
Red Belt

 
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