sccm sql query for finding the logical disk space collection wise

Select coll.name,coll.domain, LDISK.TimeStamp, LDISK.FreeSpace0 ,
LDISK.Description0, LDISK.DeviceID0,
LDISK.FileSystem0, LDISK.Size0
From v_FullCollectionMembership coll
JOIN v_HS_LOGICAL_DISK LDISK ON coll.ResourceID = LDISK.ResourceID
Where LDISK.DriveType0=3 AND
coll.collectionid like ‘%sms0001%’
ORDER BY LDISK.DeviceID0, LDISK.TimeStamp DESC

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s