Invoke-AzVMRunCommand returns a string output i want to have list of objects , is there anyway to get that . I am using below cmdlets to fetch the output : $out = Invoke-AzVMRunCommand -ResourceGroupName "Test" -VMName "PraveenTestVM7" -CommandId runpowershellscript -ScriptPath C:\Users\praveen.mittapalli\Desktop\RawDiskScript.ps1 -Verbose $finaloutput = $out.Value[0].Message The $finaloutput is a string but i need a list of object is there anyway to get that or convert it

Hi you can try this as mentioned below using cs convertor to get it in usable format : Remote script : Get-Disk | Where-Object PartitionStyle -EQ 'RAW' | ConvertTo-Csv Invoke script : $out = Invoke-AzVMRunCommand -ResourceGroupName "Test" -VMName "TestVM" -CommandId runpowershellscript -ScriptPath C:\Users\Desktop\RawDiskScript.ps1 -Verbose $s=$out.Value[0].Message $x=$s | ConvertFrom-Csv $x | Export-Csv -Path C:\Users\Desktop\testrawdisk.csv -NoTypeInformation

No, there isn't. The data are deserialized before being returned. The same is true for any cmdlet/script that's run on another machine.

Hi， A string actually is an object of string class. What do you want $finaloutput to be like? Best Regards， Ian

Invoke-AzVMRunCommand returns a string output i want to have list of objects , is there anyway to get that

Accepted answer

Abhishek Singh 381 Reputation points

2020-11-03T12:36:23.783+00:00

Hi you can try this as mentioned below using cs convertor to get it in usable format :

Remote script :

Get-Disk | Where-Object PartitionStyle -EQ 'RAW' | ConvertTo-Csv

Invoke script :

$out = Invoke-AzVMRunCommand -ResourceGroupName "Test" -VMName "TestVM" -CommandId runpowershellscript -ScriptPath C:\Users\Desktop\RawDiskScript.ps1 -Verbose
$s=$out.Value[0].Message
$x=$s | ConvertFrom-Csv

$x | Export-Csv -Path C:\Users\Desktop\testrawdisk.csv -NoTypeInformation
Please sign in to rate this answer.

3 people found this answer helpful.
Vector BCO 131 Reputation points

2020-11-03T12:54:59.427+00:00

why you need convert something From csv if on the next line you will export it back to the csv?

Abhishek Singh 381 Reputation points

2020-11-03T12:58:28.43+00:00

That's because without convertto-csv the output comes in string format which is a list of object in string format , by doing so i get it in a readable format and can convert it back to object in my invoke script

Vector BCO 131 Reputation points

2020-11-03T13:02:37.717+00:00

i'm not saing anything about converto-csv but about convertfrom-csv
you can just execute

$out.Value[0].Message | out-file C:\Users\Desktop\testrawdisk.csv and got exact the same output

Abhishek Singh 1 Reputation point

2020-11-03T13:06:36.923+00:00

if u do a get type for $out.Value[0].Message u will get it in string as anything coming from invoke cmd will come in string only, so i have done convertfrom-csv after that if u do get type u will get a list of objects or a single object so u can manipulate it in a much better way like keep the required properties or do some calculation upon it which will be much more difficult to do if u keep it in string format, you can try this scenario in your local environment for better understanding

Vector BCO 131 Reputation points

2020-11-03T13:16:35.193+00:00

SinghAbhishekbr-3469, you can try execute your code and my code and you will get 2 identical files at the end without 2 additional convertions -
this was main idea from my comment, nothing more.
simillar thing i proposed to PraveenMittapalli-6705 few hour before under IanXue-MSFT answer in the comments, so i know how convertto and convertfrom works

Vector BCO 131 Reputation points

2020-11-03T13:20:51.567+00:00

nevermind...

Abhishek Singh 381 Reputation points

2020-11-03T13:22:38.077+00:00

If u want the output as it is then u can do out-file, but if u need to customize a few properties or remove a few properties u need to get it in a object array thats exactly what i have done, for example the disk size will by default will come in bytes which might not be the desirable format for most people so have to convert to object array loop it and then perform the conversion.

Vector BCO 131 Reputation points

2020-11-03T13:25:32.983+00:00

yea, i know i did not get that you have 3 accounts for 1 question...

so if you need modify output and not just forward it to the file convertfrom have a sence

Abhishek Singh 381 Reputation points

2020-11-03T13:27:24.247+00:00

Lols i dont have 3 accounts just the one , never mind though

Vector BCO 131 Reputation points

2020-11-03T13:29:54.417+00:00

1 SinghAbhishekbr-3469
2 AbhishekSingh-7599
3 PraveenMittapalli-6705
Sign in to comment

Invoke-AzVMRunCommand returns a string output i want to have list of objects , is there anyway to get that

2 additional answers