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

Question

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

Praveen Mittapalli 36

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

0 comments

Answer accepted by question author

Abhishek Singh 381

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

Viktor Dronov 146 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
Viktor Dronov 146 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
Viktor Dronov 146 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
Viktor Dronov 146 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.
Viktor Dronov 146 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
Viktor Dronov 146 Reputation points

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

1 SinghAbhishekbr-3469
2 AbhishekSingh-7599
3 PraveenMittapalli-6705

2 additional answers

Your answer

Viktor Dronov 146 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
Viktor Dronov 146 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
Viktor Dronov 146 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
Viktor Dronov 146 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.
Viktor Dronov 146 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
Viktor Dronov 146 Reputation points

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

1 SinghAbhishekbr-3469
2 AbhishekSingh-7599
3 PraveenMittapalli-6705

Answer 1

Anonymous

Hi，

A string actually is an object of string class. What do you want $finaloutput to be like?

Best Regards，
Ian

Abhishek Singh 1 Reputation point

2020-11-03T06:25:49.167+00:00

the expected output is a list of azure vm disks objects but i am getting it in a string format hence not a viable format to output it in a csv ot html file
Viktor Dronov 146 Reputation points

2020-11-03T10:13:59.63+00:00

for getting azure vm disk information you have other prefferable ways like this
Abhishek Singh 1 Reputation point

2020-11-03T10:50:56.647+00:00

Hi thanks for your response i already knew this azure level disk report, but in my case i need OS level raw disks hence i am using invoke cmdlet
Viktor Dronov 146 Reputation points

2020-11-03T11:12:12.913+00:00

In that case u could prepare output inside the script in a json format (convertto-json) and just convertfrom-json output at the end
Abhishek Singh 1 Reputation point

2020-11-03T11:14:15.883+00:00

yes i am trying same thing now

Answer 2

Rich Matheisen 48,116

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.

0 comments

Share via

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

2 additional answers

Your answer