Hardware Information

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

  • What information are you looking for?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    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
  • 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.

  • 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)

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

  • 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.

  • 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

  • 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

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

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

    - 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

  • no more information ?

  • e.g.

    List Installed Software

    http://www.microsoft.com/technet/scriptcenter/scripts/apps/user/usapvb06.mspx

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

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

    - 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

  • xp_cmdshell 'systeminfo /S MyServerName'

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

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