Powershell help to output screen results to a CSV.

[kennysarmy]

When I run the command : Get-CsOnlineUser | Format-Table UserPrincipalName, TeamsMessagingPolicy

 

The results are in the window under two tabulated columns named : UserPrincipalName & TeamsMessagingPolicy

 

When I add to the command the " | Export-CSV c:\TeamsPoliciesMessaging2.csv"

 

All the CSV has in it is :

 

#TYPE Microsoft.PowerShell.Commands.Internal.Format.FormatStartData

ClassId2e4f51ef21dd47e99d3c952918aff9cd pageHeaderEntry pageFooterEntry autosizeInfo shapeInfo groupingEntry

033ecb2bc07a4d43b5ef94ed5a35d280 Microsoft.PowerShell.Commands.Internal.Format.TableHeaderInfo

9e210fe47d09416682b841769c78b8a3

27c87ef9bbda4f709f6b4002fa4af63c

etc

etc

 

 

What am I doing wrong?

[kennysarmy]

Get-CsOnlineUser | Select-Object UserPrincipalName, TeamsMessagingPolicy, TeamsMeetingBroadcastPolicy, TeamsMeetingPolicy, TeamsAppSetupPolicy, TeamsCallingPolicy | Export-CSV c:\TeamsPoliciesMessaging3.csv

 

Works.

[RobD]

Is this what you tried:

Get-CsOnlineUser | Select-Object UserPrincipalName, TeamsMessagingPolicy | Export-Csv c:\TeamsPoliciesMessaging2.csv -NoTypeInformation

 

Edit: nevermind you sorted it.