How to create an advanced scope using 'Scope to SQL Server Instances in File' in bv-Control for SQL

Products

• Control Compliance Suite Databases MS SQL SRVR

Issue/Introduction

How to create an advanced scope using 'Scope to SQL Server Instances in File' in bv-Control for SQL.

Resolution

You can create advanced scopes using Scope to SQL Server Instances in File.
To add SQL server instances in scope files to the query scope, follow these steps:

    1. While creating a query, go to the Scope tab of the Query Builder dialog box.
    2. Double-click the Advanced Scopes container to expand.
    3. Click the Scope to SQL Server Instances in File container.

When you expand the Scope to SQL Server Instances in File container, all the scope files present in the <RMS_Installation_Directory>\Control\SQL Server\ScopeFiles folder are listed. You can add your own scope files to this folder if you want to use the files while specifying the scope for your queries.  A scope file must be a plain text file. The formats of extensions supported are .csv, .dat, and .txt. The format of the file must be:

[Domain name,] Computer name[\Instance name]

Here, Domain name and Instance name are optional. However, Symantec recommends that you specify the domain to facilitate the classification of SQL servers by domain. Every SQL Server must be entered on a new line.  For example, if the domain is US-DOM and the server is SQSVR with an instance of HR, the file can have the following entries:

                US-DOM, SQSVR\HR
                SQVSR\HR
                US-DOM, SQSVR
                SQSVR

You can choose to expand a container representing a scope file. On doing so, the SQL server instances in the scope file are displayed. You can add the entire file or a specific SQL server instance from the file as a part of your query scope.