September 6, 2008 at 3:08 am
Can you please help me to get Hardware information and system information from operating system by using SQL script
September 6, 2008 at 4:53 am
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
September 6, 2008 at 7:13 am
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.
September 6, 2008 at 12:15 pm
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)
---------------------------------------------------------------------
September 6, 2008 at 8:13 pm
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.
September 7, 2008 at 1:22 am
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
September 7, 2008 at 3:12 am
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
September 8, 2008 at 1:10 am
no more information ?
September 8, 2008 at 1:30 am
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
June 10, 2010 at 4:29 pm
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