System.Object[] - Export to CSV or HTML
Question
-
Hi Team,
am trying to get the service information from office 365 through the below script. However , am unable to get the exact value in the column "Messages"
$cred = get-credential
#$a = "<style>BODY{background-color:peachpuff;}</style>"
$a = "<style>"
$a = $a + "BODY{background-color:peachpuff;}"
$a = $a + "TABLE{border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;}"
$a = $a + "TH{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:thistle}"
$a = $a + "TD{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:PaleGoldenrod}"
$a = $a + "</style>"
$jsonPayload = (@{userName=$cred.username;password=$cred.GetNetworkCredential().password;} | convertto-json).tostring()
$cookie = (invoke-restmethod -contenttype "application/json" -method Post -uri "https://api.admin.microsoftonline.com/shdtenantcommunications.svc/Register" -body $jsonPayload).RegistrationCookie
$jsonPayload = (@{lastCookie=$cookie;locale="en-US";preferredEventTypes=@(0,1)} | convertto-json).tostring()
$events = (invoke-restmethod -contenttype "application/json" -method Post -uri "https://api.admin.microsoftonline.com/shdtenantcommunications.svc/GetEvents" -body $jsonPayload)
$events | get-member
$events.Events
$events.Events | Select-object StartTime, Title, EndTime, LastUpdatedTime, Id, Status, Messages | Export-Csv "D:\ramki\servicestat1.Csv" | Out-StringPlease see the screen shot.
Out put in the text file is coming in the below format. but i need to export in CSV / HTM
Answers
-
Hi rush2ramki,
To resolve the “system.object[]” issue, there is a PowerShell script demo below you could refer to.
$cred = get-credential #$a = "<style>BODY{background-color:peachpuff;}</style>" $a = "<style>" $a = $a + "BODY{background-color:peachpuff;}" $a = $a + "TABLE{border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;}" $a = $a + "TH{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:thistle}" $a = $a + "TD{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:PaleGoldenrod}" $a = $a + "</style>" $jsonPayload = (@{userName=$cred.username;password=$cred.GetNetworkCredential().password;} | convertto-json).tostring() $cookie = (invoke-restmethod -contenttype "application/json" -method Post -uri "https://api.admin.microsoftonline.com/shdtenantcommunications.svc/Register" -body $jsonPayload).RegistrationCookie $jsonPayload = (@{lastCookie=$cookie;locale="en-US";preferredEventTypes=@(0,1)} | convertto-json).tostring() $events = (invoke-restmethod -contenttype "application/json" -method Post -uri "https://api.admin.microsoftonline.com/shdtenantcommunications.svc/GetEvents" -body $jsonPayload) $events | get-member $events.Events Function GetMessage() { $text=""; foreach($message in $($_).Messages) { $text=$message.MessageText; } return $text; } $events.Events | Select-object StartTime, Title, EndTime, LastUpdatedTime, Id, Status, @{Name="Messages";Expression={GetMessage}} | ConvertTo-html -head $a -As TABLE |Out-File "C:\test\ser9.html"
The result as below:
Best regards,
Sara Fan
Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com- Edited by Sara Fan Tuesday, November 28, 2017 1:23 AM
- Proposed as answer by Wendy DZMicrosoft contingent staff Tuesday, November 28, 2017 9:30 AM
- Marked as answer by rush2ramki Wednesday, December 6, 2017 10:41 AM
- Unmarked as answer by rush2ramki Wednesday, January 3, 2018 12:24 PM
- Marked as answer by rush2ramki Saturday, January 6, 2018 2:27 PM
All replies
-
Hello Sara
Thanks for your help.
Two things i observed, when i put the command like for CSV below
$events.Events | Format-Table StartTime, Title, EndTime, LastUpdatedTime, Id, Status, Messages -wrap| out-file "D:\ramki\servicestat2.Csv"
The System.Object[] is not appeared , and got the value exactly, only if i open in the TXT file / Notepad . if i open the same CSV file in Excell , the format got collapsed like below
When i try to get in HTLM file with below commad
$events.Events | Format-Table StartTime, Title, EndTime, LastUpdatedTime, Id, Status, Messages -Wrap| Out-File D:\ramki\Test.htm
System.Object[] is appeared in the Messages column. Please see the below. i would the result in HTM format instead of CSV, which is more convenient to go through the results in email as well
Thanks in Advance and am also trying with other commands . Please see the below exact results in TXT file (Opened the CSV in Notepad). See the messages column, it has lot of results like user impact, More info , {@{MessageText Title =....etc) i suspect, the multiple values in messages creating the issues.
In the message column, i would like to get the first line value {@{MessageText = Title:
nothing more than that.
i would like to get the below result in HTML format.
- Edited by rush2ramki Tuesday, November 7, 2017 5:54 AM Added
-
Hi rush2ramki,
To resolve the “system.object[]” issue, there is a PowerShell script demo below you could refer to.
$cred = get-credential #$a = "<style>BODY{background-color:peachpuff;}</style>" $a = "<style>" $a = $a + "BODY{background-color:peachpuff;}" $a = $a + "TABLE{border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;}" $a = $a + "TH{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:thistle}" $a = $a + "TD{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:PaleGoldenrod}" $a = $a + "</style>" $jsonPayload = (@{userName=$cred.username;password=$cred.GetNetworkCredential().password;} | convertto-json).tostring() $cookie = (invoke-restmethod -contenttype "application/json" -method Post -uri "https://api.admin.microsoftonline.com/shdtenantcommunications.svc/Register" -body $jsonPayload).RegistrationCookie $jsonPayload = (@{lastCookie=$cookie;locale="en-US";preferredEventTypes=@(0,1)} | convertto-json).tostring() $events = (invoke-restmethod -contenttype "application/json" -method Post -uri "https://api.admin.microsoftonline.com/shdtenantcommunications.svc/GetEvents" -body $jsonPayload) $events | get-member $events.Events Function GetMessage() { $text=""; foreach($message in $($_).Messages) { $text=$message.MessageText; } return $text; } $events.Events | Select-object StartTime, Title, EndTime, LastUpdatedTime, Id, Status, @{Name="Messages";Expression={GetMessage}} | ConvertTo-html -head $a -As TABLE |Out-File "C:\test\ser9.html"
The result as below:
Best regards,
Sara Fan
Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com- Edited by Sara Fan Tuesday, November 28, 2017 1:23 AM
- Proposed as answer by Wendy DZMicrosoft contingent staff Tuesday, November 28, 2017 9:30 AM
- Marked as answer by rush2ramki Wednesday, December 6, 2017 10:41 AM
- Unmarked as answer by rush2ramki Wednesday, January 3, 2018 12:24 PM
- Marked as answer by rush2ramki Saturday, January 6, 2018 2:27 PM
