Azure KeyVault: Retrieve secrets and their values using PowerShell and save in Excel file

 

Azure KeyVault: Retrieve secrets and their values 

using PowerShell and saving in Excel file

$vault_name="keyvault-name"

$excel = New-Object -ComObject excel.application

$workbook = $excel.Workbooks.Add()

$uregwksht= $workbook.Worksheets.Item(1)

$uregwksht.Name = $vault_name

$row = 1

$Column = 1

$uregwksht.Cells.Item($row,$column)= "Secret-Name"

$uregwksht.Cells.Item($row,$column+1)= "Secret-Value"

# Get all secret names

$secret_names=$(az keyvault secret list --vault-name $vault_name --query [].name -o tsv)

# Loop through each secret name and get its value

foreach ($secret in $secret_names)

{ 

  $secret_value=$(az keyvault secret show --vault-name $vault_name --name $secret --query "value")

   

  Write-Output $row

  

  $row = $row + 1 

  $uregwksht.Cells.Item($row,1)= $secret

  $uregwksht.Cells.Item($row,2)= $secret_value

  

  #if ($row -eq 2) { break }

    

  # Write-Output $secret

  # Write-Output $secret_value 

  # Write-Output "-------------------------"

}

$outputpath = "D:\"+ $vault_name + ".xlsx"

Write-Output $("File saved on " + $outputpath )

$excel.displayalerts = $false

$workbook.Saveas($outputpath)

$excel.displayalerts = $true

$excel.Quit()