Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Hardware Information Expand / Collapse
Author
Message
Posted Saturday, September 06, 2008 3:08 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, March 02, 2014 5:36 AM
Points: 20, Visits: 237
Can you please help me to get Hardware information and system information from operating system by using SQL script
Post #564999
Posted Saturday, September 06, 2008 4:53 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:31 AM
Points: 41,505, Visits: 34,420
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
Posted Saturday, September 06, 2008 7:13 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 8:20 PM
Points: 32,764, Visits: 14,928
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
Posted Saturday, September 06, 2008 12:15 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:14 AM
Points: 5,844, Visits: 12,571
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
Posted Saturday, September 06, 2008 8:13 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 8:20 PM
Points: 32,764, Visits: 14,928
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
Posted Sunday, September 07, 2008 1:22 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, March 02, 2014 5:36 AM
Points: 20, Visits: 237
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
Posted Sunday, September 07, 2008 3:12 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 11:34 PM
Points: 6,996, Visits: 8,409
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

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


Johan


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

- 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"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #565105
Posted Monday, September 08, 2008 1:10 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, March 02, 2014 5:36 AM
Points: 20, Visits: 237
no more information ?
Post #565239
Posted Monday, September 08, 2008 1:30 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 11:34 PM
Points: 6,996, Visits: 8,409
e.g.
List Installed Software
http://www.microsoft.com/technet/scriptcenter/scripts/apps/user/usapvb06.mspx


Johan


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

- 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"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #565243
Posted Thursday, June 10, 2010 4:29 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, March 28, 2014 3:23 PM
Points: 71, Visits: 261
xp_cmdshell 'systeminfo /S MyServerName'
Post #935776
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse