PSAzureSQLElasticJob.Format.ps1xml
|
<?xml version="1.0" encoding="utf-8" ?> <Configuration> <ViewDefinitions> <View> <Name>PSAzureSQLElasticJob.EnvironmentResult</Name> <ViewSelectedBy> <TypeName>PSAzureSQLElasticJob.EnvironmentResult</TypeName> </ViewSelectedBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>ResourceGroupName</Label> <Width>20</Width> </TableColumnHeader> <TableColumnHeader> <Label>ServerName</Label> <Width>20</Width> </TableColumnHeader> <TableColumnHeader> <Label>AgentName</Label> <Width>15</Width> </TableColumnHeader> <TableColumnHeader> <Label>CreatedServer</Label> <Width>13</Width> </TableColumnHeader> <TableColumnHeader> <Label>CreatedDatabase</Label> <Width>15</Width> </TableColumnHeader> <TableColumnHeader> <Label>CreatedAgent</Label> <Width>12</Width> </TableColumnHeader> <TableColumnHeader> <Label>AssignedIdentity</Label> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>ResourceGroupName</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>ServerName</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>AgentName</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>CreatedServer</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>CreatedDatabase</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>CreatedAgent</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>AssignedIdentity</PropertyName> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>PSAzureSQLElasticJob.EnvironmentStatus</Name> <ViewSelectedBy> <TypeName>PSAzureSQLElasticJob.EnvironmentStatus</TypeName> </ViewSelectedBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>ResourceGroupName</Label> <Width>20</Width> </TableColumnHeader> <TableColumnHeader> <Label>ServerName</Label> <Width>20</Width> </TableColumnHeader> <TableColumnHeader> <Label>AgentName</Label> <Width>15</Width> </TableColumnHeader> <TableColumnHeader> <Label>ServerExists</Label> <Width>12</Width> </TableColumnHeader> <TableColumnHeader> <Label>DatabaseExists</Label> <Width>14</Width> </TableColumnHeader> <TableColumnHeader> <Label>AgentExists</Label> <Width>11</Width> </TableColumnHeader> <TableColumnHeader> <Label>IsComplete</Label> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>ResourceGroupName</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>ServerName</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>AgentName</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>ServerExists</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>DatabaseExists</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>AgentExists</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>IsComplete</PropertyName> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>PSAzureSQLElasticJob.TargetDatabaseAccessResult</Name> <ViewSelectedBy> <TypeName>PSAzureSQLElasticJob.TargetDatabaseAccessResult</TypeName> </ViewSelectedBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>TargetServerName</Label> <Width>20</Width> </TableColumnHeader> <TableColumnHeader> <Label>TargetDatabaseName</Label> <Width>20</Width> </TableColumnHeader> <TableColumnHeader> <Label>IdentityName</Label> <Width>18</Width> </TableColumnHeader> <TableColumnHeader> <Label>RoleName</Label> <Width>12</Width> </TableColumnHeader> <TableColumnHeader> <Label>UserCreated</Label> <Width>12</Width> </TableColumnHeader> <TableColumnHeader> <Label>RoleMembershipGranted</Label> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>TargetServerName</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>TargetDatabaseName</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>IdentityName</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>RoleName</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>UserCreated</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>RoleMembershipGranted</PropertyName> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>PSAzureSQLElasticJob.ElasticJobStep</Name> <ViewSelectedBy> <TypeName>Microsoft.Azure.Commands.Sql.ElasticJobs.Model.AzureSqlElasticJobStepModel</TypeName> </ViewSelectedBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>JobName</Label> <Width>15</Width> </TableColumnHeader> <TableColumnHeader> <Label>StepName</Label> <Width>29</Width> </TableColumnHeader> <TableColumnHeader> <Label>StepId</Label> <Width>6</Width> </TableColumnHeader> <TableColumnHeader> <Label>TargetGroupName</Label> <Width>15</Width> </TableColumnHeader> <TableColumnHeader> <Label>CredentialName</Label> <Width>14</Width> </TableColumnHeader> <TableColumnHeader> <Label>Output</Label> <Width>26</Width> </TableColumnHeader> <TableColumnHeader> <Label>CommandText</Label> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>JobName</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>StepName</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>StepId</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>TargetGroupName</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>CredentialName</PropertyName> </TableColumnItem> <TableColumnItem> <ScriptBlock> if ($_.Output) { '{0}.{1}' -f $_.Output.SchemaName, $_.Output.TableName } </ScriptBlock> </TableColumnItem> <TableColumnItem> <ScriptBlock> if ($_.CommandText.Length -gt 60) { $_.CommandText.Substring(0, 57) + '...' } else { $_.CommandText } </ScriptBlock> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> </ViewDefinitions> </Configuration> |