SqlServerMaintenance.Format.ps1xml
|
<?xml version="1.0" encoding="utf-8" ?>
<Configuration> <Controls> <Control> <Name>Index-GroupingFormat</Name> <CustomControl> <CustomEntries> <CustomEntry> <CustomItem> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>SQL Instance Name : </Text> <ExpressionBinding> <PropertyName>SqlInstanceName</PropertyName> </ExpressionBinding> </CustomItem> </Frame> <NewLine/> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Database Name : </Text> <ExpressionBinding> <PropertyName>DatabaseName</PropertyName> </ExpressionBinding> </CustomItem> </Frame> </CustomItem> </CustomEntry> </CustomEntries> </CustomControl> </Control> <Control> <Name>Statistics-GroupingFormat</Name> <CustomControl> <CustomEntries> <CustomEntry> <CustomItem> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Database Name : </Text> <ExpressionBinding> <PropertyName>DatabaseName</PropertyName> </ExpressionBinding> </CustomItem> </Frame> <NewLine/> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Statistics Options : </Text> <ExpressionBinding> <ScriptBlock> if ($_.StatisticsOptions) { $_.StatisticsOptions } else { 'None' } </ScriptBlock> </ExpressionBinding> </CustomItem> </Frame> <NewLine/> </CustomItem> </CustomEntry> </CustomEntries> </CustomControl> </Control> </Controls> <ViewDefinitions> <View> <Name>CheckDb</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.CheckDb</TypeName> </ViewSelectedBy> <GroupBy> <Label>Database Name</Label> <PropertyName>DatabaseName</PropertyName> </GroupBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>Error</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Level</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>State</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Message</Label> <Width>96</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <Wrap /> <TableColumnItems> <TableColumnItem> <PropertyName>Error</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Level</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>State</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>MessageText</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>CheckDbResult</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.CheckDbResult</TypeName> </ViewSelectedBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>Database Name</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Is No Index</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>CheckDBOptions</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>CheckDb Status</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <Wrap /> <TableColumnItems> <TableColumnItem> <PropertyName>DatabaseName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>IsNoIndex</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>CheckDBOptions</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <Alignment>left</Alignment> <ScriptBlock> $Status = $_.CheckDbStatus $FormatString = "$([char]27)[{0}m{1}$([char]27)[0m" switch ($Status) { 'S' { $Color = 32 $Output = 'Success' } 'F' { $Color = 31 $Output = 'Failure' } 'W' { $Color = 33 $Output = 'Warning' } Default { $Color = 39 $Output = 'Unknown' } } [string]::Format($FormatString, $Color, $Output) </ScriptBlock> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>DatabaseMailItem</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.DatabaseMailItem</TypeName> </ViewSelectedBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>Sql Instance</Label> <Width>24</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Mail Item ID</Label> <Width>12</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Recipients</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Subject</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>SqlInstance</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>MailItemID</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Recipients</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Subject</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>DatabasePrimaryFile</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.DatabasePrimaryFile</TypeName> </ViewSelectedBy> <GroupBy> <Label>Database Name</Label> <PropertyName>DatabaseName</PropertyName> </GroupBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>Version</Label> <Width>10</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Collation</Label> <Width>10</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Logical File</Label> <Width>200</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <Wrap /> <TableColumnItems> <TableColumnItem> <PropertyName>DatabaseVersion</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Collation</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>LogicalFile</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>DatabasePrimaryLogicalFile</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.DatabasePrimaryLogicalFile</TypeName> </ViewSelectedBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>Status</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>File ID</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Logical File Name</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>File Name</Label> <Width>200</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <Wrap /> <TableColumnItems> <TableColumnItem> <PropertyName>Status</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>FileID</PropertyName> <Alignment>right</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>LogicalFileName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>FileName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>DatabaseSnapshot</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.DatabaseSnapshot</TypeName> </ViewSelectedBy> <GroupBy> <Label>Database Name</Label> <PropertyName>DatabaseSnapshotBaseName</PropertyName> </GroupBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>Snapshot Name</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Status</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Recovery Model</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Compat. Level</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Owner</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>DatabaseSnapshotName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Status</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>RecoveryModel</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>CompatibilityLevel</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Owner</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>DatabaseTransactionLogInfo</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.DatabaseTransactionLogInfo</TypeName> </ViewSelectedBy> <GroupBy> <Label>Database Name</Label> <PropertyName>DatabaseName</PropertyName> </GroupBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>FileID</Label> <Width>10</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>VlfBeginOffset</Label> <Width>20</Width> <Alignment>right</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>VlfSizeMB</Label> <Width>20</Width> <Alignment>right</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>VlfSequenceNumber</Label> <Width>20</Width> <Alignment>right</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>VlfCreateLsn</Label> <Width>25</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>RunningSizeMB</Label> <Width>20</Width> <Alignment>right</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <Wrap /> <TableColumnItems> <TableColumnItem> <PropertyName>FileID</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>VlfBeginOffset</PropertyName> <Alignment>right</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>VlfSizeMB</PropertyName> <Alignment>right</Alignment> <FormatString>{0:N2}</FormatString> </TableColumnItem> <TableColumnItem> <PropertyName>VlfSequenceNumber</PropertyName> <Alignment>right</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>VlfCreateLsn</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>RunningSizeMB</PropertyName> <Alignment>right</Alignment> <FormatString>{0:N2}</FormatString> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>FullTextIndex_Table</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.FullTextIndex</TypeName> </ViewSelectedBy> <GroupBy> <CustomControlName>Index-GroupingFormat</CustomControlName> <ScriptBlock>$($_.SqlInstanceName + '&' + $_.DatabaseName)</ScriptBlock> </GroupBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>Schema Name</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Table Name</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Catalog Name</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Mode</Label> <Width>12</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>SchemaName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>TableName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>CatalogName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Mode</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>FullTextIndex_List</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.FullTextIndex</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>SQL Instance</Label> <PropertyName>SqlInstance</PropertyName> </ListItem> <ListItem> <Label>Database Name</Label> <PropertyName>DatabaseName</PropertyName> </ListItem> <ListItem> <Label>Schema Name</Label> <PropertyName>SchemaName</PropertyName> </ListItem> <ListItem> <Label>Table Name</Label> <PropertyName>TableName</PropertyName> </ListItem> <ListItem> <Label>Catalog Name</Label> <PropertyName>CatalogName</PropertyName> </ListItem> <ListItem> <Label>Mode</Label> <PropertyName>Mode</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>Index_Table</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.Index</TypeName> </ViewSelectedBy> <GroupBy> <CustomControlName>Index-GroupingFormat</CustomControlName> <ScriptBlock>$($_.SqlInstanceName + '&' + $_.DatabaseName)</ScriptBlock> </GroupBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>Schema Name</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Table Name</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Index Name</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Partition Number</Label> <Width>10</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Mode</Label> <Width>12</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>SchemaName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>TableName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>IndexName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>PartitionNumber</PropertyName> <Alignment>right</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Mode</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>Index_List</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.Index</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>SQL Instance</Label> <PropertyName>SqlInstance</PropertyName> </ListItem> <ListItem> <Label>Database Name</Label> <PropertyName>DatabaseName</PropertyName> </ListItem> <ListItem> <Label>Schema Name</Label> <PropertyName>SchemaName</PropertyName> </ListItem> <ListItem> <Label>Table Name</Label> <PropertyName>TableName</PropertyName> </ListItem> <ListItem> <Label>Index Name</Label> <PropertyName>IndexName</PropertyName> </ListItem> <ListItem> <Label>Partition Number</Label> <PropertyName>PartitionNumber</PropertyName> </ListItem> <ListItem> <Label>Mode</Label> <PropertyName>Mode</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>OrphanedDatabasePhysicalFile</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.OrphanedDatabasePhysicalFile</TypeName> </ViewSelectedBy> <GroupBy> <Label>Directory</Label> <PropertyName>DirectoryName</PropertyName> </GroupBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>File Name</Label> <Width>48</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>File Type</Label> <Width>48</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <Wrap /> <TableColumnItems> <TableColumnItem> <PropertyName>Name</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>FileType</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>OrphanedDatabaseUser</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.OrphanedDatabaseUser</TypeName> </ViewSelectedBy> <GroupBy> <Label>Database Name</Label> <PropertyName>DatabaseName</PropertyName> </GroupBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>Database User</Label> <Width>40</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Login Name</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Authentication Type</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Login Type</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <Wrap /> <TableColumnItems> <TableColumnItem> <PropertyName>DatabaseUser</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>LoginName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>AuthenticationType</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>LoginType</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>SqlDataFileUsage_Table</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.SqlDataFileUsage</TypeName> </ViewSelectedBy> <GroupBy> <Label>SQL Instance</Label> <PropertyName>SqlInstance</PropertyName> </GroupBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>Database Name</Label> <Width>24</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Data File Name</Label> <Width>24</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Current Data File Size</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Recommended Data File Size</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Reliability</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Recommended Auto Growth</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>DatabaseName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>DataFileName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>DataFileSize</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <ScriptBlock> $Esc = [char]27 if ($env:WT_SESSION -and $_.DataFileSize -ne $_.RecommendedDataFileSize) { "$($Esc)[31m$($_.RecommendedDataFileSize)$($Esc)[0m" } else { $_.RecommendedDataFileSize } </ScriptBlock> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Reliability</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>RecommendedAutoGrowth</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>SqlDataFileUsage_List</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.SqlDataFileUsage</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>SQL Instance</Label> <PropertyName>SqlInstance</PropertyName> </ListItem> <ListItem> <Label>Database Name</Label> <PropertyName>DatabaseName</PropertyName> </ListItem> <ListItem> <Label>Data File Name</Label> <PropertyName>DataFileName</PropertyName> </ListItem> <ListItem> <Label>Data File Size</Label> <PropertyName>DataFileSize</PropertyName> </ListItem> <ListItem> <Label>Data File Available Percent</Label> <PropertyName>DataFileAvailablePercent</PropertyName> </ListItem> <ListItem> <Label>Recommended Data File Size</Label> <ScriptBlock> $Esc = [char]27 if ($env:WT_SESSION -and $_.DataFileSize -ne $_.RecommendedDataFileSize) { "$($Esc)[31m$($_.RecommendedDataFileSize)$($Esc)[0m" } else { $_.RecommendedDataFileSize } </ScriptBlock> </ListItem> <ListItem> <Label>Reliability</Label> <PropertyName>Reliability</PropertyName> </ListItem> <ListItem> <Label>Recommended Auto Growth</Label> <PropertyName>RecommendedAutoGrowth</PropertyName> </ListItem> <ListItem> <Label>Daily Growth Rate</Label> <ScriptBlock> if ($_.DailyGrowthRate -lt 1024) { '{0} KB' -f [math]::Round($_.DailyGrowthRate, 2, [MidpointRounding]::AwayFromZero) } else { '{0} MB' -f [math]::Round($_.DailyGrowthRate / 1024, 2, [MidpointRounding]::AwayFromZero) } </ScriptBlock> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>SqlLogFileGrowth_Table</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.SqlLogFileGrowth</TypeName> </ViewSelectedBy> <GroupBy> <Label>SQL Instance</Label> <PropertyName>SqlInstance</PropertyName> </GroupBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>Database Name</Label> <Width>24</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Log File Name</Label> <Width>24</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Log File Size (MB)</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Auto Growth (MB)</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Auto Growth Percentage Of FileSize</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Minimum Recommended Auto Growth (MB)</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>DatabaseName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>LogFileName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>LogFileSize</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <ScriptBlock> $Esc = [char]27 $AutoGrowth = $_.AutoGrowth switch ($_.GrowthType) { 'KB' { $AutoGrowth = $AutoGrowth / 1024 } Default { $AutoGrowth = $AutoGrowth } } if ($env:WT_SESSION -and $AutoGrowth -lt $_.MinimumRecommendedAutoGrowth) { "$($Esc)[31m$($AutoGrowth)$($Esc)[0m" } else { $AutoGrowth } </ScriptBlock> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>AutoGrowthPercentageOfFileSize</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>MinimumRecommendedAutoGrowth</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>SqlLogFileGrowth_List</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.SqlLogFileGrowth</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Database Name</Label> <PropertyName>DatabaseName</PropertyName> </ListItem> <ListItem> <Label>Log File Name</Label> <PropertyName>LogFileName</PropertyName> </ListItem> <ListItem> <Label>Log File Size (MB)</Label> <PropertyName>LogFileSize</PropertyName> </ListItem> <ListItem> <Label>Auto Growth (MB)</Label> <ScriptBlock> $Esc = [char]27 $AutoGrowth = $_.AutoGrowth switch ($_.GrowthType) { 'KB' { $AutoGrowth = $AutoGrowth / 1024 } Default { $AutoGrowth = $AutoGrowth } } if ($env:WT_SESSION -and $AutoGrowth -lt $_.MinimumRecommendedAutoGrowth) { "$($Esc)[31m$($AutoGrowth)$($Esc)[0m" } else { $AutoGrowth } </ScriptBlock> </ListItem> <ListItem> <Label>Auto Growth Percentage Of File Size</Label> <PropertyName>AutoGrowthPercentageOfFileSize</PropertyName> </ListItem> <ListItem> <Label>Minimum Recommended Auto Growth (MB)</Label> <PropertyName>MinimumRecommendedAutoGrowth</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>SqlLogFileVLFCount_Table</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.SqlLogFileVLFCount</TypeName> </ViewSelectedBy> <GroupBy> <Label>SQL Instance</Label> <PropertyName>SqlInstance</PropertyName> </GroupBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>Sql Instance Name</Label> <Width>24</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Database Name</Label> <Width>24</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Total VLF Count</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>SqlInstance</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>DatabaseName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>TotalVLFCount</PropertyName> <Alignment>right</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>SqlLogFileVLFCount_List</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.SqlLogFileVLFCount</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Sql Instance Name</Label> <PropertyName>SqlInstance</PropertyName> </ListItem> <ListItem> <Label>Database Name</Label> <PropertyName>DatabaseName</PropertyName> </ListItem> <ListItem> <Label>Total VLF Count</Label> <PropertyName>TotalVLFCount</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>SqlLogShip</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.SqlLogShip</TypeName> </ViewSelectedBy> <GroupBy> <Label>Database Name</Label> <PropertyName>DatabaseName</PropertyName> </GroupBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>Date/Time</Label> <Width>24</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Transcript</Label> <Width>99</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <Wrap /> <TableColumnItems> <TableColumnItem> <PropertyName>DateTime</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Transcript</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>SqlLogShippingPrimary_Table</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.SqlLogShippingPrimary</TypeName> </ViewSelectedBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>Primary ID</Label> <Width>37</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Primary Server</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Primary Database</Label> <Width>18</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Secondary Server</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Secondary Database</Label> <Width>18</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>PrimaryID</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>PrimaryServer</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>PrimaryDatabase</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>SecondaryServer</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>SecondaryDatabase</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>SqlLogShippingPrimary_List</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.SqlLogShippingPrimary</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Primary ID</Label> <PropertyName>PrimaryID</PropertyName> </ListItem> <ListItem> <Label>Primary Database</Label> <PropertyName>PrimaryDatabase</PropertyName> </ListItem> <ListItem> <Label>Backup Directory</Label> <PropertyName>BackupDirectory</PropertyName> </ListItem> <ListItem> <Label>Backup Share</Label> <PropertyName>BackupShare</PropertyName> </ListItem> <ListItem> <Label>Backup Retention Period</Label> <ScriptBlock>([timespan]::FromMinutes($_.BackupRetentionPeriod_Minutes)).ToString("dd' days 'hh' hours 'mm' minutes'")</ScriptBlock> </ListItem> <ListItem> <Label>Monitor Server</Label> <PropertyName>MonitorServer</PropertyName> </ListItem> <ListItem> <Label>Server Security Mode</Label> <PropertyName>ServerSecurityMode</PropertyName> </ListItem> <ListItem> <Label>Backup Compression</Label> <PropertyName>BackupCompression</PropertyName> </ListItem> <ListItem> <Label>Primary Server</Label> <PropertyName>PrimaryServer</PropertyName> </ListItem> <ListItem> <Label>Backup Threshold</Label> <ScriptBlock>([timespan]::FromMinutes($_.BackupThreshold_Minutes)).ToString("dd' days 'hh' hours 'mm' minutes'")</ScriptBlock> </ListItem> <ListItem> <Label>Threshold Alert Enabled</Label> <PropertyName>ThresholdAlertEnabled</PropertyName> </ListItem> <ListItem> <Label>LastBackup File</Label> <PropertyName>LastBackupFile</PropertyName> </ListItem> <ListItem> <Label>Last Backup Date</Label> <PropertyName>LastBackupDate</PropertyName> </ListItem> <ListItem> <Label>History Retention Period</Label> <ScriptBlock>([timespan]::FromMinutes($_.HistoryRetentionPeriod_Minutes)).ToString("dd' days 'hh' hours 'mm' minutes'")</ScriptBlock> </ListItem> <ListItem> <Label>Secondary Server</Label> <PropertyName>SecondaryServer</PropertyName> </ListItem> <ListItem> <Label>Secondary Database</Label> <PropertyName>SecondaryDatabase</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>SqlLogShippingPrimary_Wide</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.SqlLogShippingPrimary</TypeName> </ViewSelectedBy> <GroupBy> <Label>Secondary Server</Label> <PropertyName>SecondaryServer</PropertyName> </GroupBy> <WideControl> <WideEntries> <WideEntry> <WideItem> <PropertyName>SecondaryDatabase</PropertyName> </WideItem> </WideEntry> </WideEntries> </WideControl> </View> <View> <Name>SqlLogShippingSecondary_Table</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.SqlLogShippingSecondary</TypeName> </ViewSelectedBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>Secondary ID</Label> <Width>37</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Primary Server</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Primary Database</Label> <Width>18</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Secondary Database</Label> <Width>18</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>SecondaryID</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>PrimaryServer</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>PrimaryDatabase</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>SecondaryDatabase</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>SqlLogShippingSecondary_List</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.SqlLogShippingSecondary</TypeName> </ViewSelectedBy> <ListControl> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Secondary ID</Label> <PropertyName>SecondaryID</PropertyName> </ListItem> <ListItem> <Label>Primary Server</Label> <PropertyName>PrimaryServer</PropertyName> </ListItem> <ListItem> <Label>Primary Database</Label> <PropertyName>PrimaryDatabase</PropertyName> </ListItem> <ListItem> <Label>Backup Source Directory</Label> <PropertyName>BackupSourceDirectory</PropertyName> </ListItem> <ListItem> <Label>Backup Destination Directory</Label> <PropertyName>BackupDestinationDirectory</PropertyName> </ListItem> <ListItem> <Label>File Retention Period</Label> <ScriptBlock>([timespan]::FromMinutes($_.FileRetentionPeriod_Minutes)).ToString("dd' days 'hh' hours 'mm' minutes'")</ScriptBlock> </ListItem> <ListItem> <Label>Monitor Server</Label> <PropertyName>MonitorServer</PropertyName> </ListItem> <ListItem> <Label>Monitor Server Security Mode</Label> <PropertyName>MonitorServerSecurityMode</PropertyName> </ListItem> <ListItem> <Label>Last Copied File</Label> <PropertyName>LastCopiedFile</PropertyName> </ListItem> <ListItem> <Label>Last Copied Date</Label> <PropertyName>LastCopiedDate</PropertyName> </ListItem> <ListItem> <Label>Secondary Database</Label> <PropertyName>SecondaryDatabase</PropertyName> </ListItem> <ListItem> <Label>Restore Delay</Label> <PropertyName>RestoreDelay_Minutes</PropertyName> </ListItem> <ListItem> <Label>Restore All</Label> <PropertyName>RestoreAll</PropertyName> </ListItem> <ListItem> <Label>Restore Mode</Label> <PropertyName>RestoreMode</PropertyName> </ListItem> <ListItem> <Label>Disconnect Users</Label> <PropertyName>DisconnectUsers</PropertyName> </ListItem> <ListItem> <Label>Block Size</Label> <PropertyName>BlockSize</PropertyName> </ListItem> <ListItem> <Label>Buffer Count</Label> <PropertyName>BufferCount</PropertyName> </ListItem> <ListItem> <Label>Max Transfer Size</Label> <PropertyName>MaxTransferSize</PropertyName> </ListItem> <ListItem> <Label>Last Restored File</Label> <PropertyName>LastRestoredFile</PropertyName> </ListItem> <ListItem> <Label>Last Restored Date</Label> <PropertyName>LastRestoredDate</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>SqlLogShippingSecondary_Wide</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.SqlLogShippingPrimary</TypeName> </ViewSelectedBy> <GroupBy> <Label>Primary Server</Label> <PropertyName>PrimaryServer</PropertyName> </GroupBy> <WideControl> <WideEntries> <WideEntry> <WideItem> <PropertyName>PrimaryDatabase</PropertyName> </WideItem> </WideEntry> </WideEntries> </WideControl> </View> <View> <Name>SqlQueryStore_Table</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.SqlQueryStore</TypeName> </ViewSelectedBy> <GroupBy> <Label>Database Name</Label> <PropertyName>DatabaseName</PropertyName> </GroupBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>Storage Size (MB)</Label> <Width>20</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Max Storage Size (MB)</Label> <Width>20</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Available Percent</Label> <Width>20</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Desired State</Label> <Width>10</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Actual State</Label> <Width>10</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Read Only Reason</Label> <Width>100</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>CurrentStorageSizeInMB</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>MaxStorageSizeInMB</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>StorageAvailablePercent</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>DesiredState</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>ActualState</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>ReadOnlyReasonDescription</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>SqlQueryStore_List</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.SqlQueryStore</TypeName> </ViewSelectedBy> <ListControl> <!-- ################ LIST DEFINITIONS ################ --> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Current Storage Size (MB)</Label> <PropertyName>CurrentStorageSizeInMB</PropertyName> </ListItem> <ListItem> <Label>Max Storage Size (MB)</Label> <PropertyName>MaxStorageSizeInMB</PropertyName> </ListItem> <ListItem> <Label>Available Percent</Label> <PropertyName>StorageAvailablePercent</PropertyName> </ListItem> <ListItem> <Label>Desired State</Label> <PropertyName>DesiredState</PropertyName> </ListItem> <ListItem> <Label>Actual State</Label> <PropertyName>ActualState</PropertyName> </ListItem> <ListItem> <Label>Read Only Reason</Label> <PropertyName>ReadOnlyReason</PropertyName> </ListItem> <ListItem> <Label>Read Only Reason Description</Label> <PropertyName>ReadOnlyReasonDescription</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>SqlRecovery_Table</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.Restore</TypeName> </ViewSelectedBy> <GroupBy> <Label>Database Name</Label> <PropertyName>DatabaseName</PropertyName> </GroupBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>Backup Type</Label> <Width>22</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>File Name</Label> <Width>48</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Restore DML</Label> <Width>50</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>BackupType</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <ScriptBlock>([System.IO.FileInfo]$_.BackupFileName).Name</ScriptBlock> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>RestoreDML</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>SqlRecovery_List</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.Restore</TypeName> </ViewSelectedBy> <ListControl> <!-- ################ LIST DEFINITIONS ################ --> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Database Name</Label> <PropertyName>DatabaseName</PropertyName> </ListItem> <ListItem> <Label>Backup Database Name</Label> <PropertyName>BackupDatabaseName</PropertyName> </ListItem> <ListItem> <Label>Database GUID</Label> <PropertyName>DatabaseGUID</PropertyName> </ListItem> <ListItem> <Label>Backup File Name</Label> <PropertyName>BackupFileName</PropertyName> </ListItem> <ListItem> <Label>Backup Finish Date</Label> <PropertyName>BackupFinishDate</PropertyName> </ListItem> <ListItem> <Label>Backup Type</Label> <PropertyName>BackupType</PropertyName> </ListItem> <ListItem> <Label>Recovery Model</Label> <PropertyName>RecoveryModel</PropertyName> </ListItem> <ListItem> <Label>First LSN</Label> <PropertyName>FirstLSN</PropertyName> </ListItem> <ListItem> <Label>Last LSN</Label> <PropertyName>LastLSN</PropertyName> </ListItem> <ListItem> <Label>Checkpoint LSN</Label> <PropertyName>CheckpointLSN</PropertyName> </ListItem> <ListItem> <Label>Database Backup LSN</Label> <PropertyName>DatabaseBackupLSN</PropertyName> </ListItem> <ListItem> <Label>Restore DML</Label> <PropertyName>RestoreDML</PropertyName> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>SqlServerMaintenanceBackup</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.Backup</TypeName> </ViewSelectedBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>Database Name</Label> <Width>48</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Pages</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Seconds</Label> <Width>10</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>MB/sec</Label> <Width>10</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>DatabaseName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Pages</PropertyName> <Alignment>right</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Seconds</PropertyName> <Alignment>right</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>MBPerSecond</PropertyName> <Alignment>right</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>TableStatistics_Table</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.TableStatistics</TypeName> </ViewSelectedBy> <GroupBy> <CustomControlName>Statistics-GroupingFormat</CustomControlName> <ScriptBlock>$($_.DatabaseName + '&' + $_.StatisticsOptions)</ScriptBlock> </GroupBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>Schema Name</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Object Name</Label> <Width>28</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Statistics Name</Label> <Width>28</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Rows</Label> <Width>10</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Modified</Label> <Width>10</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Method</Label> <Width>8</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Row Threshold</Label> <Width>10</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Modification Threshold</Label> <Width>10</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <Wrap /> <TableColumnItems> <TableColumnItem> <PropertyName>SchemaName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>ObjectName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>StatisticsName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>RowCount</PropertyName> <Alignment>right</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>ModificationCount</PropertyName> <Alignment>right</Alignment> </TableColumnItem> <TableColumnItem> <ScriptBlock> switch ($_.Method) { 'StaticThreshold' { 'Static' } 'DynamicThreshold' { 'Dynamic' } 'None' { 'None' } 'NullModificationCount' { 'Null' } } </ScriptBlock> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>RowCountThreshold</PropertyName> <Alignment>right</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>ModificationCountThreshold</PropertyName> <Alignment>right</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>TableStatistics_Table</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.TableStatistics</TypeName> </ViewSelectedBy> <ListControl> <!-- ################ LIST DEFINITIONS ################ --> <ListEntries> <ListEntry> <ListItems> <ListItem> <Label>Database Name</Label> <PropertyName>DatabaseName</PropertyName> </ListItem> <ListItem> <Label>Schema Name</Label> <PropertyName>SchemaName</PropertyName> </ListItem> <ListItem> <Label>Object Name</Label> <PropertyName>ObjectName</PropertyName> </ListItem> <ListItem> <Label>Statistics Name</Label> <PropertyName>StatisticsName</PropertyName> </ListItem> <ListItem> <Label>Row Count</Label> <PropertyName>RowCount</PropertyName> </ListItem> <ListItem> <Label>Modification Count</Label> <PropertyName>ModificationCount</PropertyName> </ListItem> <ListItem> <Label>Method</Label> <PropertyName>Method</PropertyName> </ListItem> <ListItem> <Label>Row Count Threshold</Label> <PropertyName>RowCountThreshold</PropertyName> </ListItem> <ListItem> <Label>Modification Count Threshold</Label> <PropertyName>ModificationCountThreshold</PropertyName> </ListItem> <ListItem> <Label>Statistics Options</Label> <ScriptBlock> if ($_.StatisticsOptions) { $_.StatisticsOptions } else { 'None' } </ScriptBlock> </ListItem> </ListItems> </ListEntry> </ListEntries> </ListControl> </View> <View> <Name>TransparentDataEncryptionStatus</Name> <ViewSelectedBy> <TypeName>SqlServerMaintenance.TransparentDataEncryptionStatus</TypeName> </ViewSelectedBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>Database Name</Label> <Width>32</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Encryption State</Label> <Width>36</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Percent Complete</Label> <Width>10</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Key Algorithm</Label> <Width>10</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Key Length</Label> <Width>10</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Encryptor Type</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>DatabaseName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>EncryptionState</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>PercentComplete</PropertyName> <Alignment>right</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>KeyAlgorithm</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>KeyLength</PropertyName> <Alignment>right</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>EncryptorType</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> </ViewDefinitions> </Configuration> <!-- SIG # Begin signature block --> <!-- MIInywYJKoZIhvcNAQcCoIInvDCCJ7gCAQExDzANBglghkgBZQMEAgEFADB5Bgor --> <!-- BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG --> <!-- KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCAo+k+wnaqVJoGd --> <!-- 3dhxhbaTg7htAOfFe6UJomvu2fNAMKCCINswggWNMIIEdaADAgECAhAOmxiO+dAt --> <!-- 5+/bUOIIQBhaMA0GCSqGSIb3DQEBDAUAMGUxCzAJBgNVBAYTAlVTMRUwEwYDVQQK --> <!-- EwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xJDAiBgNV --> <!-- BAMTG0RpZ2lDZXJ0IEFzc3VyZWQgSUQgUm9vdCBDQTAeFw0yMjA4MDEwMDAwMDBa --> <!-- Fw0zMTExMDkyMzU5NTlaMGIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2Vy --> <!-- dCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xITAfBgNVBAMTGERpZ2lD --> <!-- ZXJ0IFRydXN0ZWQgUm9vdCBHNDCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoC --> <!-- ggIBAL/mkHNo3rvkXUo8MCIwaTPswqclLskhPfKK2FnC4SmnPVirdprNrnsbhA3E --> <!-- MB/zG6Q4FutWxpdtHauyefLKEdLkX9YFPFIPUh/GnhWlfr6fqVcWWVVyr2iTcMKy --> <!-- unWZanMylNEQRBAu34LzB4TmdDttceItDBvuINXJIB1jKS3O7F5OyJP4IWGbNOsF --> <!-- xl7sWxq868nPzaw0QF+xembud8hIqGZXV59UWI4MK7dPpzDZVu7Ke13jrclPXuU1 --> <!-- 5zHL2pNe3I6PgNq2kZhAkHnDeMe2scS1ahg4AxCN2NQ3pC4FfYj1gj4QkXCrVYJB --> <!-- MtfbBHMqbpEBfCFM1LyuGwN1XXhm2ToxRJozQL8I11pJpMLmqaBn3aQnvKFPObUR --> <!-- WBf3JFxGj2T3wWmIdph2PVldQnaHiZdpekjw4KISG2aadMreSx7nDmOu5tTvkpI6 --> <!-- nj3cAORFJYm2mkQZK37AlLTSYW3rM9nF30sEAMx9HJXDj/chsrIRt7t/8tWMcCxB --> <!-- YKqxYxhElRp2Yn72gLD76GSmM9GJB+G9t+ZDpBi4pncB4Q+UDCEdslQpJYls5Q5S --> <!-- UUd0viastkF13nqsX40/ybzTQRESW+UQUOsxxcpyFiIJ33xMdT9j7CFfxCBRa2+x --> <!-- q4aLT8LWRV+dIPyhHsXAj6KxfgommfXkaS+YHS312amyHeUbAgMBAAGjggE6MIIB --> <!-- NjAPBgNVHRMBAf8EBTADAQH/MB0GA1UdDgQWBBTs1+OC0nFdZEzfLmc/57qYrhwP --> <!-- TzAfBgNVHSMEGDAWgBRF66Kv9JLLgjEtUYunpyGd823IDzAOBgNVHQ8BAf8EBAMC --> <!-- AYYweQYIKwYBBQUHAQEEbTBrMCQGCCsGAQUFBzABhhhodHRwOi8vb2NzcC5kaWdp --> <!-- Y2VydC5jb20wQwYIKwYBBQUHMAKGN2h0dHA6Ly9jYWNlcnRzLmRpZ2ljZXJ0LmNv --> <!-- bS9EaWdpQ2VydEFzc3VyZWRJRFJvb3RDQS5jcnQwRQYDVR0fBD4wPDA6oDigNoY0 --> <!-- aHR0cDovL2NybDMuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0QXNzdXJlZElEUm9vdENB --> <!-- LmNybDARBgNVHSAECjAIMAYGBFUdIAAwDQYJKoZIhvcNAQEMBQADggEBAHCgv0Nc --> <!-- Vec4X6CjdBs9thbX979XB72arKGHLOyFXqkauyL4hxppVCLtpIh3bb0aFPQTSnov --> <!-- Lbc47/T/gLn4offyct4kvFIDyE7QKt76LVbP+fT3rDB6mouyXtTP0UNEm0Mh65Zy --> <!-- oUi0mcudT6cGAxN3J0TU53/oWajwvy8LpunyNDzs9wPHh6jSTEAZNUZqaVSwuKFW --> <!-- juyk1T3osdz9HNj0d1pcVIxv76FQPfx2CWiEn2/K2yCNNWAcAgPLILCsWKAOQGPF --> <!-- mCLBsln1VWvPJ6tsds5vIy30fnFqI2si/xK4VC0nftg62fC2h5b9W9FcrBjDTZ9z --> <!-- twGpn1eqXijiuZQwgga0MIIEnKADAgECAhANx6xXBf8hmS5AQyIMOkmGMA0GCSqG --> <!-- SIb3DQEBCwUAMGIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2VydCBJbmMx --> <!-- GTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xITAfBgNVBAMTGERpZ2lDZXJ0IFRy --> <!-- dXN0ZWQgUm9vdCBHNDAeFw0yNTA1MDcwMDAwMDBaFw0zODAxMTQyMzU5NTlaMGkx --> <!-- CzAJBgNVBAYTAlVTMRcwFQYDVQQKEw5EaWdpQ2VydCwgSW5jLjFBMD8GA1UEAxM4 --> <!-- RGlnaUNlcnQgVHJ1c3RlZCBHNCBUaW1lU3RhbXBpbmcgUlNBNDA5NiBTSEEyNTYg --> <!-- MjAyNSBDQTEwggIiMA0GCSqGSIb3DQEBAQUAA4ICDwAwggIKAoICAQC0eDHTCphB --> <!-- cr48RsAcrHXbo0ZodLRRF51NrY0NlLWZloMsVO1DahGPNRcybEKq+RuwOnPhof6p --> <!-- vF4uGjwjqNjfEvUi6wuim5bap+0lgloM2zX4kftn5B1IpYzTqpyFQ/4Bt0mAxAHe --> <!-- HYNnQxqXmRinvuNgxVBdJkf77S2uPoCj7GH8BLuxBG5AvftBdsOECS1UkxBvMgEd --> <!-- gkFiDNYiOTx4OtiFcMSkqTtF2hfQz3zQSku2Ws3IfDReb6e3mmdglTcaarps0wjU --> <!-- jsZvkgFkriK9tUKJm/s80FiocSk1VYLZlDwFt+cVFBURJg6zMUjZa/zbCclF83bR --> <!-- VFLeGkuAhHiGPMvSGmhgaTzVyhYn4p0+8y9oHRaQT/aofEnS5xLrfxnGpTXiUOeS --> <!-- LsJygoLPp66bkDX1ZlAeSpQl92QOMeRxykvq6gbylsXQskBBBnGy3tW/AMOMCZIV --> <!-- NSaz7BX8VtYGqLt9MmeOreGPRdtBx3yGOP+rx3rKWDEJlIqLXvJWnY0v5ydPpOjL --> <!-- 6s36czwzsucuoKs7Yk/ehb//Wx+5kMqIMRvUBDx6z1ev+7psNOdgJMoiwOrUG2Zd --> <!-- SoQbU2rMkpLiQ6bGRinZbI4OLu9BMIFm1UUl9VnePs6BaaeEWvjJSjNm2qA+sdFU --> <!-- eEY0qVjPKOWug/G6X5uAiynM7Bu2ayBjUwIDAQABo4IBXTCCAVkwEgYDVR0TAQH/ --> <!-- BAgwBgEB/wIBADAdBgNVHQ4EFgQU729TSunkBnx6yuKQVvYv1Ensy04wHwYDVR0j --> <!-- BBgwFoAU7NfjgtJxXWRM3y5nP+e6mK4cD08wDgYDVR0PAQH/BAQDAgGGMBMGA1Ud --> <!-- JQQMMAoGCCsGAQUFBwMIMHcGCCsGAQUFBwEBBGswaTAkBggrBgEFBQcwAYYYaHR0 --> <!-- cDovL29jc3AuZGlnaWNlcnQuY29tMEEGCCsGAQUFBzAChjVodHRwOi8vY2FjZXJ0 --> <!-- cy5kaWdpY2VydC5jb20vRGlnaUNlcnRUcnVzdGVkUm9vdEc0LmNydDBDBgNVHR8E --> <!-- PDA6MDigNqA0hjJodHRwOi8vY3JsMy5kaWdpY2VydC5jb20vRGlnaUNlcnRUcnVz --> <!-- dGVkUm9vdEc0LmNybDAgBgNVHSAEGTAXMAgGBmeBDAEEAjALBglghkgBhv1sBwEw --> <!-- DQYJKoZIhvcNAQELBQADggIBABfO+xaAHP4HPRF2cTC9vgvItTSmf83Qh8WIGjB/ --> <!-- T8ObXAZz8OjuhUxjaaFdleMM0lBryPTQM2qEJPe36zwbSI/mS83afsl3YTj+IQhQ --> <!-- E7jU/kXjjytJgnn0hvrV6hqWGd3rLAUt6vJy9lMDPjTLxLgXf9r5nWMQwr8Myb9r --> <!-- EVKChHyfpzee5kH0F8HABBgr0UdqirZ7bowe9Vj2AIMD8liyrukZ2iA/wdG2th9y --> <!-- 1IsA0QF8dTXqvcnTmpfeQh35k5zOCPmSNq1UH410ANVko43+Cdmu4y81hjajV/gx --> <!-- dEkMx1NKU4uHQcKfZxAvBAKqMVuqte69M9J6A47OvgRaPs+2ykgcGV00TYr2Lr3t --> <!-- y9qIijanrUR3anzEwlvzZiiyfTPjLbnFRsjsYg39OlV8cipDoq7+qNNjqFzeGxcy --> <!-- tL5TTLL4ZaoBdqbhOhZ3ZRDUphPvSRmMThi0vw9vODRzW6AxnJll38F0cuJG7uEB --> <!-- YTptMSbhdhGQDpOXgpIUsWTjd6xpR6oaQf/DJbg3s6KCLPAlZ66RzIg9sC+NJpud --> <!-- /v4+7RWsWCiKi9EOLLHfMR2ZyJ/+xhCx9yHbxtl5TPau1j/1MIDpMPx0LckTetiS --> <!-- uEtQvLsNz3Qbp7wGWqbIiOWCnb5WqxL3/BAPvIXKUjPSxyZsq8WhbaM2tszWkPZP --> <!-- ubdcMIIGuTCCBKGgAwIBAgIRAJmjgAomVTtlq9xuhKaz6jkwDQYJKoZIhvcNAQEM --> <!-- BQAwgYAxCzAJBgNVBAYTAlBMMSIwIAYDVQQKExlVbml6ZXRvIFRlY2hub2xvZ2ll --> <!-- cyBTLkEuMScwJQYDVQQLEx5DZXJ0dW0gQ2VydGlmaWNhdGlvbiBBdXRob3JpdHkx --> <!-- JDAiBgNVBAMTG0NlcnR1bSBUcnVzdGVkIE5ldHdvcmsgQ0EgMjAeFw0yMTA1MTkw --> <!-- NTMyMThaFw0zNjA1MTgwNTMyMThaMFYxCzAJBgNVBAYTAlBMMSEwHwYDVQQKExhB --> <!-- c3NlY28gRGF0YSBTeXN0ZW1zIFMuQS4xJDAiBgNVBAMTG0NlcnR1bSBDb2RlIFNp --> <!-- Z25pbmcgMjAyMSBDQTCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoCggIBAJ0j --> <!-- zwQwIzvBRiznM3M+Y116dbq+XE26vest+L7k5n5TeJkgH4Cyk74IL9uP61olRsxs --> <!-- U/WBAElTMNQI/HsE0uCJ3VPLO1UufnY0qDHG7yCnJOvoSNbIbMpT+Cci75scCx7U --> <!-- sKK1fcJo4TXetu4du2vEXa09Tx/bndCBfp47zJNsamzUyD7J1rcNxOw5g6FJg0Im --> <!-- Iv7nCeNn3B6gZG28WAwe0mDqLrvU49chyKIc7gvCjan3GH+2eP4mYJASflBTQ3HO --> <!-- s6JGdriSMVoD1lzBJobtYDF4L/GhlLEXWgrVQ9m0pW37KuwYqpY42grp/kSYE4BU --> <!-- QrbLgBMNKRvfhQPskDfZ/5GbTCyvlqPN+0OEDmYGKlVkOMenDO/xtMrMINRJS5SY --> <!-- +jWCi8PRHAVxO0xdx8m2bWL4/ZQ1dp0/JhUpHEpABMc3eKax8GI1F03mSJVV6o/n --> <!-- mmKqDE6TK34eTAgDiBuZJzeEPyR7rq30yOVw2DvetlmWssewAhX+cnSaaBKMEj9O --> <!-- 2GgYkPJ16Q5Da1APYO6n/6wpCm1qUOW6Ln1J6tVImDyAB5Xs3+JriasaiJ7P5KpX --> <!-- eiVV/HIsW3ej85A6cGaOEpQA2gotiUqZSkoQUjQ9+hPxDVb/Lqz0tMjp6RuLSKAR --> <!-- sVQgETwoNQZ8jCeKwSQHDkpwFndfCceZ/OfCUqjxAgMBAAGjggFVMIIBUTAPBgNV --> <!-- HRMBAf8EBTADAQH/MB0GA1UdDgQWBBTddF1MANt7n6B0yrFu9zzAMsBwzTAfBgNV --> <!-- HSMEGDAWgBS2oVQ5AsOgP46KvPrU+Bym0ToO/TAOBgNVHQ8BAf8EBAMCAQYwEwYD --> <!-- VR0lBAwwCgYIKwYBBQUHAwMwMAYDVR0fBCkwJzAloCOgIYYfaHR0cDovL2NybC5j --> <!-- ZXJ0dW0ucGwvY3RuY2EyLmNybDBsBggrBgEFBQcBAQRgMF4wKAYIKwYBBQUHMAGG --> <!-- HGh0dHA6Ly9zdWJjYS5vY3NwLWNlcnR1bS5jb20wMgYIKwYBBQUHMAKGJmh0dHA6 --> <!-- Ly9yZXBvc2l0b3J5LmNlcnR1bS5wbC9jdG5jYTIuY2VyMDkGA1UdIAQyMDAwLgYE --> <!-- VR0gADAmMCQGCCsGAQUFBwIBFhhodHRwOi8vd3d3LmNlcnR1bS5wbC9DUFMwDQYJ --> <!-- KoZIhvcNAQEMBQADggIBAHWIWA/lj1AomlOfEOxD/PQ7bcmahmJ9l0Q4SZC+j/v0 --> <!-- 9CD2csX8Yl7pmJQETIMEcy0VErSZePdC/eAvSxhd7488x/Cat4ke+AUZZDtfCd8y --> <!-- HZgikGuS8mePCHyAiU2VSXgoQ1MrkMuqxg8S1FALDtHqnizYS1bIMOv8znyJjZQE --> <!-- Sp9RT+6NH024/IqTRsRwSLrYkbFq4VjNn/KV3Xd8dpmyQiirZdrONoPSlCRxCIi5 --> <!-- 4vQcqKiFLpeBm5S0IoDtLoIe21kSw5tAnWPazS6sgN2oXvFpcVVpMcq0C4x/CLSN --> <!-- e0XckmmGsl9z4UUguAJtf+5gE8GVsEg/ge3jHGTYaZ/MyfujE8hOmKBAUkVa7NMx --> <!-- RSB1EdPFpNIpEn/pSHuSL+kWN/2xQBJaDFPr1AX0qLgkXmcEi6PFnaw5T17UdIIn --> <!-- A58rTu3mefNuzUtse4AgYmxEmJDodf8NbVcU6VdjWtz0e58WFZT7tST6EWQmx/Oo --> <!-- HPelE77lojq7lpsjhDCzhhp4kfsfszxf9g2hoCtltXhCX6NqsqwTT7xe8LgMkH4h --> <!-- Vy8L1h2pqGLT2aNCx7h/F95/QvsTeGGjY7dssMzq/rSshFQKLZ8lPb8hFTmiGDJN --> <!-- yHga5hZ59IGynk08mHhBFM/0MLeBzlAQq1utNjQprztZ5vv/NJy8ua9AGbwkMWkO --> <!-- MIIG4DCCBMigAwIBAgIQQ7s0QZ8qUnHOP66HyvajHjANBgkqhkiG9w0BAQsFADBW --> <!-- MQswCQYDVQQGEwJQTDEhMB8GA1UEChMYQXNzZWNvIERhdGEgU3lzdGVtcyBTLkEu --> <!-- MSQwIgYDVQQDExtDZXJ0dW0gQ29kZSBTaWduaW5nIDIwMjEgQ0EwHhcNMjYwOTEy --> <!-- MjEzNTQ3WhcNMjcwOTEyMjEzNTQ2WjCBhTELMAkGA1UEBhMCVVMxFzAVBgNVBAgM --> <!-- DlNvdXRoIENhcm9saW5hMREwDwYDVQQHDAhOZXdiZXJyeTEeMBwGA1UECgwVT3Bl --> <!-- biBTb3VyY2UgRGV2ZWxvcGVyMSowKAYDVQQDDCFPcGVuIFNvdXJjZSBEZXZlbG9w --> <!-- ZXIgUm9iZXJ0IEVkZXIwggIiMA0GCSqGSIb3DQEBAQUAA4ICDwAwggIKAoICAQC6 --> <!-- 72ybkWUB620cgb49nkhI4VvtWKABeSD8277f0Jww+/5fKUxoX2vC77QjmaSXU+I9 --> <!-- LB2YTj8yCSTDVlxIwJoS7KgsIN9P2EC6ehJe9FRI0n2Rt33/VlRY8kuSh2XsIVGg --> <!-- i6Y3RooWVjVmYCAOXuV5zrqjGY1P72nrSIekxcGCTo1Y0nmRwsECCIYn7b3ZM065 --> <!-- u9b3AtYf3oI4grblWhtY0kbuHNCSeDjpp+qExQgeIs6OpFACJSDASFiDnF8+L+bB --> <!-- V+UtUcFbvlu0WpQyblXw9vdN7BEIdqZ/1fxyhjHxqpSuOoTqoZcyDjilXtnMOfWp --> <!-- gfgdKPFRc6NHwrmxUyNLAYHOsqBC+bMxamurB1qCJ/16lFbW/YWJRrJsaeA2WaPw --> <!-- 8ulkUnZUoP9JgyVE1nwZbhZOgE3YwlVLmBBsAKsRiyJWBYqG1VdaMpfzLYJVNTc8 --> <!-- 4F/90uC2BvIoafcFfNyc8dIpdd7Ni17JmYuD0+/u1gqUi3p+Qdlk/y+Vgsb1x+0z --> <!-- kaMA6CzjFA83szdzwRLFDDnaUOVngyRR8+JLnSNuEw9nNM3G5WWRGBDOkLbwq+NO --> <!-- H1gWWAaJJYOlTARrg7ea2JHLl66CBJaaledp2u8hBl1Y5yQTpIkVYx0VPt1Oa7Nq --> <!-- kOkXlNjmmlYsZm5pe3fSTBPx5YdUOeIl1sAWXGH/+QIDAQABo4IBeDCCAXQwDAYD --> <!-- VR0TAQH/BAIwADA9BgNVHR8ENjA0MDKgMKAuhixodHRwOi8vY2NzY2EyMDIxLmNy --> <!-- bC5jZXJ0dW0ucGwvY2NzY2EyMDIxLmNybDBzBggrBgEFBQcBAQRnMGUwLAYIKwYB --> <!-- BQUHMAGGIGh0dHA6Ly9jY3NjYTIwMjEub2NzcC1jZXJ0dW0uY29tMDUGCCsGAQUF --> <!-- BzAChilodHRwOi8vcmVwb3NpdG9yeS5jZXJ0dW0ucGwvY2NzY2EyMDIxLmNlcjAf --> <!-- BgNVHSMEGDAWgBTddF1MANt7n6B0yrFu9zzAMsBwzTAdBgNVHQ4EFgQUCdHvF5Qw --> <!-- xL78QY6vfJNPC89uTWEwSwYDVR0gBEQwQjAIBgZngQwBBAEwNgYLKoRoAYb2dwIF --> <!-- AQQwJzAlBggrBgEFBQcCARYZaHR0cHM6Ly93d3cuY2VydHVtLnBsL0NQUzATBgNV --> <!-- HSUEDDAKBggrBgEFBQcDAzAOBgNVHQ8BAf8EBAMCB4AwDQYJKoZIhvcNAQELBQAD --> <!-- ggIBADGvhUwApFlOiMwxr4muEgH+EK8xGwyw7qZGQZYdHQZV7E6ev+4i0u2ywMbF --> <!-- H0XcYpaB4xubprYIGbltJhIXoIM+BmIB6mgzgAtKMJBIWMECnACZKPAWPJ5vp3Xu --> <!-- GLCg0gwQGZEKJInwEFLzplH3G5g8hTO8KSLmWLVWoWHTTA3WI4LgTf/XRs3QYqur --> <!-- bB1gWRWa+vx8J/4I6znbpnpRDxy/jCYh9qtv21Dk3BovIPnfaj50JOWJhWeongQ6 --> <!-- Dgd4/FZhM/U1Fj/g1W7WDMal9q43MABwmrHPbxrIEK1V5vXwAhK1m9eSaZ8bqbeA --> <!-- SId0wOYzIyEziquoO5TCdf/lSi8nD4BIm2E+h738pLQXWvr6tYWyvqaUN0uk5f27 --> <!-- NsXlVRYp8EUZPP83BJMaQJFgTsYPMeZejAndk3nuqPVGeCL6WW90M7eK5sPbTAmW --> <!-- WrSnYFx4pgnMR3X3s14074ytJ3o3ycKa0bxjhMcoCTfMDmV7jUUhATpW8iZ2/E4b --> <!-- +0s7DmbN37VsBngsj04vMyVxhcNLSwdFDTQEgkEwHccChlw0anfoZJ7Xui4x5RSr --> <!-- j3rOyyrf7mFYIpsbDYjVxBo5/JVJuu5h2+BRxY9MLoSMknm391tCI7aVC/XTl/zW --> <!-- rX1kJeCx0nYBnZnmjWCRrCXWOX5V8QaLAnK/R6durGeXnlo3MIIG7TCCBNWgAwIB --> <!-- AgIQCE/cM09+RU7bww+P+ZIYNTANBgkqhkiG9w0BAQsFADBpMQswCQYDVQQGEwJV --> <!-- UzEXMBUGA1UEChMORGlnaUNlcnQsIEluYy4xQTA/BgNVBAMTOERpZ2lDZXJ0IFRy --> <!-- dXN0ZWQgRzQgVGltZVN0YW1waW5nIFJTQTQwOTYgU0hBMjU2IDIwMjUgQ0ExMB4X --> <!-- DTI2MDgwNTAwMDAwMFoXDTM3MTEwNDIzNTk1OVowYzELMAkGA1UEBhMCVVMxFzAV --> <!-- BgNVBAoTDkRpZ2lDZXJ0LCBJbmMuMTswOQYDVQQDEzJEaWdpQ2VydCBTSEEyNTYg --> <!-- UlNBNDA5NiBUaW1lc3RhbXAgUmVzcG9uZGVyIDIwMjYgMTCCAiIwDQYJKoZIhvcN --> <!-- AQEBBQADggIPADCCAgoCggIBALZ7pvLJ/s1K+NSbTGWz/TjGMPh8CQ6RucZCLv5a --> <!-- nHzWJjF/NWJrFIhy24fcpKXlgRiky4WAawDfU3YP0BMxt9l3Dm5oCG5Z69AqEN1k --> <!-- gHg2epx+l+lZBcmJCcN0ASURML5uFIS80sZsDwO3BSkUxDjLJhBI+qiZP3aixAC/ --> <!-- qEGLjsBNlLol9VZ7pfGEXiMlneJIC5/YKuizVzNFKZZEeoy/0B8Zm+nzKBgSWG52 --> <!-- lCO1w+nCg6XpCtklTJXeIg283hw7TmmsZXR+SMbjbrEOvZ3fP2VxIgeR28Y90ZSt --> <!-- d3F9VuA5RVynb/whITPAo9b75Zr4Ta6Mj3URm26QZYMn/FnbuTegcoRcFEZ9FOqM --> <!-- 5T6MTdtr/n74lIT/ug0eeOzmZ6QTFg33otX+bFRsIolvykE1jive4PuESaT8zzVe --> <!-- FWDAMDtozNgLctkGD1ZjkEyZtJrLl5ya0m5doH/ScpaZCZVl6pNUOCybMc/kxC6E --> <!-- AmSJY24L0yYKD1Nkddsnb/ItVKi/2nXpQNMu1PT5prW83vV8d67WowuUs0HdY4H8 --> <!-- AMLGvdL/WHEj3ZnqMqAQQP9u3Ai9t+5eQ02GDwy0ODjdzi0xlp70W+ow63/0++YD --> <!-- EX1M0iwgUHwbrJvfpklkZQvw3+kv3vUPItdwroczk9icflf55W1zOEKAcJVAIXpc --> <!-- MCU9AgMBAAGjggGVMIIBkTAMBgNVHRMBAf8EAjAAMB0GA1UdDgQWBBQUyWOKMC7U --> <!-- SvtulPPm40B+9ezN4jAfBgNVHSMEGDAWgBTvb1NK6eQGfHrK4pBW9i/USezLTjAO --> <!-- BgNVHQ8BAf8EBAMCB4AwFgYDVR0lAQH/BAwwCgYIKwYBBQUHAwgwgZUGCCsGAQUF --> <!-- BwEBBIGIMIGFMCQGCCsGAQUFBzABhhhodHRwOi8vb2NzcC5kaWdpY2VydC5jb20w --> <!-- XQYIKwYBBQUHMAKGUWh0dHA6Ly9jYWNlcnRzLmRpZ2ljZXJ0LmNvbS9EaWdpQ2Vy --> <!-- dFRydXN0ZWRHNFRpbWVTdGFtcGluZ1JTQTQwOTZTSEEyNTYyMDI1Q0ExLmNydDBf --> <!-- BgNVHR8EWDBWMFSgUqBQhk5odHRwOi8vY3JsMy5kaWdpY2VydC5jb20vRGlnaUNl --> <!-- cnRUcnVzdGVkRzRUaW1lU3RhbXBpbmdSU0E0MDk2U0hBMjU2MjAyNUNBMS5jcmww --> <!-- IAYDVR0gBBkwFzAIBgZngQwBBAIwCwYJYIZIAYb9bAcBMA0GCSqGSIb3DQEBCwUA --> <!-- A4ICAQCNxTphHp1SCt+ZrAmAfn0oQLFr0mLywSLaDXQIENoyKqxrFbJblzCVP/pk --> <!-- XmwXOdrOpWygLzlT12os5ipDCy35RBCg2UMeApEtrfGhz45F4Wt4WGdNdIbRWt3Y --> <!-- TYJmpR+b7lr4d7Uwn+H600u4D7RnOGf8Wj4UNgAdZkfHhHv1mx9EVh71SJelcEN/ --> <!-- oORSjXzdjfw1iZH9d8Nh/thn6hH23d+VsPAr6GAYyzSA02nXD1nYLI7Ijmiv+xLC --> <!-- iYC41DSFYL3GhTiy0PxpawPtGRyaBVGzq+UiTfM8pD7KVyF5aQyWP4KhVGUUTnmm --> <!-- /RlYJoW3TiXA/+t0YcT2oRVBm3JETjajHug2AL+v5jhtKVnd3D0rbHXEu27o+Q8p --> <!-- 4sEWPMqKDB+qbceb6T/6WcwTwXmQ9lOCLLYcsQeSWmvKqzpAec9etE14jOQAzLKW --> <!-- dE3w/TCaKtLRaRT7LCkRYVnhA2D73FLje1O5b3HR5eHs0NzU/+xX7NbEdcofy0W3 --> <!-- Wdwd1XOqtlpg/JgwtKfZM5dqO94lbUveOiJBI+xZEbGRsMNbXmMREUTgu+Oca7Y7 --> <!-- 3MPWcslIx2VhkSKSXjDbD6rgg39H5Mh7QfieAIjWagkJNt68Yfim6cjEzVSiLSeZ --> <!-- fdkr5dtFPTW6jATlWJdYeeDRGCyatf8R1hSjzSvdN8yWQPT9gzGCBkYwggZCAgEB --> <!-- MGowVjELMAkGA1UEBhMCUEwxITAfBgNVBAoTGEFzc2VjbyBEYXRhIFN5c3RlbXMg --> <!-- Uy5BLjEkMCIGA1UEAxMbQ2VydHVtIENvZGUgU2lnbmluZyAyMDIxIENBAhBDuzRB --> <!-- nypScc4/rofK9qMeMA0GCWCGSAFlAwQCAQUAoIGEMBgGCisGAQQBgjcCAQwxCjAI --> <!-- oAKAAKECgAAwGQYJKoZIhvcNAQkDMQwGCisGAQQBgjcCAQQwHAYKKwYBBAGCNwIB --> <!-- CzEOMAwGCisGAQQBgjcCARUwLwYJKoZIhvcNAQkEMSIEIPbsDo8CxkfCr0KHsD4R --> <!-- TpPyHUpEcopNEmY2diVSgloAMA0GCSqGSIb3DQEBAQUABIICADFv7GhwebyieH2x --> <!-- lZw+nlvWmdpPkqe2Za6w/h2DeItHQVxHqkPe4DEz44XE3yks9yPH5/YxIYCfyUY1 --> <!-- z3M9cTUIb9FdiGcf2EfzYOFjlcRmMhfmrQtq/ZOD2cY5EE91ZlFuSYP6EKKD+dL0 --> <!-- KOhuYD2phr1wHVaX9+wFSJw3X0O47TjKQMBgTgy2e9AZf1fDJbT5B9sfO0DZLsAU --> <!-- l2Pbu3Pq+6svdvKz/urqiLEfVk2J1kwrtrLH0kGCCaSgyuyrSd2KGp/lfqd0a0D7 --> <!-- qFtcQE7+U38Y6/EmfNglqQpiYfjezIv3Kc98YIi8SkEQ4K3fUZRQ6j7if+vbLYpz --> <!-- vPiPhyIV7Q3USxmtgHho74eZ5Ur+sQWbczquLgBxQOlhrx6SNUvHKZFF2z5/BMFv --> <!-- YXWP5rnfPxSx1XuXSjRgGr6GGNlDlqatzxUWx509IXCBPf6Cv/L0U32GcAk1vQJR --> <!-- 0Jb5kTx1D96mD7Z5uqHtT+wEw0I2F/8ftTao6mfjR/75N0XpRlpFtF9kfpQwp2FB --> <!-- aaZlnNA8KlYe9J6hLh/3+LzeLZGj0aPUqzprB9o20fZnvv2JwMBGbboeR4voJZBr --> <!-- hsax9TfCE/eD9ZfHhZ5g0NMc7BOw/qkvxGXM0KyfeKnb/7TpaiDhl0qsCq1ETKo8 --> <!-- LNSCUpnFF8GTptrW3AQixOmujDaQoYIDJjCCAyIGCSqGSIb3DQEJBjGCAxMwggMP --> <!-- AgEBMH0waTELMAkGA1UEBhMCVVMxFzAVBgNVBAoTDkRpZ2lDZXJ0LCBJbmMuMUEw --> <!-- PwYDVQQDEzhEaWdpQ2VydCBUcnVzdGVkIEc0IFRpbWVTdGFtcGluZyBSU0E0MDk2 --> <!-- IFNIQTI1NiAyMDI1IENBMQIQCE/cM09+RU7bww+P+ZIYNTANBglghkgBZQMEAgEF --> <!-- AKBpMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTI2 --> <!-- MDkxMzE5MzYyMlowLwYJKoZIhvcNAQkEMSIEIFyfAqrnGvNRnPbecrY4pRDti6m2 --> <!-- jUUzE8pjgs/zd/7SMA0GCSqGSIb3DQEBAQUABIICAJ44iV/RzF19J14Naq+5MZkB --> <!-- AUlAvOfCuzXwzz+tgjdejSRP3BkC6HIY7O9kgQIpcC4EWEAbXZ72Tny6eUYEKSM3 --> <!-- gK9DQ7Nr4UG8NOhbyqxtg29+lDqac7hlu//AepSkuacOPWEJe7zuoBA8yCF2DJmF --> <!-- HsYnRbXFLhUNjJvIZwBm7iZ1jcRFsYNqnxkI2PgS9akwTwSC3CbwSyO2+E2ID/+b --> <!-- YLOnXj01JtXpzbrDvvzOT248VBapOlwvA/2kdZj8A3IWi5Qa7roQ0ZJsWgyS3hiA --> <!-- SA5bHB+z1UyByzv7xn0ZPeV7H43jEu6nkSqPKwAiymbc6jPxO7KEtKscsgIVXRMY --> <!-- UGwflgODtoWbNjbycabFFaMxfPRBQhqzPnZt16ir4rQlGDMYlU5gze9gAiM2HRln --> <!-- 0OY6ZvFVDY1BJfL48zhqaPuux0D/lgGHXcjeTuiInuX3zSKLoPyd3/6iZB/eKlaC --> <!-- 1yZIwtRTZPBlsrCCRMRXbAY4gZIB6m7wOGgRN8L5pve94S2unmBINogb2qy8YzAT --> <!-- Q9bgY7hxfmEQdDI4pfjWarccnkqPeeeZny7Jmq1N/z/L8pwxOrRByHhjPAHhM4uq --> <!-- MeWMQPIC9qSTmPQ6uqpM2pVkqyj5mRmz7p1E3nAhJNwHKyd/VD/BfChklV0KAE9Y --> <!-- YozGOWZFqT4JmjlM+Uf4 --> <!-- SIG # End signature block --> |