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()  

Azure KeyVault: Retrieve secrets and their values

 Azure KeyVault: Retrieve secrets and their values 

using PowerShell

$vault_name  = "keyvault-name"

# 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 $secret

  Write-Output $secret_value 

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

}

Create an Excel file using PowerShell script

Create an Excel file using PowerShell script 

Here is a code to write data into Excel file and save it in a particular path.

$excel = New-Object -ComObject excel.application

#$excel.visible = $True

$workbook = $excel.Workbooks.Add()

$SheetName = "MySheet"

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

$uregwksht.Name = $SheetName

$row = 1

$Column = 1

$uregwksht.Cells.Item($row,$column)= "Column Title"

for ($i = 2; $i -le 5; $i++)

{

    Write-Output $i

  $row = $row + 1

  $uregwksht.Cells.Item($row,$column)= "Abcd" + $i

}

$outputpath = "D:\test.xlsx"

$excel.displayalerts = $false

$workbook.Saveas($outputpath)

$excel.displayalerts = $true

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

$excel.Quit()

#ref - https://community.spiceworks.com/t/create-an-excel-file-from-within-powershell/1011485

#ref - https://chanmingman.wordpress.com/2022/10/02/powershell-write-to-excel-file/