Powershell script to monitor CSV Freespace

There is no SCOM management pack to monitor the freespace on you’re CSV’s.
This can be an issue when you use Dynamically Expanding VHD’s which are common used as boot disks.

Hopefully Microsoft will create a SCOM Management pack, but until that time at least I know I won’t be suprised by VM’s pausing because my CSV ran out of space.

Therefor I used a Powershell script posted on the MSDN blog : http://blogs.msdn.com/b/clustering/archive/2010/06/19/10027366.aspx created by Simon Perriman

To use the scripts first run : “Set-ExecutionPolicy unrestricted” on the machine which will execute the script.

Prerequisites:
– The script must be run on a Cluster Node

Usage
Mandatory :
– Threshold (When the FreeSpace % hits under this value it will be logged)
– HIGHPRIO (When the FreeSpace % hits under this value the mail will be marked as High Priority)

Optional :
– [[-Logging] ] (Output to screen)
– [[-MailLog] ] (Output to mail)
– [[-Mailto] ] (Mandatory when output to mail is used)
– [[-From] ] (Mandatory when output to mail is used)
– [[-Subject] ] (Mandatory when output to mail is used)
– [[-Smtpserver] ] (Mandatory when output to mail is used)
– [[-CompleteLog] ] (Table of all CSV’s Size, Used, Free and Percentage free)
– [[-Exclusions] ] (If you would like to exclude some CSV’s seperate by comma, it’s only excluded from Threshold, on HIGHPRIO Threshold it will be included)

Examples :
Get-CSVFreeSpace –Threshold 10 –HIGHPRIO 4 -Logging $true
Get-CSVFreeSpace –Threshold 10 -HIGHPRIO 4 –CompleteLog $true –Logging $true
Get-CSVFreeSpace –Threshold 10 -HIGHPRIO 4 –MailLog $true –Mailto ‘someone@somewhere.com’ –from ‘someone@somewhere.com’ –subject ‘CSV Freespace’ –smtpserver ‘mail.somewhere.com’ -Exclusions “CSV1″,”CSV2”

The Script : csv.zip
If you would like to schedule the script on a Windows Server 2008 r2 Server you can use this template to import the schedule : CSV FreeSpace Result.zip

Simply extract all the files from csv.zip and CSV FreeSpace Result.zip in C:\Support and import the CSV FreeSpace Result.xml in the Task Scheduler. 
Edit the csvreport.ps1 script and change the parameters to you’re needs (mailto, from, smtp etc.)

Good luck with this script.