Citrix XenApp 6.5 Configuration Logging PowerShell Automation
The configuration logging database now has some commands within the Citrix PowerShell Snapin to help automate some of the tasks. The following 4 steps should make it a bit easier for you. You will only need to do this once, usually on the first server in the farm or a designated server depending on the size of the farm.
Run the powershell snapin as an administrator who has access to the SQL database and replace the text in red and yellow with the appropriate values in your organisation.
1. Load Citrix Powershell Snapins
Asnp Citrix.*
2.Enter Your Credentials (you will be prompted for credential)
$PSCredential = Get-Credential $Credential
3.Setup the Config Logging Database (Run Powershell as User with Credentials to Access SQL)
Set-XAConfigurationLog-LoggingEnabled $true-ChangesWhileDisconnectedAllowed $true-CredentialsOnClearLogRequired $true-DatabaseType SqlServer-AuthenticationMode Integrated –DatabaseUser $PSCredential -ConnectionString "Server=<SQL SERVER>;Database=<SQL DATABASE>;User ID=<DOMAIN>\<USERNAME>;Password=;Trusted_Connection=True;Encrypt=False;"
4.Once completed, you will need to log into Citrix AppCenter and enter the farm properties to connect to the Config Logging database.
Helpful Commands
Clear the Config Logging DB : Clear-XAConfigurationLog
