topic remove cal licence automatically for old users in QlikView

remove cal licence automatically for old users

fabricecallegari — Sat, 16 Nov 2024 18:06:41 GMT

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

Re: remove cal licence automatically for old users

Marc — Thu, 17 Sep 2020 01:19:26 GMT

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

Re: remove cal licence automatically for old users

fabricecallegari — Thu, 17 Sep 2020 07:24:56 GMT

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

Re: remove cal licence automatically for old users

Brett_Bleess — Thu, 24 Sep 2020 19:33:47 GMT

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.pdf

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

Re: remove cal licence automatically for old users

fabricecallegari — Fri, 25 Sep 2020 08:46:50 GMT

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.1589714393) ?
how to automatically recycle CALs for users who have not logged in for more than 90 days ?

Regards

Fab