Expanding an array before Export-csv.

Question

Hi All.&nbsp;I have spent a day scouring the internet for a solution, but can't seem to get this right. I am looking to turn this:&nbsp;NodeName&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IOSRelease&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CVEs--------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ----------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ----xxx-cen-dcn-5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12.2(35)SE5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {CVE-2019-16009, CVE-2019-12665, CVE-2017-3881}xxx-nth-dcn-4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12.2(35)SE5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {CVE-2019-16009, CVE-2019-12665, CVE-2017-3881}&nbsp;Into this:&nbsp;NodeName&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IOSRelease&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CVEs--------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ----------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ----xxx-cen-dcn-5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12.2(35)SE5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {CVE-2019-16009}xxx-cen-dcn-5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12.2(35)SE5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {CVE-2019-12665xxx-cen-dcn-5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12.2(35)SE5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {CVE-2017-3881}xxx-nth-dcn-4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12.2(35)SE5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {CVE-2019-16009,xxx-nth-dcn-4 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12.2(35)SE5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {CVE-2019-12665}xxx-nth-dcn-4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12.2(35)SE5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {CVE-2017-3881}&nbsp;Any pointers would be greatly appreciated.&nbsp;Thanks&nbsp;Mal&nbsp;

farismalaeb · Answer

Hi,This is a nested array, and to do it your way, You need a foreach loop to go inside the CVEs and assign each item to the NodeName, so something like Foreach inside a foreach.

malhenderson · Answer

Hi 🙂Thank you for your response. I thought something like that, but couldn't get my head around it.I already have a foreach loop to create this output:$nodes = Import-Csv -Path $Path$output = foreach ($node in $nodes) {$apiurl = 'https://api.cisco.com/security/advisories/ios?version=' + $node.IOSVersion$advisory = Invoke-RestMethod $apiurl -Method 'GET' -Headers $headers -UseBasicParsingNew-Object -TypeName PSObject -Property @{NodeName = $node.DisplayNameIOSRelease = $node.IOSVersionCVEs = ($advisory.advisories.cves -Join ',')Score = ($advisory.advisories.cvssbaseScore -Join ',')url = ($advisory.advisories.cvrfUrl -Join ',')} | Select-Object NodeName,IOSRelease,CVEs,Score,url}$output | Export-Csv -Path 'C:\CVE\NSCiscoNodesupdatedlist.csv'So should I have another foreach loop, with append, where I write it to the csv?

farismalaeb · Answer

Yes,You will need to another foreach inside the first one, that will get the information for $node and then loop through its properties, assign them to the PSCustom item and then proceed to the next one.

Forum Discussion

Expanding an array before Export-csv.

3 Replies

Resources