Script to find system info..

Question

Post reply

Script to find system info..

Paresh Prajapati

SSCertifiable

Points: 7567
More actions
November 26, 2008 at 10:35 pm

#128856

Is there any SQL scripts to find out system/os info..like disk/Drive space info
_____________________________________________________________________________________________________________
Paresh Prajapati
➡ +919924626601
http://paresh-sqldba.blogspot.com/[/url]
LinkedIn | Tweet Me | FaceBook | Brijj

Viewing 5 posts - 1 through 4 (of 4 total)

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

Atif Hall of Fame Points: 3578 More actions · Answer 1

Please check these one by one for space

sp_msforeachdb 'dbcc showfilestats'

GO

sp_msforeachdb 'sp_spaceused'

GO

sp_databases

GO

DBDigger Microsoft Data Platform Consultancy.

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 2

Paresh Prajapati (11/26/2008)
Is there any SQL scripts to find out system/os info..like disk/Drive space info

I think you should be more specific what you're looking for. There are lots of scripts available to get all kind of information. If you're looking for freediskspace use xp_fixeddrives.

[font="Verdana"]Markus Bohse[/font]

Kendal Van Dyke SSCertifiable Points: 5972 More actions · Answer 3

If you're looking for OS level configuration information (e.g. what services are running, how many processors, etc.) try this:

Network documentation with SQL 2005 and SYDI

Part of what I suggest requires running a VBScript that uses WMI to gather information and bulk insert into SQL, but once it's in SQL you can use XQuery to find out quite a bit about your server.

Kendal Van Dyke
http://kendalvandyke.blogspot.com/[/url]

Tom DiCenso SSC Enthusiast Points: 177 More actions · Answer 4

-- This will display Drive Space.

CREATE TABLE #FixedDrives

(DriveLetter VARCHAR(10),

MB_Free DEC(20,2)

)

INSERT INTO #FixedDrives EXEC Master..XP_FixedDrives

SELECT * FROM #FixedDrives

DROP TABLE #FixedDrives