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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Rikin ShahMicrosoft Dynamics CRM ConsultantCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
The Five Tenets of the Most Secure Backup

Data loss can hit a business in any number of ways. In reality, companies should expect to lose data at some point. The challenge is having a plan to recover from such an event.

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 KOKULLASQL 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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.