Export the result to CSV Azure PowerShell Warnign Sign

Question

I am assuming this warning is causing problem.

WARNING: GeoReplicationEnabled property will be deprecated in a future release of Azure PowerShell. The value will be merged into the AccountType property

because when I did this command

Get-AzureWebsite | export-csv -Path "C:\Users\km\Desktop\AzureProject\Hello Pay-As-You-Go-Website.csv"

my CSV file is totally fine

SO the problem I am having is

When I execute this command

Get-AzureStorageAccount | Format-Table -Property StorageAccountName, Location, AccountType, StorageAccountStatus

The result is like this

StorageAccountName Location AccountType
StorageAccountStatus
--------------------- --------- ------------ -------------------- HelloSushi East US Standard_GRS Created

WARNING: GeoReplicationEnabled property will be deprecated in a future release of Azure PowerShell. The value will be merged into the AccountType property.

and I add this code to move this result to CSV like this

Get-AzureStorageAccount | Format-Table -Property StorageAccountName, Location, AccountType, StorageAccountStatus | export-csv -Path "C:\Users\km\Desktop\AzureProject\Susco Pay-As-You-Go-Storage.csv"

but I checked on CSV.file, it is totally does not make sense. it is not same one.

so ,

I would like to show the result exactly on CSV like when I did this code

Get-AzureStorageAccount | Format-Table -Property StorageAccountName, Location, AccountType, StorageAccountStatus

How can I do that?

Answer 1

Try Out-File instead of Export-CSV it is giving the exact same output as console

==

You can't do a Format-List to Export-Csv, this link explains it.