Query for low hard drive space?

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

Query for low hard drive space?

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> Query for low hard drive space?

Page: [1]

Message

<< Older Topic Newer Topic >>

Query for low hard drive space? - 4/12/2008 12:47:08 PM

patchm00

Posts: 13
Score: 0
Joined: 3/19/2008
Status: offline

Hey guys,

I'm trying to make a query for computers that have less than 5000 MB Free but I keep getting multiple drives that are USB. I try a query that says less than 5000MB Free and drive interface not equal to USB but that doesn't seem to work either. I think he problem is it's looking at all the drives on the computer and as long as one of them is IDE it lists all the drives. Can someone help with a query that does what I want?

Thanks

Post #: 1

RE: Query for low hard drive space? - 4/12/2008 2:43:44 PM

jnelson993

Posts: 900
Score: 127
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

Use the DriveType0 field to limit to local fixed disks (type 3)

SELECT
*
FROM
dbo.v_GS_Logical_Disk
WHERE
driveType0 = 3 AND
FreeSpace0 < 5000

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to patchm00)

Post #: 2