QlikView License Monitor App Issue - Signed License Key with Professional and Analyzer users

[GiulioA]

Hi Everyone,

we were using an App to monitor the assignment or deletion of named and document licenses to Users to a customer that need this info for internal auditing needings.

We could obtain “Date Assigned” Measure calculated as  = Max({$<Flg_Have_NamedCAL = {y}>} Tms_Assigned_NamedCAL) from  Events Logs located in QW server Path “\\SERVER_NAME\QLIK_LOGS\QVS\Logs\Events_*.log”

From those files we were using the Message field to extract the info like this:

1)

If(WildMatch(Message,'*cal allocation*','*no longer marked for deletion - ok*'),'y','')                               as Flg_CalAllocation

If(WildMatch(Message,'*cal deallocation - ok*'),'y','')                                                                                              as Flg_CalDeallocation

If(WildMatch(Message,'*document*'),'y','')                                                                                                                  as Flg_Document

If(WildMatch(Message,'*named cal*'),'y','')                                                                                                                  as Flg_Named

If(WildMatch(Message,'*added - ok*','*no longer marked for deletion - ok*'),'y','')                                     as Flg_Added

If(WildMatch(Message,'*deleted - ok*','*" marked for deletion - ok*'),'y','')                                                    as Flg_Deleted

2)

If(Flg_CalAllocation='y' and Flg_Named='y' and Flg_Added='y' and Flg_Deleted='' and Flg_Document='' and Flg_CalDeallocation='','y','')    as Flg_Assigned_NamedCAL

If(Flg_CalAllocation='y' and Flg_Named='y' and Flg_Added='' and Flg_Deleted='y' and Flg_Document='' and Flg_CalDeallocation='','y','')     as Flg_Removed_NamedCAL

After changing QlikView Server License to Signed License Key and User License from Document and Named to Analyzer and Professional we can’t find this info in the events Logs located in \\SERVER_NAME\QLIK_LOGS\QVS\Logs\Events_*.log

We changed the Script to match the new license type as here below:

If(Wildmatch(Message,'*Professional*'), 'y', '')                                             as Flg_Have_ProfessionalCAL

If(Wildmatch(Message,'*Analyzer*'), 'y', '')                                                     as Flg_Have_AnalyzerCAL

But filtering the messages by using these 2 flags Flg_Have_ProfessionalCAL=’Y’ or Flg_Have_AnalyzerCAL=’Y’, the only messages that we can find in Events Log are these:

So is no more possible to catch the added or deleted license to the users by applying the wildmatch we were using with the previous licensing:

If(WildMatch(Message,'*added - ok*','*no longer marked for deletion - ok*'),'y','')                                    as Flg_Added

If(WildMatch(Message,'*deleted - ok*','*" marked for deletion - ok*'),'y','')                                                   as Flg_Deleted

Does anyone know if there’s another log file or other files where is possible to catch the Professional and Analyzer licenses allocation and deletion in QlikView environment with Signed license Key?

[Bill_Britt]

Hi,

In May 2021 SR2 I am seeing the license assignment in the Event log.  

20220801T070522.000-0400 20220801T070911.000-0400 4 100 Notice UserLicense: User M21\User1 is using Analyzer Capacity license. ab825f94-1313-4a93-b8ee-01ba43227e67

20220801T070522.000-0400 20220801T071052.000-0400 4 100 Notice UserLicense: User M21\User2 is using Analyzer license. d481720e-3095-4dc7-9acf-90c9324d74af

Bill

[GiulioA]

Hi Bill,

thanks for checking! Do you also find the license allocation or deallocation? Our customer needs to analyze those users with Professional or Analyzer license allocated that are not using the license.

I was using these from the Event Log to catch that info:

If(WildMatch(Message,'*cal allocation*','*no longer marked for deletion - ok*'),'y','')      -> Allocation

If(WildMatch(Message,'*cal deallocation - ok*'),'y','')                                                                     -> CalDeallocation