I agree it is a great script.

I did minor mods to to handle checking remote servers. Also, if you fire it from the desktop, it will return the server's name not the workstations name.

This way you can conslidate your data to one location.

------------------------------

CREATE PROCEDURE cp_diskspace

@ServerName sysname

AS

SET NOCOUNT ON

DECLARE @hr int

DECLARE @fso int

DECLARE @drive char(1)

DECLARE @odrive int

DECLARE @TotalSize varchar(20)

DECLARE @MB bigint ; SET @MB = 1048576

if @ServerName is null or @ServerName =''

begin

select @ServerName = @@servername + '.master.dbo.xp_fixeddrives'

end

else select @ServerName = @ServerName + '.master.dbo.xp_fixeddrives'

CREATE TABLE #drives (ServerName varchar(15),

drive char(1) PRIMARY KEY,

FreeSpace int NULL,

TotalSize int NULL,

FreespaceTimestamp DATETIME NULL)

INSERT #drives(drive,FreeSpace)

EXEC @ServerName

EXEC @hr=sp_OACreate 'Scripting.FileSystemObject',@fso OUT

IF @hr 0 EXEC sp_OAGetErrorInfo @fso

DECLARE dcur CURSOR LOCAL FAST_FORWARD

FOR SELECT drive from #drives

ORDER by drive

OPEN dcur

FETCH NEXT FROM dcur INTO @drive

WHILE @@FETCH_STATUS=0

BEGIN

EXEC @hr = sp_OAMethod @fso,'GetDrive', @odrive OUT, @drive

IF @hr 0 EXEC sp_OAGetErrorInfo @fso

EXEC @hr = sp_OAGetProperty @odrive,'TotalSize', @TotalSize OUT

IF @hr 0 EXEC sp_OAGetErrorInfo @odrive

UPDATE #drives

SET TotalSize=@TotalSize/@MB, ServerName = replace( @ServerName , '.master.dbo.xp_fixeddrives',''), FreespaceTimestamp = (GETDATE())

WHERE drive=@drive

FETCH NEXT FROM dcur INTO @drive

END

CLOSE dcur

DEALLOCATE dcur

EXEC @hr=sp_OADestroy @fso

IF @hr 0 EXEC sp_OAGetErrorInfo @fso

SELECT ServerName,

drive,

TotalSize as 'Total(MB)',

FreeSpace as 'Free(MB)',

CAST((FreeSpace/(TotalSize*1.0))*100.0 as int) as 'Free(%)',

FreespaceTimestamp

FROM #drives

ORDER BY drive

DROP TABLE #drives

RETURN

GO