Getting TSV file output excluding 2 resource types from the az resource list in Azure CLI.

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3146884%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EGetting%20TSV%20file%20output%20excluding%202%20resource%20types%20from%20the%20az%20resource%20list%20in%20Azure%20CLI.%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3146884%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EKindly%20concern%20that%20I%20need%20to%20get%20the%20azure%20resource%20list%20from%20the%20azure%20CLI%20excluding%202%20kinds%20of%20resource%20types%20and%20output%20the%20file%20to%20a%20TSV%20file.%20I%20was%20able%20do%20this%20particular%20operation%20via%20PowerShell%20from%20the%20following%20command.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EPowerShell%20Command%20-%20get-azresource%20%7C%20where%20ResourceType%20-notmatch%20microsoft.network%2Fprivatednszones%2Fvirtualnetworklinks%20%7C%20where%20ResourceType%20-notmatch%20microsoft.insights%2Factiongroups%20%7C%20export-csv%20C%3A%5C%5CUsers%5C%5C7.csv%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20need%20to%20get%20this%20result%20from%20Azure%20CLI%20excluding%20the%20mentioned%20resource%20types%20to%20TSV%20file%20(Since%20we%20cannot%20get%20the%20Azure%20CLI%20output%20in%20CSV)%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EPLEASE%20HELP%20AT%20YOUR%20EARLIEST%20CONVENIANCE%2C%20I%20WILL%20HIGHLY%20APPRECIATE%20IF%20YOU%20CAN.%26nbsp%3B%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThanks%20%26amp%3B%20Regards%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EAnon.%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

Kindly concern that I need to get the azure resource list from the azure CLI excluding 2 kinds of resource types and output the file to a TSV file. I was able do this particular operation via PowerShell from the following command.

 

PowerShell Command - get-azresource | where ResourceType -notmatch microsoft.network/privatednszones/virtualnetworklinks | where ResourceType -notmatch microsoft.insights/actiongroups | export-csv C:\Users\7.csv

I need to get this result from Azure CLI excluding the mentioned resource types to TSV file (Since we cannot get the Azure CLI output in CSV)

 

PLEASE HELP AT YOUR EARLIEST CONVENIANCE, I WILL HIGHLY APPRECIATE IF YOU CAN.  

 

Thanks & Regards,

Anon.

0 Replies