Revert variable set change

lars.lagreid.jensen · 21 October 2021 08:53

Dear Team,
We’re using a large variable set with some sensitive variable templates. An unfortunate soul managed to change a sensitive variable template controlType into Single-line text, which again seems to have zeroed out all our Tenant values.

I’m guessing the answer is no, but is there an intelligent way to revert this change and get the values back? It will be a major pain in the ass to do it manually.

mark.harrison · 21 October 2021 09:59

Hi @lars.lagreid.jensen,

Unfortunately, I don’t have good news for you.

You’re right in your assumption that there’s no simple way to revert the change. The reason for this is that sensitive variables are encrypted one-way, meaning there’s no way to retrieve the old value from something like the REST API, or from the database.

This might be scant consolation, but if you know what the sensitive values were, then you could automate the re-entering of the details using the REST API. I assume the variable templates were “Common Variables” as opposed to Project Variable templates. We have a different example in our GitHub repo for updating project variables here:

github.com

OctopusDeploy/OctopusDeploy-Api/blob/master/REST/PowerShell/Tenants/UpdateMultipleTenantVariablesWithSingleValue.ps1

$ErrorActionPreference = "Stop";

# Define working variables
$octopusURL = "https://youroctourl"
$octopusAPIKey = "API-YOURAPIKEY"
$header = @{ "X-Octopus-ApiKey" = $octopusAPIKey }

$spaceName = "Default" # Name of the Space
$tenantName = "TenantName" # The tenant name
$variableTemplateName = "ProjectTemplateName" # Choose the template Name
$newValue = "NewValue" # Choose a new variable value, assumes same per environment
$NewValueIsBoundToOctopusVariable=$False # Choose $True if the $newValue is an Octopus variable e.g. #{SomeValue}

# Get space
$space = (Invoke-RestMethod -Method Get -Uri "$octopusURL/api/spaces/all" -Headers $header) | Where-Object {$_.Name -eq $spaceName}

# Get Tenant
$tenantsSearch = (Invoke-RestMethod -Method Get -Uri "$octopusURL/api/$($space.Id)/tenants?name=$tenantName" -Headers $header)
$tenant = $tenantsSearch.Items | Select-Object -First 1

This file has been truncated. show original

This would need some modification if they were common variables as the object returned in the $variables object contains two collections; ProjectVariables and LibraryVariables.

I’m sorry I don’t have better news for you. If you have any questions, just let me know.

Best regards,
Mark