1、 June, 2013Configuration LoggingProject ExcaliburMiho Hoshino, Worldwide Support ReadinessDocument managementCategoryTracking InformationCompany:Citrix Systems, Inc.Author(s):Miho HoshinoOwner(s): Worldwide Support ReadinessLast modified:May, 2013Version:Draft 3Length:30 minutesAgendaFeature Descrip

2、tionArchitectural ComponentsPre-requisites and supported platformsTroubleshootingReferencesConfiguration loggingLog administrative changes to databaseMakes it easy to identify any modifications that may need to be rolled backConfiguration logging has been available with XenApp (4.5 and higher) and X

3、enDesktop 4 SP1No configuration logging capability with XenDesktop 5.xConfiguration logging in ExcaliburCapture site configuration changes and administrative activities to databaseCan be viewed in Studio using a variety of filters and generate HTML and CSV reportsRequires the Edit Logging Preference

4、s and View Configuration Logs permissions to control Configuration loggingEnabled by defaultWhat is loggedConfiguration changes and administrative activities initiated from Studio, Director, and PowerShell scripts are loggedExamples:Creating or editing a HostAdding a user to a Delivery GroupChanging

5、 power management settings for a Delivery GroupAdding an administratorPower control of a virtual machineShutdown/start/restart of a user desktopStudio or Director sending a message to a userPowerShell Citrix StudioDirectorloggedWhat is not loggedWhat is not logged:Autonomic operations such as pool m

6、anagement power-on of virtual machinesThe very early stages of configuration are not logged as Configuration Logging es available when its service instance registers with the Configuration ServiceChanges made through the registry, direct access of the Database, or from sources other than Studio, Dir

7、ector, or PowerShellNotloggedHow to enable/disable Configuration LoggingFrom Citrix Studio, select Logging in the left paneIn the Actions pane, click Preference. Select the Enable/Disable radio button (Enable is selected by default) Configuration Logging DatabaseUses the main site database by defaul

8、tCan use a different database for Configuration Logging (highly mended)Supported database:SQL Server 2012 SP1 - Express, Standard, and Enterprise EditionsSQL Server 2008 R2 SP2 Express, Standard, Enterprise, and Datacenter EditionsIncludes by defaultSite ConfigurationDatabaseConfiguration Logging Da

9、tabaseMonitoringDatabaseUsing the main site database by defaultConfiguration Logging databaseConfigLoggingSchemaHow to change the database location (1/2) From Studio, select Logging in the left paneIn the Actions pane, click PreferencesClick Change logging database How to change the database locatio

10、n (2/2) Specify the location of the server containing the new database server and the database nameIf you want Studio to create the database, click OK or Test connection. When prompted, click OKStudio will create the database automatically How to enable/disable mandatory loggingFrom Citrix Studio, s

11、elect Logging in the left paneIn the Actions pane, click Preference. Clear the Allow changes when the database is disconnected checkbox to enable mandatory logging.Select the Allow changes when the database is disconnected checkbox to disable mandatory logging (This is selected by default)Mandatory

12、logging enabled:No configuration change or administrative activity that would normally be logged will be allowed unless it can be written in the database used for Configuration Logging Displaying configuration log content (1/2)NewestEnter text in the Search box to filter logsSelect an interval from

13、the drop down list box:Last six monthsLast three monthsLast 28 daysLast 7 daysTodayThe log content is displayed chronologically (newest entries first) by defaultSelect Logging to display configuration log contentDisplaying configuration log content (2/2)High level operations:A high level operation r

14、esults in one or more service and SDK calls, which are low level operationsLow level operations are displayed when you select a high level operation in the upper portion of the center paneGenerating configuration log reports (1/2)Click Create custom report in the Actions paneSelect the date range fo

15、r the reportSelect the report format and browse to the location where the report should be savedGenerating configuration log reports (2/2)Deleting configuration log content Click Delete logs in the Actions paneChoose to create a backup or not Review your selection and click FinishRequirements to del

16、ete configuration logs (1/3)Delegated Administration permissionSQL Server database permissionCan delete configuration logsRequirements to delete configuration logs (2/3)For delegated Administration permissionDelegated AdministrationBuilt-inFull AdministratorCustomA custom role that has Read Only or

17、Manage selected in the Logging permissions categoryRequirements to delete configuration logs (3/3)For SQL Server database permissionSQL Server database login with at least one of the following roles:Server roleDatabase role for the Configuration Logging databasesysadmin(public)serveradmin(public)set

18、upadmin(public)(public)ConfigurationLoggingSchema_ROLE (public)db_ownerHow-to: Creating a SQL Server login (1/2) Setting server role(s)Right-click the Security folder, point to New and then click LoginEnter a name (and password) for the login on the General pageSelect the Server Roles page and set s

19、erver rolesHow-to: Creating a SQL Server login (2/2)Specifying the database that the login is allowed to accessPlace a check mark next to the database that you wish to have the login to get accessCan set database roles hereConfiguration logging internalsUses PowerShell SDK Installed with StudioConfi

20、guration logging is configured via SDKUses the Citrix Configuration Logging Service Installed with the Delivery ControllerConfiguration Logging architectureEach service can generate configuration log entries and log entries are conveyed via inter-service WCF call to the logging servicePowerShell cmd

21、lets (1/2) For configuration loggingSet-LogSiteAllows settings to be setExample: Set-LogSite -State Enabled -Locale Chinese AdminAddress “”Get-LogHighLevelOperationRetrieves existing High Level Operations based on filter criteriaGet-LogLowLevelOperationRetrieves existing Low Level Operations based o

22、n filter criteriaPowerShell cmdlets (2/2)For configuration loggingStart-LogHighLevelOperationLogs the start of a new High Level Operation in the Logging DatabaseStop-LogHighLevelOperationLogs the completion of a new High Level Operation in the Logging DatabaseDelete-LogOperationDeletes records from the database within a specified time rangeExport-LogCsvReportGenerates a CSV report of the data in th