SmoLogFile.ps1xml
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 |
<?xml version="1.0" encoding="utf-8" ?>
<Configuration> <ViewDefinitions> <View> <Name>SmoLogFile TableView</Name> <ViewSelectedBy> <TypeName>Microsoft.SqlServer.Management.Smo.LogFile</TypeName> </ViewSelectedBy> <TableControl> <TableHeaders> <TableColumnHeader> <Label>Database</Label> <Alignment>Left</Alignment> </TableColumnHeader> <TableColumnHeader> <!-- ID --> <Alignment>Right</Alignment> </TableColumnHeader> <TableColumnHeader> <!-- Name --> <Alignment>Left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>GrowthInMB</Label> <Alignment>Center</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>SizeInMB</Label> <Alignment>Center</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>UsedSpaceInMB</Label> <Alignment>Center</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <ScriptBlock> $_.Parent.Name </ScriptBlock> </TableColumnItem> <TableColumnItem> <PropertyName>ID</PropertyName> </TableColumnItem> <TableColumnItem> <PropertyName>Name</PropertyName> </TableColumnItem> <TableColumnItem> <ScriptBlock> [Math]::Round(($_.Growth / 1KB), 2) </ScriptBlock> </TableColumnItem> <TableColumnItem> <ScriptBlock> [Math]::Round(($_.Size / 1KB), 2) </ScriptBlock> </TableColumnItem> <TableColumnItem> <ScriptBlock> [Math]::Round(($_.UsedSpace / 1KB), 2) </ScriptBlock> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> </ViewDefinitions> </Configuration> |