Forum Discussion
franka2022
Feb 03, 2022Copper Contributor
PS Custom Object - Format Output
Hello,
I have the following code:
$dbs = Get-AzSqlDatabase -ResourceGroupName $SQLResourceGroup -ServerName $ServerName
$results = foreach ($db in $dbs.DatabaseName)
{
$dbAudit = Get-AzSqlDatabaseAudit -ResourceGroupName $SQLResourceGroup -ServerName $ServerName -DatabaseName $db
[PSCustomObject]@{
Database = $dbAudit.DatabaseName
Storage = $dbAudit.BlobStorageTargetState
}
}
$results | Format-Table -Property @{Expression={$_.DatabaseName};Label="Display Name";width=35}, `
@{Expression={$_.BlobStorageTargetState};Label="Login Name";width=40}
The script originally worked before I added the FT function. Now the display is blank as shown below:
Display Name Login Name
------------ ----------
If I remove the FT function it will display in key/value pairs. I'd like for it to be displayed in columnar format.
Any ideas?
Thanks,
Frank
- You could try outputting your data as [string]::Format("{0} `t `t {1}", $variable1, variable2) . the `t is tabbing between the two?