This report lists all machines with a specific drive that has less than a specified amount of free disk space. Tweak the bolded items below to customize the report. You can get rid of the "AND (M.OS_NAME like '%XP%')" section if you don't care about the OS.

SQL Code:

SELECT M.NAME AS Machine, MD.DISK_FREE AS 'Free Space in GB' FROM MACHINE M
JOIN MACHINE_DISKS MD ON (MD.ID = M.ID)
WHERE (MD.NAME like '%Drive C%') AND (MD.DISK_FREE < 1.7) AND (M.OS_NAME like '%XP%')
ORDER BY M.NAME
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
Here's a variation of that idea - looking for disks reporting more than 90% full:

SELECT M.NAME AS Machine, MD.PERCENT_USED AS 'Percent of Drive C Space Used' FROM MACHINE M
JOIN MACHINE_DISKS MD ON (MD.ID = M.ID)
WHERE (MD.NAME like '%Drive C%') AND (MD.PERCENT_USED > '90') AND (M.OS_NAME like '%XP%')
ORDER BY M.NAME
Answered 01/15/2010 by: RichB
Third Degree Green Belt

Please log in to comment
0
Nice modification, Rich. The reason my original report uses a specific amount of free space is because I wrote it to find machines that did not have enough space to download, extract, and install XP Service Pack 3.
Answered 01/15/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
Could you do this report but instead of a specific drive, report on the second drive? The reason I ask is because on some of our servers the second hard drive is D and some it is E, with the CD drive being the other letter. Basically just report on the available space on Disk #2 as listed in the inventory details page. Sorry if that doesn't make sense.
Answered 02/07/2011 by: bsharding1982
Yellow Belt

Please log in to comment
Answer this question or Comment on this question for clarity