I made this report to make it easier to track the free space on the drives of replacation share machines that are used for replication share data.  Results are sorted so by free disk space with the lowest at the top to save time reviewing.

Just replace SERVER#/WINXP# and the corresponding drive letter you want to monitor in the code and you should be set. 

I have this set up in the Schedule Reports section so it gets emailed to me every morning for review.

Hopefully this can be useful for someone. 

Also, if anyone else has a better way of doing this, please let me know.  I can report on a label I have for my replication machines, but this pulls all of the drives and I only want/need to list the drive used for replication share data (for each machine).  Thus this approach.

John

______________________________________

*Title*
Replication Shares Drive Space

*Report Category*
Replication Shares (Custom)

*Description*
Lists available HDD space on HDD used for storing KBOX Replication Share data (patches, scripts, MIs, etc).  
Monitor daily to ensure HDD doesn't fill up as this would prevent updates from working.

*SQL Select Statement*
SELECT MACHINE.NAME AS SYSTEM_NAME,MACHINE_DISKS.DISK_FREE,MACHINE_DISKS.NAME AS DISK_NAME
FROM MACHINE_DISKS  
JOIN MACHINE ON (MACHINE.ID = MACHINE_DISKS.ID)
WHERE ((MACHINE.NAME = 'SERVER1') AND (MACHINE_DISKS.NAME like '%Drive T:%'))
OR ((MACHINE.NAME = 'SERVER2') AND (MACHINE_DISKS.NAME like '%Drive W:%'))
OR ((MACHINE.NAME = 'SERVER3') AND (MACHINE_DISKS.NAME like '%Drive F:%'))
OR ((MACHINE.NAME = 'WINXP1') AND (MACHINE_DISKS.NAME like '%Drive C:%'))
OR ((MACHINE.NAME = 'WINXP2') AND (MACHINE_DISKS.NAME like '%Drive C:%'))
OR ((MACHINE.NAME = 'WINXP3') AND (MACHINE_DISKS.NAME like '%Drive C:%'))
OR ((MACHINE.NAME = 'SERVER4') AND (MACHINE_DISKS.NAME like '%Drive E:%'))
OR ((MACHINE.NAME = 'SERVER5') AND (MACHINE_DISKS.NAME like '%Drive F:%'))
OR ((MACHINE.NAME = 'SERVER6') AND (MACHINE_DISKS.NAME like '%Drive E:%'))
OR ((MACHINE.NAME = 'WINXP4') AND (MACHINE_DISKS.NAME like '%Drive C:%'))
OR ((MACHINE.NAME = 'WINXP5') AND (MACHINE_DISKS.NAME like '%Drive C:%'))
OR ((MACHINE.NAME = 'SERVER7') AND (MACHINE_DISKS.NAME like '%Drive E:%'))
OR ((MACHINE.NAME = 'SERVER8') AND (MACHINE_DISKS.NAME like '%Drive D:%'))
OR ((MACHINE.NAME = 'WINXP6') AND (MACHINE_DISKS.NAME like '%Drive C:%'))
OR ((MACHINE.NAME = 'WINXP7') AND (MACHINE_DISKS.NAME like '%Drive C:%'))
ORDER BY MACHINE_DISKS.DISK_FREE

*Break on Columns*
<blank>