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:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

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
Tenth Degree Black Belt

Please log in to comment

Answers

Answer this question or Comment on this question for clarity