Cleanup of Duplicate Environment Variables

[babaiah]

We need to clean up duplicate environment variables, as a large number of them have been created over time.

We are trying to identify the process name, along with the corresponding page and stage names, where each environment variable is being used.

Any information or guidance would be greatly appreciated.

[Neel1 · Accepted solution]

hello @babaiah - Not going towards obvious stuff that no two EV can have same name. here is what i thought can be done.

Create a re-usable component [for future use] or one time but i think Process name, stage name need to check manually after that.

1. GET API call on 

https://APIURL/api/v7/environmentvariables

in the output - you will get ID, name  and other details

"id": "24718b06-ff9a-4c1b-9431-4d91e1a704ab"

2. Run another GET API call on 

https://APIURL /api/v7/environmentvariables/24718b06-ff9a-4c1b-9431-4d91e1a704ab/references

In output you will get  below details

"id": "d9903e9b-725e-4881-8625-51a338aeefe3", "name": "BluePrism_Process", "type": "Process",

You can put all these information in a Excel and once reviewed Run Delete API (if required) call on EV ID which got in step 1.

[babaiah · Accepted solution]

Thank you Neel,

My requirement is to remove environment variables that have duplicate values. We also need the results to show which process is using them, along with the corresponding page and stage names.

We found a solution by using a PowerShell script with the process XML to get the expected results.

Thanks

[Neel1]

Okies. Good.

so you run PowerShell script across all Process' XML?

[babaiah]

Yes, because I want to know the exact location (Process/Object, Page/Action, and Stage names) where the environment variable is being used.

Thanks.