sql server 2008 and sql server 2008 R2....

I would like to find the number of sql server 2008 and sql server 2008 r2 between 150 sql servers on our domain and then I would like to find which sql server 2008 and 2008 R2 were installed in 2010 and 2011? after finding these servers, I need to determine how many cpu do each server have on it? I think to determine the numbers of cpu, I should log in on each server then find them from task manager? how can I achieve this?
teodor76Asked:
Who is Participating?
 
Rikin ShahConnect With a Mentor Microsoft Dynamics CRM ConsultantCommented:
0
 
Rikin ShahMicrosoft Dynamics CRM ConsultantCommented:
This may help-

To discover SQL Servers
http://ryanfarley.com/blog/archive/2003/11/11/218.aspx

If you want to look for "instances installed" then you may want
to try SQLPing or SQLRecon at
http://www.sqlsecurity.com/Tools/Fre...5/Default.aspx 
which will use various methods to determine what instances are running on the network.
0
 
Daniel_PLDB Expert/ArchitectCommented:
I'd like to suggest Policy Based management. You won't get exact number of processors but you could audit server with processors number >,< or = some value (see Server facet, @Processors value):
Using Policy-Based Management in SQL Server 2008
Policy-based Management in SQL Server 2008
Administering Servers by Using Policy-Based Management
Tutorial: Administering Servers by Using Policy-Based Management

Or you can use registered servers and query them by using:
 
exec xp_msver 'ProcessorCount'

Open in new window


SQL Server 2005 - Registered Servers
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
teodor76Author Commented:
where can I find installation logs? I think I can find that which date and time were these servers installed?
0
 
Rikin ShahMicrosoft Dynamics CRM ConsultantCommented:
It is located at %programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log\.

http://technet.microsoft.com/en-us/library/ms143702.aspx
0
 
Rikin ShahMicrosoft Dynamics CRM ConsultantCommented:
@teodor76: any luck with above suggestion?
0
 
VENKAT KOKULLAConnect With a Mentor SQL Server DBACommented:
Here you go,

Firstly you need to login in to individualSQL instances from your PC ( as mentioned above all pc's are in same domain, so no issues), then run the below commands individually in management studio:

--- Gives the SQL Version

select @@version

---Gives the installed date of SQL

SELECT create_date as 'SQL Server Install Date',
DATEADD(dd,180,create_date) as 'Will Stop Working ON'
FROM sys.server_principals WHERE name='NT AUTHORITY\SYSTEM'

---Gives CPU's Count

 exec master..xp_msver


Please try above snd let me know if having any concerns...

--Venkat
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.