xml/dbatools.Format.ps1xml
<?xml version="1.0" encoding="utf-16"?>
<Configuration> <Controls> <Control> <Name>Configuration-GroupingFormat</Name> <CustomControl> <CustomEntries> <CustomEntry> <CustomItem> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Module: </Text> <ExpressionBinding> <PropertyName>Module</PropertyName> </ExpressionBinding> <NewLine/> </CustomItem> </Frame> </CustomItem> </CustomEntry> </CustomEntries> </CustomControl> </Control> </Controls> <ViewDefinitions> <View> <Name>Microsoft.SqlServer.Management.Smo.Server</Name> <ViewSelectedBy> <TypeName>Microsoft.SqlServer.Management.Smo.Server</TypeName> </ViewSelectedBy> <TableControl> <AutoSize /> <TableHeaders> <TableColumnHeader> </TableColumnHeader> <TableColumnHeader> </TableColumnHeader> <TableColumnHeader> </TableColumnHeader> <TableColumnHeader> </TableColumnHeader> <TableColumnHeader> </TableColumnHeader> <TableColumnHeader> </TableColumnHeader> <TableColumnHeader> </TableColumnHeader> <TableColumnHeader> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>ComputerName</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Name</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Product</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Version</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>HostPlatform</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>IsAzure</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>IsClustered</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>ConnectedAs</PropertyName> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <!-- Sqlcollaborative.Dbatools.Computer.DiskSpace --> <View> <Name>Sqlcollaborative.Dbatools.Computer.DiskSpace</Name> <ViewSelectedBy> <TypeName>Sqlcollaborative.Dbatools.Computer.DiskSpace</TypeName> </ViewSelectedBy> <TableControl> <AutoSize/> <TableHeaders> <TableColumnHeader> <Alignment>Right</Alignment> </TableColumnHeader> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>ComputerName</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Name</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Label</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Capacity</PropertyName> <Alignment>Right</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Free</PropertyName> <Alignment>Right</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>PercentFree</PropertyName> <Alignment>Right</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>BlockSize</PropertyName> <Alignment>Right</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>IsSqlDisk</PropertyName> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <!-- Sqlcollaborative.Dbatools.Computer.PageFileSetting --> <View> <Name>Sqlcollaborative.Dbatools.Computer.PageFileSetting</Name> <ViewSelectedBy> <TypeName>Sqlcollaborative.Dbatools.Computer.PageFileSetting</TypeName> </ViewSelectedBy> <TableControl> <AutoSize/> <TableHeaders> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>ComputerName</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>AutoPageFile</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Status</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>FileName</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>InitialSize</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>MaximumSize</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>PeakUsage</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>CurrentUsage</PropertyName> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <!-- Sqlcollaborative.Dbatools.Configuration.Config --> <View> <Name>Sqlcollaborative.Dbatools.Configuration.Config</Name> <ViewSelectedBy> <TypeName>Sqlcollaborative.Dbatools.Configuration.Config</TypeName> </ViewSelectedBy> <GroupBy> <PropertyName>Module</PropertyName> <CustomControlName>Configuration-GroupingFormat</CustomControlName> </GroupBy> <TableControl> <AutoSize/> <TableHeaders> <TableColumnHeader/> <TableColumnHeader> <Label>Value</Label> <Alignment>Left</Alignment> </TableColumnHeader> <TableColumnHeader> <Alignment>Left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>FullName</PropertyName> </TableColumnItem> <TableColumnItem> <ScriptBlock> if ($null -ne $_.Value) { if ($_.Value.ToString().Length -le 20) { $_.Value.ToString() } else { $_.Value.ToString().SubString(0,17) + "..." } } </ScriptBlock> </TableColumnItem> <TableColumnItem> <PropertyName>Description</PropertyName> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <!-- Sqlcollaborative.Dbatools.Connection.ManagementConnection --> <View> <Name>Sqlcollaborative.Dbatools.Connection.ManagementConnection</Name> <ViewSelectedBy> <TypeName>Sqlcollaborative.Dbatools.Connection.ManagementConnection</TypeName> </ViewSelectedBy> <TableControl> <AutoSize/> <TableHeaders> <TableColumnHeader/> <TableColumnHeader> <Label>Available</Label> </TableColumnHeader> <TableColumnHeader> <Label>User</Label> </TableColumnHeader> <TableColumnHeader> <Label>Override</Label> </TableColumnHeader> <TableColumnHeader/> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>ComputerName</PropertyName> </TableColumnItem> <TableColumnItem> <ScriptBlock> ($_.CimRM -like 'Success') -or ($_.CimDCOM -like 'Success') -or ($_.Wmi -like 'Success') -or ($_.PowerShellRemoting -like 'Success') </ScriptBlock> </TableColumnItem> <TableColumnItem> <ScriptBlock> if ($_.Credentials.UserName) { $_.Credentials.UserName } else { $env:USERDOMAIN + "\" + $env:USERNAME } </ScriptBlock> </TableColumnItem> <TableColumnItem> <PropertyName>OverrideExplicitCredential</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>DisabledConnectionTypes</PropertyName> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <!-- Sqlcollaborative.Dbatools.Database.Dependency --> <View> <Name>Sqlcollaborative.Dbatools.Database.Dependency</Name> <ViewSelectedBy> <TypeName>Sqlcollaborative.Dbatools.Database.Dependency</TypeName> </ViewSelectedBy> <TableControl> <AutoSize/> <TableHeaders> <TableColumnHeader> <Label>T.</Label> </TableColumnHeader> <TableColumnHeader> <Label>Schema</Label> </TableColumnHeader> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>Tier</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>IsSchemaBound</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Dependent</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Type</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Parent</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>ParentType</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Owner</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Object</PropertyName> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <!-- Sqlcollaborative.Dbatools.Database.BackupHistory --> <View> <Name>Sqlcollaborative.Dbatools.Database.BackupHistory</Name> <ViewSelectedBy> <TypeName>Sqlcollaborative.Dbatools.Database.BackupHistory</TypeName> </ViewSelectedBy> <TableControl> <AutoSize/> <TableHeaders> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader> <Label>Start</Label> </TableColumnHeader> <TableColumnHeader/> <TableColumnHeader> <Label>End</Label> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>SqlInstance</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Database</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Type</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>TotalSize</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>DeviceType</PropertyName> </TableColumnItem> <TableColumnItem> <ScriptBlock> if ([Sqlcollaborative.Dbatools.Utility.UtilityHost]::DisableCustomDateTime) { $_.Start } else { $_.Start.ToString([Sqlcollaborative.Dbatools.Utility.UtilityHost]::FormatDateTime) } </ScriptBlock> </TableColumnItem> <TableColumnItem> <PropertyName>Duration</PropertyName> </TableColumnItem> <TableColumnItem> <ScriptBlock> if ([Sqlcollaborative.Dbatools.Utility.UtilityHost]::DisableCustomDateTime) { $_.End } else { $_.End.ToString([Sqlcollaborative.Dbatools.Utility.UtilityHost]::FormatDateTime) } </ScriptBlock> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <!-- Sqlcollaborative.Dbatools.Message.DbatoolsExceptionRecord --> <View> <Name>Sqlcollaborative.Dbatools.Message.DbatoolsExceptionRecord</Name> <ViewSelectedBy> <TypeName>Sqlcollaborative.Dbatools.Message.DbatoolsExceptionRecord</TypeName> </ViewSelectedBy> <TableControl> <AutoSize/> <TableHeaders> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader> <Label>TargetObject</Label> </TableColumnHeader> <TableColumnHeader/> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>Timestamp</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>FunctionName</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>ExceptionType</PropertyName> </TableColumnItem> <TableColumnItem> <ScriptBlock> if ($_.TargetObject.ToString().Length -le 20) { $_.TargetObject.ToString() } else { $_.TargetObject.ToString().SubString(0,17) + "..." } </ScriptBlock> </TableColumnItem> <TableColumnItem> <PropertyName>Message</PropertyName> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <!-- Sqlcollaborative.Dbatools.Message.LogEntry --> <View> <Name>Sqlcollaborative.Dbatools.Message.LogEntry</Name> <ViewSelectedBy> <TypeName>Sqlcollaborative.Dbatools.Message.LogEntry</TypeName> </ViewSelectedBy> <TableControl> <AutoSize/> <TableHeaders> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader> <Label>TargetObject</Label> </TableColumnHeader> <TableColumnHeader/> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>Timestamp</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>FunctionName</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Level</PropertyName> </TableColumnItem> <TableColumnItem> <ScriptBlock> if ($_.TargetObject.ToString().Length -le 20) { $_.TargetObject.ToString() } else { $_.TargetObject.ToString().SubString(0,17) + "..." } </ScriptBlock> </TableColumnItem> <TableColumnItem> <PropertyName>Message</PropertyName> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <!-- Sqlcollaborative.Dbatools.Discovery.DbaInstanceReport --> <View> <Name>Sqlcollaborative.Dbatools.Discovery.DbaInstanceReport</Name> <ViewSelectedBy> <TypeName>Sqlcollaborative.Dbatools.Discovery.DbaInstanceReport</TypeName> </ViewSelectedBy> <TableControl> <AutoSize/> <TableHeaders> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>ComputerName</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>InstanceName</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Port</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Availability</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Confidence</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>ScanTypes</PropertyName> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <!-- Microsoft.SqlServer.Management.RegisteredServers.RegisteredServer --> <View> <Name>Microsoft.SqlServer.Management.RegisteredServers.RegisteredServer</Name> <ViewSelectedBy> <TypeName>Microsoft.SqlServer.Management.RegisteredServers.RegisteredServer</TypeName> </ViewSelectedBy> <TableControl> <AutoSize/> <TableHeaders> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>Name</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>ServerName</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Group</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Description</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Source</PropertyName> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <!-- Sqlcollaborative.Dbatools.Validation.LinkedServerResult --> <View> <Name>Sqlcollaborative.Dbatools.Validation.LinkedServerResult</Name> <ViewSelectedBy> <TypeName>Sqlcollaborative.Dbatools.Validation.LinkedServerResult</TypeName> </ViewSelectedBy> <TableControl> <AutoSize/> <TableHeaders> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>SqlInstance</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>LinkedServerName</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>RemoteServer</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Connectivity</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Result</PropertyName> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <!-- dbatools.MigrationObject --> <View> <Name>dbatools.MigrationObject</Name> <ViewSelectedBy> <TypeName>dbatools.MigrationObject</TypeName> </ViewSelectedBy> <TableControl> <AutoSize/> <TableHeaders> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> <TableColumnHeader/> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>Type</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Name</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Status</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Notes</PropertyName> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> </ViewDefinitions> </Configuration> |