Get-QLRSqlRegServer

From PowerGUI Wiki

Generates a list of registered SQL Server instances.

Contents 1 Syntax 2 Detailed Description 3 Related Commands 4 Parameters 5 Return Values 6 Examples 6.1 EXAMPLE 1 6.2 EXAMPLE 2

Syntax

Get-QLRSqlRegServer [[-Name] [<String[]>]] [-Group [<String[]>]] [-ConfigFile [<String>]] [<CommonParameters>]

Detailed Description

The Get-QLRSqlRegServer cmdlet reads a configuration file, generates a list of all registered SQL Server instances, and writes the list to a pipeline.

Related Commands

• Add-QLRSqlRegServer
• Remove-QLRSqlRegServer

Parameters

Name	Description	Required?	Pipeline Input	Default Value
Name	The name of a registered SQL Server instance. The name may contain wildcard characters.	false	false
Group	The group of registered SQL server instances. The group name may contain wildcard characters.	false	false
ConfigFile	The configuration file name. The default configuration file is located at <%LocalAppData%>\Quest Software\Log Reader for SQL Server\QuestLogReader.config. You can read settings from another configuration file.	false	false

Return Values

Quest.LogReader.SqlServer.Wrappers.ServerWrapper

Examples

EXAMPLE 1

Get-QLRSqlRegServer

This command returns all registered servers.

EXAMPLE 2

Get-QLRSqlRegServer *ab* -Group MyGroup

This command returns all registered servers that contain substring "ab" in theirs name and are registered in the MyGroup group.