Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Obtain Release Dates of Login Access?

Hi,

I am looking for a way to obtain what date a bundle of (10) Login Acccess Passes will be released in Qlik Sense (pv 2.2.4.0). Ideally I would like a small table in the Licence Monitor-app showing me whats future dates these tokens will be released. Is there any such feature i.e. in the QMC?

As far as I know, Login Access Passes are released in budles of 10, 28 days after the last pass in that group of 10 is used.

Hence, I load all UsageId (Login Access as Access Type) resident the LogContent-table in the monitoring app, using class(recno(),-1,10) to budle the passes into groups of 10 (=1 token). For each group I evaluate max date and ad 28 days, obtaining the release date for each particular group. But this does not seem to be correct... For instance, how can I take multiple logins within the same hour by the same user in consideration?

I really hope someone can help me! I cannot possibly be the only one with this problem.

BR

/Tove

2 Replies
Levi_Turner
Employee
Employee

Do you have the Qlik REST connector installed?

This is relatively easy in 3.x and higher since it already has data connections to API endpoints.

Side note: 2.x is unsupported at this point. I'd encourage having a plan to get on a newer version.

micheledenardi
Specialist II
Specialist II

Hi Tove,

according to Qlik® Sense Token Licensing:

"Each individual Login Access Pass becomes available again 28 days after it was first used."

To calculate the release date you don't need to write any code on the script editor but just create a new table object on default Licence Monitor App with following parameters:


Dimension: date(Date+27)

Matric: count({<[Access Type]={'Login Access'},LogTimeStamp= {">=$(=daystart(max(LogTimeStamp)-27))"}>} distinct UsageId)

Doing this you will obtain a table like this with the date of the release and the login passes that will be released on that date:

2018-03-26 14_39_49-License Monitor(1) - Il mio nuovo foglio (1) _ Fogli - Qlik Sense.png

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.