<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
get total disk space per instance from within...
get total disk space per instance from within SQL without cmdshell.
Rate Topic
Display Mode
Topic Options
Author
Message
snomad
snomad
Posted Wednesday, May 11, 2011 5:10 AM
Valued Member
Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:07 AM
Points: 68,
Visits: 374
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!
Post #1106767
Syed Jahanzaib Bin hassan
Syed Jahanzaib Bin hassan
Posted Wednesday, May 11, 2011 5:19 AM
SSC-Addicted
Group: General Forum Members
Last Login: Monday, July 18, 2011 3:54 AM
Points: 492,
Visits: 481
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
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
Post #1106771
snomad
snomad
Posted Wednesday, May 11, 2011 5:23 AM
Valued Member
Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:07 AM
Points: 68,
Visits: 374
Thanks, but I can't use cmdshell - frustrating I know!
Post #1106774
snomad
snomad
Posted Wednesday, May 11, 2011 5:26 AM
Valued Member
Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:07 AM
Points: 68,
Visits: 374
By which I mean I'm prevented by standard operating procs here ... not that there's a technical issue in doing so.
Post #1106778
Ninja's_RGR'us
Ninja's_RGR'us
Posted Wednesday, May 11, 2011 6:21 AM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 6:43 PM
Points: 21,357,
Visits: 9,536
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???
Post #1106815
Ninja's_RGR'us
Ninja's_RGR'us
Posted Wednesday, May 11, 2011 6:22 AM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 6:43 PM
Points: 21,357,
Visits: 9,536
Is powershell an option? I can't code with it but I'm sure google would solve that one for ya.
<oi>sql?
SSIS?
Post #1106816
Ian Scarlett
Ian Scarlett
Posted Wednesday, May 11, 2011 6:26 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 2:12 AM
Points: 1,322,
Visits: 4,400
You could always use SP_OACreate.
Look at this thread for a possible script:-
http://www.sqlservercentral.com/Forums/Topic113227-5-1.aspx
Post #1106824
snomad
snomad
Posted Wednesday, May 11, 2011 6:30 AM
Valued Member
Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:07 AM
Points: 68,
Visits: 374
thanks guys. appreciate your time. i'll have a look @ those options now.
Post #1106834
salimdkg4
salimdkg4
Posted Tuesday, December 11, 2012 3:27 AM
Valued Member
Group: General Forum Members
Last Login: Tuesday, December 11, 2012 3:27 AM
Points: 51,
Visits: 28
itws working
thanxs
Post #1394996
salimdkg4
salimdkg4
Posted Tuesday, December 11, 2012 3:28 AM
Valued Member
Group: General Forum Members
Last Login: Tuesday, December 11, 2012 3:27 AM
Points: 51,
Visits: 28
thnxs
Post #1394997
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
