Powershell Script
Some customers have BAs, Developers or Support staff in their Production database with a different Endur/Findur License type - for example Read Only.
When refreshing an environment from Production, there can be a requirement to fix these Read Only license types to be back to the normal for that Endur/Findur implementation - for example, Full Access.
This script will fix the license types as required.
There are 2 variables in the section at the top of the script that need to be updated, to be specific for your Endur/Findur implementation:
#### UPDATE THESE VARIABLES FOR YOUR SPECIFIC ENDUR/FINDUR IMPLEMENTATION ####
####
#### 1. Run this SQL Statement against your Endur/Findur Database ####
#### select * from personnel_license_type ####
####
#### 2. Identify the License Type for the Licence Type you want to ####
#### update from (e.g. 'Read Only') ####
####
#### 3. Identify the License Type for the Licence Type you want to ####
#### update to (e.g. 'Full Access') ####
####
$fromLicenceType='Read Only'## Update with result from Step 2 above
$toLicenceType='Full Access'## Update with result from Step 3 above
#############################################################
The example above is to change 'Read Only' users to have a license type of 'Full Access'.
emdash Workflows
Once you have uploaded the step into the emdash database, we recommend you add this step to a clone of the following emdash Workflows:
- UserAllocation - AddEndurUser ToADEnvironment
- Environment Refresh - Endur
- Environment Refresh Make Like Source - Endur
Important Note: As above, if you have not already done so create a clone of the above workflows first before amending them to add your specific steps.
0 Comments