Drive Space Exceptions

[davealanc]

Hello All,

I am trying to modify the report for available drive space (Disk: Servers less than 1GB free HD). However, I would like to not receive a report for things like quorum drives and etc. How can i modify the canned drive space availability report to only show me C: and D:?

Any insight would be GREATLY appreciated.

Dave

[RCorbeil · Accepted solution]

If you explicitly only want to see drives C: and D:, add a condition to there WHERE clause:

AND tblDiskdrives.Caption IN ('C:', 'D:')