Powershell Format-Table

Question

I am setting up a few custom commands for office 365 incident responses so even our helpdesk users can help respond. One thing I wanted to do was have a powershell command to do a message trace to see if someone's account is compromised and sending out phishing emails.

$dateend = get-date
$datestart = $dateend.addhours(-48)

$logmessage = Get-MessageTrace -SenderAddress '%userPrincipalName%' -StartDate $datestart -EndDate $dateend -PageSize 5000 | Sort-Object -Property Received | ft Received, SenderAddress, RecipientAddress, Subject, Status, ToIP, FromIP, Size, MessageID, MessageTraceID | Out-String -Stream
$Context.LogMessage($logmessage.count, "Information")
foreach ($logline in $logmessage) { if ($logline -ne '') { $Context.LogMessage($logline, "Information") } }

When I run this in Adaxes, it only shows me the columns Received, SenderAddress, RecipientAddress, and Subject. If I run the exact same command in normal powershell the ft/Format-Table command shows me all of the columns that I specified.

Is Adaxes a partial implementation of ft or is there another way to do this?

Answer 1

Hello,

Most probably the issue occurs because you specified the table width so that not all the text is displayed in the execution log. We recommend you to output the results into a CSV file using the Export-Csv cmdlet.
If you need help updating the script, post here or send us (support[at]adaxes.com) the following details:

1. The full version of the script you are using.

2. The version of Adaxes you are currently using. To check that:

   • Launch Adaxes Administration Console.
   • Right-click your service.
   • Click Properties in the context menu.
     
   • Adaxes version is displayed on the General tab.
     

Comments

The width was the issue. The results window from Adaxes is much smaller than when I work in the regular powershell ISE 1920x1200. I read more on Format-Table and there is a '-width' option. I specified that and it returned all of my columns.