topic Need PowerShell Help With Contents in Brackets {} in Active IQ Unified Manager Discussions

Need PowerShell Help With Contents in Brackets {}

TMADOCTHOMAS — Wed, 04 Jun 2025 13:13:26 GMT

Hello,

I've created Powershell scripts to export CIFS shares, iSCSI LUN mappings, and network information to CSV files. Those files are copied to a DR server so we will have configuration information available in a disaster.

This works well, however there are a few fields that don't transfer data to the spreadsheet. Specifically, fields that enclose data in brackets {}.

Here's an example: the command for exporting the list of subnets to a spreadsheet.

Get-NcNetSubnet -Controller $CLUSTER | select SubnetName,Subnet,Gateway,IPRanges | Export-Csv subnets.csv

When I run the command without the Export-Csv, the "IPRanges" field shows up like this in PowerShell:

{0.0.0.0-1.1.1.1}

With Export-Csv, it exports the results for this field like this:

System.String[]

I get similar results when I list network interfaces. The "DataProtocols" field encloses the results in {} which shows up wrong on the spreadsheet.

Has anyone run across this behavior? Is there a solution? Thanks in advance!

Re: Need PowerShell Help With Contents in Brackets {}

GidonMarcus — Wed, 17 Oct 2018 00:21:38 GMT

didn't look exactly on your case - i guess it's

http://blog.millersystems.com/powershell-exporting-multi-valued-attributes-via-export-csv-cmdlet/

Just to share that the way i do this type of export-import is with

ConvertTo-Json

Export-CliXML

And then on the other site

ConverFrom-Json

Import-CliXML

That gives very consistent data structure. and will also work with simple pipe sometimes.($Quota | Set-ncQuota)

i prefer the CLIXML options. but they should both work just the same.

Gidi

Re: Need PowerShell Help With Contents in Brackets {}

TMADOCTHOMAS — Thu, 18 Oct 2018 15:46:59 GMT

Thank you @GidonMarcus! The link gave me just what I needed.