Script required to get server details

Posted on 2012-09-21
Medium Priority
Last Modified: 2013-01-16
I need to run a report on all the servers in our domain to get the following information

1. Network Operating System & Edition Operating System Version      
2. No. of Physical Processor in the Server      No of Cores per Physical Processor in the Server      
3. Is server OS license an OEM / FPP / or volume license      
4. Computer model      Is the COA Present (Y / N )      COA Number      
OEM PK      Number of CAL's included with the license      
5. What is the Servers Primary use (EG File server, Storage Server, Firewall, SQL, Exchange, Print)      
6. Is the server accessed by external (non employed) users?      
7. Is this  server running a Physical OSE or a Virtual OSE ? (Operating System Environment)      
8. What is the host server's Name ? (If the server is a virtual server please complete this field and ensure the host's details are recorded on a separate row)      
9. How many Virtual processors have been assigned to this Virtual server?      
10. What is the host servers operating system license?      
11. What Exchange Version is installed (5.5, 2000, 2003, 2007)      
12. What Edition of Exchange is installed (Standard Enterprise) or Tools      
13. Is Exchange licensed per user of per device?      
14. How many Users or Devices acess the server?      
15. Do you have a list of the all devices or users that access Exchange Server?      
16. What SQL VERSION is installed (7.0, 2000, 2005, 2008)      
17. What SQL Edition is installed (MSDE, Express, Standard Enterprise WorkGroup)      
18. Is the SQL licensed per SQL User or Device CAL Or per Processor license?      
SQL 2012 Cores this Physical Server (Min 4 Per Proc)      
19. SQL 2012 Cores this Virtual Server (Min 4 Per VM)      
20. If licensed per CAL, how many users or devices connect to the SQL server?      
21. DO you have a list of the users/devices that connect to the SQL Server      
22. What application uses the SQL database ? (Finance System , Discovery tool , HR , etc etc)
23. Is the SQL server used with MSDN?      
24. Is the SQL server data Internet Facing? (Y/N)      
25. What other Products, not already stated, are installed (if any)What Version      What Edition      
26. If licensed with CAL's, how many users / devices access the server (directly or indirectly)Do you have a list of the users / devices accessing the server?            
PC details 1      Processor make

does anyone have a script (s) that will get the above information for me?
Question by:tedcbe
  • 4
  • 3
LVL 24

Expert Comment

by:Nagendra Pratap Singh
ID: 38421144
You need 3-4 fulltime coders to figure out the above.

Also "How many Users or Devices acess the server?" does not make much sense. If you have shares on it then you need to count the possible users of all the shares and if it has "everyone" then you are again stuck

Author Comment

ID: 38422606
Thanks for your response npsingh123.

I appreciate that this might not be an easy task but I will be more than happy to have the report run for most of the parameters that it has been requested for.

Are you aware of any scripts that will do it?
LVL 24

Accepted Solution

Nagendra Pratap Singh earned 1000 total points
ID: 38422641
Try this

start > cmd > systeminfo

start > cmd > WMIC product
start > cmd > wmic product get /format:csv > list_%Computername%.csv

Also on Windows 2008
servermanagercmd -q

BTW, when we install SQL, the settings are saved in a file. I cannot recall the name now.
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

LVL 24

Expert Comment

by:Nagendra Pratap Singh
ID: 38422706
SQL file is ConfigurationFile.ini.

Rest you may be able to pull out of registry.

Author Comment

ID: 38449227
thank you npsingh123.

Author Comment

ID: 38453993
I have the attached .vbs script gives Total number of processors and No of Physical Disks apart from other server details.

I need help with amending the script to collect the following information as well from the servers

1. Total number of Physical Processors
2. No of Cores pers Physical Processor
3. Is the server OS license an OEM/FPP or volume license
4. Is the COA present (Y/N)
5. COA Number
6. Is the server running Phyical or Virtual Operating System Environment
7. Host servers name if is a virtual server
8. How manuy virutal processors have been assigned to the virtual server
9. What is the host servers operating system license

Author Comment

ID: 38782097
Please close this question.

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
Make the most of your online learning experience.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Loops Section Overview

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question