Query: List all SQL server instances within an Organizational Unit using BV Control SQL Server

Article:TECH157007  |  Created: 2011-03-31  |  Updated: 2011-03-31  |  Article URL http://www.symantec.com/docs/TECH157007
Article Type
Technical Solution


Issue



null


Error



null


Environment



null


Solution



  1. Create a new query in RMS Console (red notebook icon in the toolbar).
  2. Select bv-Control for SQL.
  3. Select the 'Servers' Datasource.
  4. Select the necessary fields on the Field Specification tab.
  5. Click on the scope tab.
  6. Select advance scope "All SQL Server Instances in Organizational Unit ".
  7. Add the domain name down to the OU in the proper format.

NOTE:  If you are trying to query servers from a different domain, a trust must exist between both domains.


Supplemental Materials

Description

null



Article URL http://www.symantec.com/docs/TECH157007


Terms of use for this information are found in Legal Notices