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:
Please log in to answer
Posted by:
rockhead44
7 years ago
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 7 years ago
