Finding Details on SQL Installs on the Network

Question

Post reply

Finding Details on SQL Installs on the Network

Betsy Rogers

Old Hand

Points: 356
More actions
December 8, 2004 at 10:33 am

#85020

I am trying to put together some preventitive maintenance information. I want to scan our network and find:
1) all the installed SQL servers (whether they are turned on or not)
2) what edition they are and what licensing they've picked (for licensing purposes)
3) what version/release they are on (for patching purposes)

I've found ways to find all of the installs, based on reading the registry. A combo of keys in the registry can get SP and hotfix level. But is there a way to find the stuff that comes out of SERVERPROPERTY in the registry?
I need to go through the registry because there will be cases where SQL is installed, but I cannot get into it (it's not turned on, or I'm not a user and builtin\administrators has been removed).

Any ideas?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

hmm, you can try this software.. But I don't expect it to be able to find and connect to turned off servers...

SQL STRIPES

Betsy Rogers Old Hand Points: 356 More actions · Answer 2

I'm not trying to connect. I'm just trying to identify the servers and their specific install properties.

I will look at the software, though. Thanks.

Steve Dyte Newbie Points: 3 More actions · Answer 3

Try SQLDMO.

You'll need some kind of login on each server though - either SQL or Integrated.

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 4

You could do this quite easily if your site is using SMS. If SMS has gathered the information you could generate a report via the console or query the tables directly.

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Summer90 SSC-Dedicated Points: 32891 More actions · Answer 5

Have you tried Microsoft Security Base Analyzer that check products for what levels of service packs and what patches need applied? That would do the trick.