Script required to get server details

Posted on 2012-09-21
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
    LVL 23

    Expert Comment

    by:Nagendra Pratap Singh
    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

    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 23

    Accepted Solution

    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.
    LVL 23

    Expert Comment

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

    Rest you may be able to pull out of registry.

    Author Comment

    thank you npsingh123.

    Author Comment

    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

    Please close this question.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Suggested Solutions

    Article by: Leon
    Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
    If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now