Free Space for each PC within a Collection.

To answer a question posed within the Newsgroups.

 

“I would like to create a report to collection logical hard disk free space by collection rather than by single computer.  Anybody have an example of this?”

 

SELECT CS.Name0,
LD.DeviceID0,
LD.FreeSpace0
FROM v_CM_RES_COLL_SMS00001 COLL,
v_GS_COMPUTER_SYSTEM CS,
v_GS_LOGICAL_DISK LD
WHERE COLL.ResourceID = CS.ResourceID
AND LD.ResourceID = CS.ResourceID
AND LD.DriveType0=3

 

Leave a Reply

Your email address will not be published. Required fields are marked *