[b]Low free Disk space Report modification[/b]

[fargo]

Hello

I have just got SMS up and running and I'm looking at the Reporting.
Can anyone tell me how to modify the report
"Computers with low free disk space (less than specified MB free)"
So that the D:\ partition is queried ??

thanks in advance for any help.

 

[ncotton]

D ONLY or C and D?

Hope this Helps.

Neil J Cotton
njc Information Systems
Systems Consultant

 

[ncotton]

Here is the report modification for D: only query

SELECT SYS.Name, SYS.SiteCode, LDISK.Description0,LDISK.DeviceID0, LDISK.VolumeName0, LDISK.FileSystem0,
       LDISK.Size0,LDISK.FreeSpace0
FROM v_FullCollectionMembership SYS
join v_GS_LOGICAL_DISK LDISK on SYS.ResourceID = LDISK.ResourceID
WHERE 
      LDISK.DriveType0 = 3 AND
      LDISK.DeviceID0 = D: AND
      LDISK.FreeSpace0 < @variable AND
      SYS.CollectionID = @CollID
ORDER BY SYS.Name

Hope this Helps.

Neil J Cotton
njc Information Systems
Systems Consultant

 

[ncotton]

with ' around the D: sorry

...
LDISK.DeviceID0 = 'D:' AND
....

Hope this Helps.

Neil J Cotton
njc Information Systems
Systems Consultant

 

[ncotton]

LOL...just seen you're post over at MYITF

Hope this Helps.

Neil J Cotton
njc Information Systems
Systems Consultant