get total disk space per instance from within SQL without cmdshell.

Question

Post reply

get total disk space per instance from within SQL without cmdshell.

snomadj

SSCarpal Tunnel

Points: 4491
More actions
May 11, 2011 at 5:10 am

#389499

For policy reasons I can't enable cmdshell.
I can get disk free space via xp_fixeddrives. But is it possible to get total disk space (ie. free space + used space).
I need this for all drives (so can't minus SQL file sizes off free space as there are non sql files).
I need to run on multiple instances & regularly.
Thanks in advance!

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Syed Jahanzaib Bin hassan SSChampion Points: 11410 More actions · Answer 1

declare @driveName varchar(100)

declare @query varchar(1000)

declare @fsinfo varchar(1000)

set @driveName = 'C'

set @query ='fsutil volume diskfree '+@driveName+':\'

set @fsinfo = 'fsutil fsinfo volumeinfo '+@driveName+':\'

exec xp_cmdshell @query

exec xp_cmdshell @fsinfo

check this T-SQL

My Blog
www.aureus-salah.com

snomadj SSCarpal Tunnel Points: 4491 More actions · Answer 2

Thanks, but I can't use cmdshell - frustrating I know!

snomadj SSCarpal Tunnel Points: 4491 More actions · Answer 3

By which I mean I'm prevented by standard operating procs here ... not that there's a technical issue in doing so.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

Syed Jahanzaib Bin hassan (5/11/2011)
declare @driveName varchar(100)
declare @query varchar(1000)
declare @fsinfo varchar(1000)
set @driveName = 'C'
set @query ='fsutil volume diskfree '+@driveName+':\'
set @fsinfo = 'fsutil fsinfo volumeinfo '+@driveName+':\'
exec xp_cmdshell @query
exec xp_cmdshell @fsinfo
check this T-SQL

Forgot to read again???