how to get back quarantined licenses

[raghavsurya]

hi All,

One of our customer has deleted the users without de-allocating the user access tokens allocated. 

Similarly have deleted Login Access Rules without deallocating the tokens assigned. 

Now they are showing as quarantined for more than 10 days.  How to get such quarantined licenses back.

Thanks and Regards,

Raghav

[#2]

Is this related: Qlik Sense Server - Token not coming out of Quarantine ?  The question isn't the same, but the answer appears to address:

1. Deleting a user

2. Token not Freed After Quarantine Period

[aadil_madarveet]

Though this is an old ticket. Only a few are coming up when searching for these terms.

Posting this for future reference for people.

If you need to retrieve the licenses and cant wait for the 7 day period to get over. You can follow the below steps to recover the tokens (User allocated tokens).

WARNING: DO NOT EXECUTE THIS IN PRODUCTION INSTANCES. ALWAYS TAKE PRIOR FULL BACKUP. QUERIES LISTED BELOW COULD DESTABILIZE THE INSTANCE AND YOU MIGHT EXPERIENCE OTHER ISSUES. THIS QUERY HAS BEEN ONLY TRIED IN TEST ENVIRONMENTS.

1. Download and install PgAdmin on the central node or any node.

2. Connect to the QSR DB using pgAdmin.

3. Execute the below query to see if you can view the same content as you see in QMC.

SELECT "ID", "LastUsed", "Quarantined", "CreatedDate", "ModifiedDate", "ModifiedByUserName", "User_ID", "DeletedUserId", "DeletedUserDirectory" FROM public."LicenseUserAccessTypes";

4. Now execute the below query to delete the records. This query will only remove user access allocations.

DELETE FROM public."LicenseUserAccessTypes"
WHERE "Quarantined" = true;

5.Done. Go back to QMC and navigate to the user allocations sections and validate if you can see the updated results.