Script required to get server details
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?
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?
ASKER
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SQL file is ConfigurationFile.ini.
Rest you may be able to pull out of registry.
Rest you may be able to pull out of registry.
ASKER
thank you npsingh123.
ASKER
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
serverinfo.vbs
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
serverinfo.vbs
ASKER
Please close this question.
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