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]
Fig 1.4
Now Execute the VBScript
as shown below. [Refer Fig 1.5]
cscript scanEM.vbs "BCApplication\Prod"
Fig 1.5
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]
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