Get-QLRSqlSrvAgent
From PowerGUI Wiki
Retrieves status of the server components.
Contents |
Syntax
Get-QLRSqlSrvAgent [-ServerName] <String> [[-LoginMode] [<AuthMode>]] [[-Login] [<String>]] [[-Password] [<String>]] [-ConfigFile [<String>]] [<CommonParameters>]
Detailed Description
The Get-QLRSqlSrvAgent cmdlet retrieves version and installation status of Log Reader server components from a SQL Server instance.
Related Commands
Parameters
| Name | Description | Required? | Pipeline Input | Default Value |
|---|---|---|---|---|
| ServerName | The SQL Server instance name. | true | false | |
| LoginMode | The connection mode. Can be one of the following:
- Windows, the Windows authentication will be used - SQLServer, the SQL Server authentication will be used - Predefined, the connection mode will be set according to the setting in the configuration file | false | false | |
| Login | The login name to connect to the SQL Server. If LoginMode is set to "Windows" or "Predefined", this parameter is ignored. | false | false | |
| Password | The password to connect to the SQL Server. If LoginMode is set to "Windows" or "Predefined", this parameter is ignored. | 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.
If LoginMode is set to "Windows" or "SQLServer", this parameter is ignored. | false | false |
Return Values
Quest.LogReader.SqlServer.Wrappers.AgentWrapper
Examples
EXAMPLE 1
Get-QLRSqlSrvAgent . Windows
This command checks status of server components on the local SQL Server.
