Recovery Solution Consolidated Free Space Notification Policy

One of the challenges that you may face as you scale up your Recovery Solution environment is keeping track of how much free space is left on your Recovery clusters.  It was easy enough to generate a simple report to sum up all the SpaceUsed, SpaceFree, and MaxSize columns in the RawVolume table (which tracks the storage space for each storage location you define in your RS Cluster configuration).  I converted that simple report into a iterative query using a cursor that checks free space for each RS cluster, adds that to a temp table, then exports all the results and emails them to a defined list of users via email.  Quite a time-saver when you have ~16 Recovery Clusters to keep an eye on!

To use it, just import it into your NS console with Recovery Solution installed, edit the Email Automated Actions, enable the Policy, then click "Test Notification Policy".  Just like that, you'll get a daily snapshot of Recovery space utilization and you won't have to go checking each cluster's Storage tab all the time!