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 |
|
kdnichols
Posting Yak Master
232 Posts |
 Posted - 2007-07-11 : 15:32:13
|
| Hello,I am obviously a newbie. How do I get the following information automatically using a script or service? What should I be doing to achieve this?Machine type (DL380, DL580, etc)CPU count, type, and speedPhysical memoryPhysical storageDetermine if fiber card is installedHardware end-of-lifeLOB NameLOB ContactLOB Customer nameWhat books are out there that anyone knows of that can help me with this?Thanks,Kurt |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-11 : 15:57:15
|
| Some of this information you will need to gather manually as it isn't available on the server. Since this is the case, you might as well manually store all of the information in a table then query the table on your report. I believe the first four things you want can be found in the registry though.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
kdnichols
Posting Yak Master
232 Posts |
Posted - 2007-07-11 : 16:14:08
|
| Hello Tara and all,Thanks for your input. I read on one website that you can use OSQL and I am looking at SQL Profiler.Have you used SQL Profiler any?Kurt |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-11 : 16:20:27
|
| I use SQL Profiler extensively. It will not help you with this problem nor will OSQL.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
kdnichols
Posting Yak Master
232 Posts |
Posted - 2007-07-11 : 17:11:20
|
| Hello Tara and all,So what you are saying then is that unless we purchase some third party software that gets this info for us that I will have to either fly to remote locations or better yet get the people there to get me this info. Am I understanding you correctly?Have you heard of any third party software that does this well?Thanks,Kurt |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-11 : 17:30:14
|
| What I am saying is that some of the information that you want displayed on your report is not retrievable from the server. An example of this is hardware end-of-life. Even if you flew someone to the server, that information would still not be available. As I said in my first post, you can get the first 4 items via the registry. If you are doing this via SQL Server, then you'd use xp_reg_read. I'd recommend doing this from an application though as this isn't a SQL Server issue.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-11 : 22:27:48
|
| Take look at WMI, check msdn for details. |
|
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
|
|
|
|
|
|
|
How do you get a report to get machine type, name