On Demand Tile PowerShell Table format problem - Still an issue

[peterwsvensson (Peter Svensson)]

I raised this question in Aug 2017 (also opened a support-ticket)

On Demand Tile PowerShell Table format problem

It seems like the On Demand Tile (Grid) with output Powershell Table doesn’t format the output very well. Here is the command: Get-EventLog -LogName $Logname -EntryType $EntryType | select TimeGenerated, Source, Message -First $Top | Format-Table -AutoSize) Powershell [2017-08-25-12_51_29-Clipboard.png] Squared Up [2017-08-25-12_50_12-VGAS1048.vgregion.se-Squared-Up.png] There are two much whitespace between the different columns, leaving the message column truncated. Have tried t…

This is still an issue in 2021.

Powershell output

[Badger1 (Badger)]

Hey

Have you tried setting some character limit to the output? Like so:

Does that help at all?

[peterwsvensson (Peter Svensson)]

Tried that, same thing unfortunately

[peterwsvensson (Peter Svensson)]

So I tried to format my PS-output with a table and width expression.
$table = @{Expression={$.Path}; Label=“Path”; Width=60},
@{Expression={$.‘Size(Bytes)’}; Label=“Size(Bytes)”; Width=15},
@{Expression={$.‘Size(GB)’}; Label=“Size(GB)”; Width=10},
@{Expression={$.TimeAgoMinutes}; Label=“TimeAgoMinutes”; Width=10}

As you can see the task output is truncated. So I believe the output from the tasks output gets cut off due to a limit in SquaredUp?

The same in PS output

[pchip (Pascal Verdieu)]

I would recommend that your Powershell returns data in JSON format instead of Format-Table.

Get-EventLog -LogName $Logname -EntryType $EntryType | select TimeGenerated, Source, Message -First $Top | ConvertTo-JSON 

Format-Table removes object data and is not easily manipulable (by a computer) as it becomes essentially text. So yes you are exposing yourself to what you’re going through.

Cheers!

[peterwsvensson (Peter Svensson)]

Awesome, that works like a charm!

[pchip (Pascal Verdieu)]

Not a problem. If you want something even more “funky” add a parameter to your task for the return format. You can set a default value and have an override in the task configuration. Like this, if the same task is launched within the OM Console, it returns “Format Table” by default. When setting up your perspective in SquaredUp set the parameter to return in JSON format and use that. Basically you’ll have 2 scripts in 1

Chers!