Parsing an array of ojects into strings in PowerShell

Question

I am calling Get-AdComputer like this:

[string[]] $computer = Get-ADComputer -properties * -filter {(operatingsystem -like "*Windows 7*")} |
    Where-Object {$_.name -like "*-*"} |
    Where-Object {$_.name -NotLike "V7-*"} |
    Where-Object {$_.name -NotLike "*-NONE"} |
    Where-Object {$_.name -NotLike "*-ONCALL"} |
    Where-Object {$_.name -NotLike "*-BLACKBAUD"} |
    Where-Object {$_.name -NotLike "SC-WIN7-1"} |
    Where-Object {$_.name -NotLike "UT-SWCLIENT-01"} |
    Select-Object Name, LastLogonDate

This creates a string array and I can access it like this:

$computer[1]

which returns

@{Name=W7-9HQPR3J; LastLogonDate=05/08/2017 09:45:13}

I need to output the data to a csv file in two columns Name, LastLogonDate

Unfortunately when I call $Computer | out-file -filepath $ServiceTagsPath -Force -Width 200 -Encoding ascii

I get one column with the headings on each line:

My other requirement is to be able to use the Name column in web-service calls to get warranty information...

so how could I do that?

Sign up for the Dell TechDirect API, there's one for Warranty, using these will be much easier than scraping the values from an HTML page. You can request the info you want in a format that powershell can deal with natively: techdirect.dell.com/portal.30/AboutAPIs.aspx — henrycarteruk
– henrycarteruk, Commented Apr 17, 2018 at 13:55

pandemic · Accepted Answer · 2018-04-17 13:45:26Z

4

I would not cast the output to array of strings [string[]] but leave the casting to powershell. Then you can use command Export-Csv which works better with array of objects.

$computer = Get-ADComputer -properties * -filter {(operatingsystem -like "*Windows 7*")} |
    Where-Object {$_.name -like "*-*"} |
    Where-Object {$_.name -NotLike "V7-*"} |
    Where-Object {$_.name -NotLike "*-NONE"} |
    Where-Object {$_.name -NotLike "*-ONCALL"} |
    Where-Object {$_.name -NotLike "*-BLACKBAUD"} |
    Where-Object {$_.name -NotLike "SC-WIN7-1"} |
    Where-Object {$_.name -NotLike "UT-SWCLIENT-01"} |
    Select-Object Name, LastLogonDate

 $computer | Export-Csv "test.csv" -NoTypeInformation

answered Apr 17, 2018 at 13:45

pandemic

1,1952 gold badges23 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Our Man in Bananas Over a year ago

this outputs a csv with #TYPE System.String as the heading and all records are just the number 53

pandemic Over a year ago

I think you have copied the code from @Shawn Esterman or try to flush the variable by Remove-Variable or simply close and open shell window again

henrycarteruk Over a year ago

@OurManinBananas note that [string[]] has been removed in this answer.

Our Man in Bananas Over a year ago

@pandemic: no, I took that out... and set the $computer variable to $null

Collectives™ on Stack Overflow

Parsing an array of ojects into strings in PowerShell

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related