Inventory SQL Server machines on your network

[mjlefevre]

What is a good simple way to scan the servers in your network for SQL
Servers?

Does anyone have any scripts or code that would show me how to do
this?
I think WMI might be able to do this but don't know where to start.

If possible I'd like to be able to get the version (2000 or 2005) if
possible.

Thanks,
Kelly Greer
kellygreer1@nos pam.com
change nospam to yahoo

[Tom van Stiphout]

Re: Inventory SQL Server machines on your network

On Thu, 21 Feb 2008 06:51:18 -0800 (PST), mjlefevre
<mjlefevre@gmai l.comwrote:

Here is one way:

http://msdn2.microsoft.com/en-us/library/a6t1z9x2.aspx

-Tom.

>What is a good simple way to scan the servers in your network for SQL
>Servers?
>
>Does anyone have any scripts or code that would show me how to do
>this?
>I think WMI might be able to do this but don't know where to start.
>
>If possible I'd like to be able to get the version (2000 or 2005) if
>possible.
>
>Thanks,
>Kelly Greer
>kellygreer1@no spam.com
>change nospam to yahoo