/build/static/layout/Breadcrumb_cap_w.png

Kace Report - low space on C: drive

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.

0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: rockhead44 8 years ago
Red Belt
0

Top Answer

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
 

Comments:
  • This worked great! Thank you! - bvanalstine 8 years ago

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