SmoLogFile.ps1xml
|
<?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> |