remove cal licence automatically for old users

[fabricecallegar]

Hello,

Can someone help me to write a script to remove Cal for all users who have not been logged in for more than 90 days ?

I'm using PowerShell

I could connect to the server with the help of support (https://support.qlik.com/articles/000061350) but I don't API/POwerShell and I'm stuck to retrieve users not logged for more than 90 and then remove the licence...

Fabrice

[Marc]

In order to use the QlikView APIs the user account you are running the PowerShell as needs to be a member of the "QlikView Management API" group.

Then you can start using PowerShell to interact with the APIs

[fabricecallegar]

Hello Marc,

Thank you for your answer,

I cann connect to the server, I don't have problem with that.

I just don't know how to retrieve the list of users who haven't logged in since 90 to delete them.

regards

Fabrice

[Brett_Bleess · Accepted solution]

This would be a violation of your license terms, just FYI, so not something I would recommend you do.  Here is a link to the documentation stating when users may be removed from User and Document CAL types:

https://www.qlik.com/us/-/media/files/legal/license-agreements/qlikview/qlikview-license-metrics-en....

Here is the pertinent text from the document:

Named and Document CALs are assigned to an identified user and may not be transferred to another user unless the transfer is due to a i) termination of employment, or ii) a transfer of the user to a new business unit or group resulting in no access to the Qlik Software. When a Named User or Document CAL is transferred, there is a 7-day quarantine before the CAL can be used by another user.

Regards,
Brett

[fabricecallegar]

Hello Brett,

Do you mean that remonving cals with API is a licence violation ?

If yes :

• why the solution is given by the support (https://support.qlik.com/articles/000061350?_ga=2.11744948.1279959997.1600958189-1107908492.15897143...) ?
• how to automatically recycle CALs for users who have not logged in for more than 90 days ?

Regards

Fab