Exportando Report Excel Usando PowerShell

Daeee galera!

Primeiro video de uma nova série para o canal!!! Neste vídeo explico como você pode usar o PowerShell para realizar export de informações para gerar reports.

Aqui estão todos os comando caso queiram reproduzir o conteúdo para praticar.

-------------------

Set-ExecutionPolicy -ExecutionPolicy RemoteSigned -Scope CurrentUser

Install-Module ImportExcel -AllowClobber -Force

Install-Module -Name Az -Scope CurrentUser -Repository PSGallery -Force


az graph query -q "ResourceContainers | where type=='microsoft.resources/subscriptions/resourcegroups' | project id, resourceGroup, name, type | union (Resources | project id, resourceGroup, name, type)" --subscriptions $subscription --first 10 -o json

az graph query -q "ResourceContainers | where type=='microsoft.resources/subscriptions/resourcegroups' | project id, resourceGroup, name, type | union (Resources | project id, resourceGroup, name, type)" --subscriptions $subscription --first 1000 --query "data" -o json | ConvertFrom-Json

$path = "C:\Temp\output.xlsx"
$subscription = ""

$resources = az graph query -q "ResourceContainers | where type=='microsoft.resources/subscriptions/resourcegroups' | project id, resourceGroup, name, type | union (Resources | project id, resourceGroup, name, type)" --subscriptions $subscription --first 1000 --query "data" -o json | ConvertFrom-Json

$resources | Export-Excel -workSheetName "Resources" -path $path

-------------------

Segue um link de referência com mais consultas da Azure:
https://www.blueboxes.co.uk/working-with-tags-in-azure-resource-graph-explorer