Get-LogDBConnection
Returns the database connection string for the specified data store used by the ConfigurationLogging Service.
Syntax
Get-LogDBConnection
[[-DataStore] <String>]
[<CitrixCommonParameters>]
[<CommonParameters>]
Description
Returns the database connection string from the currently selected ConfigurationLogging Service instance.
If the returned string is blank, no valid connection string has been specified. In this case the service is running, but is idle and awaiting specification of a valid connection string.
The current service instance is the one on the local machine, or the one most recently specified using the -AdminAddress parameter of a ConfigurationLogging SDK cmdlet.
Examples
EXAMPLE 1
Gets the database connection string in use by the ConfigurationLogging Service instance running on controller "controller1.mydomain.net".
Get-LogDBConnection -AdminAddress controller1.mydomain.net
Server=serverName\SQLEXPRESS;Initial Catalog=databaseName;Integrated Security=True
Parameters
-DataStore
Specifies the logical name of the data store for the ConfigurationLogging Service. Can be either be 'Site' or the logical name of the secondary data store.
| Type: | String |
| Position: | 2 |
| Default value: | Site |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
CitrixCommonParameters
This cmdlet supports the common Citrix parameters: -AdminAddress, -AdminClientIP, -BearerToken, -TraceParent, -TraceState and -VirtualSiteId. For more information, see about_CitrixCommonParameters.
CommonParameters
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.
Inputs
None
You cannot pipe input into this cmdlet.
Outputs
The database connection string configured for the current ConfigurationLogging Service instance.
Notes
If the command fails, the following errors can be returned:
-
NoDBConnectionsThe database connection string for the ConfigurationLoggingService has not been specified.
-
DatabaseErrorAn error occurred in the service while attempting a database operation.
-
DatabaseNotConfiguredThe operation could not be completed because the database for the service is not configured.
-
DataStoreExceptionAn error occurred in the service while attempting a database operation - communication with the database failed for various reasons.
-
PermissionDeniedYou do not have permission to execute this command.
-
AuthorizationErrorThere was a problem communicating with the Citrix Delegated Administration Service.
-
CommunicationErrorThere was a problem communicating with the remote service.
-
ExceptionThrownAn unexpected error occurred. For more details, see the Windows event logs on the controller or the Citrix Virtual Apps and Desktops logs.