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.
Answer Chosen by the Author
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
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
Please log in to comment
log in to commentPlease