Enumerate SQL Server Names from "SQL Server Enterprise Manager" - Page 2

Method 1

Some database administrators have the habit of registering the servers under the general group "SQL Server Group." [Refer Fig 1.1]

Now execute the VB Script as shown below.

cscript scanEM.vbs "SQL Server Group"

When the Script is executed, you would see that the script enumerates all of the SQL Servers listed under the group "SQL Server Group." [Refer Fig 1.3]

Method 2

Some database administrators organize the Enterprise manager by creating different groups and subgroups. [Refer Fig 1.4]

Now Execute the VBScript as shown below. [Refer Fig 1.5]

cscript scanEM.vbs "BCApplication\Prod"

When the Script is executed, you would see that the script enumerates all of the SQL Servers listed under the group "BCApplication\Prod." [Refer Fig 1.6]

Conclusion

This article has examined the various methods of enumerating all of the SQL Servers that are registered in Enterprise manager.

» See All Articles by Columnist MAK