Hardware Information

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Development » Hardware Information

Hardware Information

Rate Topic

Display Mode

Topic Options

Author

Message

ikrami2000

Posted Saturday, September 06, 2008 3:08 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 5:01 PM
Points: 15, Visits: 207

Can you please help me to get Hardware information and system information from operating system by using SQL script

Post #564999

GilaMonster

Posted Saturday, September 06, 2008 4:53 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:16 AM
Points: 37,637, Visits: 29,888

What information are you looking for?

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #565008

Steve Jones - SSC Editor

Posted Saturday, September 06, 2008 7:13 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 1:47 PM
Points: 31,406, Visits: 13,722

Most of this stuff you would get from a command line or WMI if you wanted it. SQL Server would then access that the same way, with an XP_CMDSHELL or an XP_REGREAD.

However I'm sure how much detail you'll get. T-SQL isn't really designed for this. You'd need to build something that would find the data and then perhaps import it into SQL Server.

As Gail mentioned, perhaps you should describe the problem in more detail.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #565023

george sibbald

Posted Saturday, September 06, 2008 12:15 PM

SSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 6:23 AM
Points: 5,264, Visits: 11,189

try command line utility sqldiag.exe, this is the tool MS support would want run to extract complete info on the server set up (OS and HW)

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

Post #565063

Steve Jones - SSC Editor

Posted Saturday, September 06, 2008 8:13 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 1:47 PM
Points: 31,406, Visits: 13,722

That will create a bunch of stuff in text files, but it won't get it into SQL Server.

It would help if we knew what the OP wanted to accomplish.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #565084

ikrami2000

Posted Sunday, September 07, 2008 1:22 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 5:01 PM
Points: 15, Visits: 207

Thank you for your replay and let me explain more about my question,

i have an application ( Help Desk ) My developement ( Clarion ) and Database ( MSSQL 2005 ) , i have one module for Hardware Inventory for ( Motherboard , Hard Disk , RAM , Screen , Printer , CD , Processor, .... ) so i want to run Script to collect all of this information once i run my application in that PC and stored automaticlly in my database, i know that my development tools can do that but it is very difecult for some reasons, so this my requirment if it's applicable and thanks again for all

Post #565103

ALZDBA

Posted Sunday, September 07, 2008 3:12 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:25 AM
Points: 6,861, Visits: 8,045

For the moment we are using vbscript to gather WMI information.

You may as well put that into a clr module and get your info that way.
Keep in mind you'll need to activate CLR and grant it PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE Crazy

and you'll need some kind of permission to access the individual WMI objects on each machine.

Johan

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere w00t

- How to post Performance Problems
- How to post data/code to get the best help

- How to prevent a sore throat after hours of presenting ppt ?

"press F1 for solution", "press shift+F1 for urgent solution" BigGrin

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me Hehe

Post #565105

ikrami2000

Posted Monday, September 08, 2008 1:10 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 5:01 PM
Points: 15, Visits: 207

no more information ?

Post #565239

ALZDBA

Posted Monday, September 08, 2008 1:30 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:25 AM
Points: 6,861, Visits: 8,045

e.g.
List Installed Software
http://www.microsoft.com/technet/scriptcenter/scripts/apps/user/usapvb06.mspx

Johan

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere w00t

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me Hehe

Post #565243

Eric1972

Posted Thursday, June 10, 2010 4:29 PM

Valued Member

Group: General Forum Members
Last Login: Sunday, May 12, 2013 12:53 AM
Points: 71, Visits: 246

xp_cmdshell 'systeminfo /S MyServerName'

Post #935776

« Prev Topic | Next Topic »

Permissions