Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Nishant Pandey
Starting Member
2 Posts |
 Posted - 2009-03-27 : 01:17:53
|
| Hello I want T-SQL which can generate System Configuration Details.System Configuration Details like...1. Processor Name (i.e Intel Pentium 4)2. Operation System Name (i.e Windows XP or Vista ..)3. Physical Memory Size (RAM) like 1GB4. HardDisk Size 120 GBIs it possible to get these information through SQL Server ?I know how to get RAM and Hard Disk Size....but i dn't know about remaining fields...Thanks Nishant Thanks Nishant |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-03-27 : 01:22:49
|
| xp_msver |
 |
|
|
Nishant Pandey
Starting Member
2 Posts |
Posted - 2009-03-27 : 02:20:00
|
| Thanks but xp_msver gives information regarding MS SQL Server.Thanks Nishant |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-03-27 : 07:18:07
|
| Best I can think of is:exec master..xp_cmdshell 'systeminfo'This is a less than ideal way of getting this info though. You should look at using Powershell for this, it integrates well with SQL Server but doesn't require it. Here's something to give you an idea:http://www.sqlteam.com/article/monitoring-sql-server-agent-with-powershell |
|
|
|
|
|
|
T-SQL: How to get system Configuration