You can easily identify the CAL assinged to user by using the below script
LET vLogFilesPath = 'C:\ProgramData\QlikTech\Qvs';
Capitalize(LOWER(SubField(Document,'\',-1))) as Dashboard,
Time(Timestamp) as SessionsTime,
if(len([QlikView User]) = 0 ,[Authenticated user], [QlikView User]) as UserID,
[Cal Usage Count],
Date(Floor(Timestamp)) AS Date,
Year(Date(Floor(Timestamp))) AS Year,
Month(Date(Floor(Timestamp))) AS Month,
Date(MonthStart(Timestamp), 'MMM YYYY') AS MonthYear,
'Q' & Ceil(Month(Date(Floor(Timestamp)))/3) AS Quarter,
[Session Duration] as SessionDuration,
Calls as SessionCalls,
(txt, utf8, embedded labels, delimiter is '\t', msq);
Cal Type field will have assigned CAL details
Hope this helps you.
I have loaded the above script and able to see this user is using Named CAL license.
However, I'm surprised why this user is not able to lease license even though he is showing as Named User in the session log with recent login date.
Please let me know what could be the probable reason? I will check if this user is tried to lease from more than 2 machines.
As you are using DMS authorization with Custom users.
Here is the tricky part with custom users Qlik will be case sensitive and may be qlik treat him as another user as there are no more CALS left therefore you get that error.
All that you have to make sure is you use same user with exact Case that you created in Custom directory and give a try
Now I'm trying to understand,
1.why that user is not able to lease lincese.?
Could be due to case sensitivity, try to use exact user for license leasing.
2. If some one else already leased available lincese, whey I can see only 10 users whome I added(along with this user) under assigned CALs
Same goes here as well. MAy be its case sensitive.
3. How I can differentiate which user is using Named CAL and which user is using Document CAL
All the users that are assigned/ allocated in below path are named users
If this user is allocated a doc cal I will try to remove his Doc Cal and check if that fixes this issue.
4. How I can force a particular user to use Named CAL?
If you allocate users in below path then it will allocate a Named Cal.
For more details on cal flow look at the below post.
Hope it helps.
One more thing I have observed, there are few named users who were not using Qlikview for Months and still I can see them, they are using Named CALs even though I have deleted them under Assigned CALs tab long back.
It seems still they are consuming Named CALs. Kindly let me know How I can remove thier Named CAL license permanantley?
Please correct me If I'm wrong.
THis is what I wanted to do now.
Take the backup of all .pgo files from documents folder. Also will take the list of users that need to be added under assigned CALs.
then Stop the services
Remove .PGO files
then start the services and add users to Assigned CALS from my backup list.
Confused on below:
How about my Document CALs. THese also need to be assinged again for all documents?
Since I'm using custom authentication, Do I need to take back of all custom users under directory connect services-->custome directory--> users?