Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How do I know user's last login date in Access Point

Qlikview Gurus,

Kindly help me to find out Access Point last logged in date  for our authenticated users. As we have to identify users who are not using Qlikview for last 3 months. Kindly provide me if any one is having any utility tool that works on any access point security logs.

Regards,

Venkat

1 Solution

Accepted Solutions
aveeeeeee7en
Specialist III
Specialist III

Go to:
C:\ProgramData\QlikTech\QlikViewServer\Sessions*.log

and see:

1. Timestamp
2. 
Documentgenericqvwdocument
3. QlikView User
4. Authenticated user

Regards

Aviral Nag

View solution in original post

9 Replies
sasikanth
Master
Master

Go to QMC -> Documents Tab -> Select the dashboard to see the last used time -> Go to Document CALS Tab -> Under Last Used (UTC) you should be able to see the last used time for the dashboard.

Last Used Time.JPG

Similarly for Named cal goto QMC -> System Tab -> Click on Qlikview Server -> Client Access Licenses(CALS)-> Assigned CALs -> under Last Used (UTC) can see the last usage by the user.

Also there are some Qlikview Log Analyser dashboards which make use of the Logs to identify the last usage and all that try to use them if you wish to know more details

Anonymous
Not applicable
Author

Dear Sasikanth,

Thank you for your quick response. the above information only gives me Named user CALs. we are having many Authenticated users who access from Access Point (most of them are not Named users) . As we have 20 session CALs , these users login to access point using session CALs.

Regards,

Chinna

richard_pearce6
Luminary Alumni
Luminary Alumni

QlikView server logs information including who has accesses which dashboard. An example of how to use this can be found here (others are avaible if you do a search)

http://community.qlik.com/docs/DOC-6699

Regards

Richard

sudeepkm
Specialist III
Specialist III

Have you already checked you Session logs. I think in the session logs you can find the user id , login time, log out time and duration and many more. you need to load the session log into QlikView and then you can find the max login time group by users to find the last login time of the user. It also shows the license used by the user to access the server.

aveeeeeee7en
Specialist III
Specialist III

Go to:
C:\ProgramData\QlikTech\QlikViewServer\Sessions*.log

and see:

1. Timestamp
2. 
Documentgenericqvwdocument
3. QlikView User
4. Authenticated user

Regards

Aviral Nag

ashfaq_haseeb
Champion III
Champion III

Hi,

Have  a look at system monitor application or even governance dashboard.

Regards

ASHFAQ

Anonymous
Not applicable
Author

Dear All,

Thank you..it works with Session logs. I have used system monitoring utility and loaded session logs and created a simple straight table with Authenticated user and maximum(sessionend) . That gave me the last login date for a user.

Thank you all  for your help.

Regards,

Chinna

Not applicable
Author

hi,  my folder C:\ProgramData\QlikTech\QlikViewServerm don't have the file Session*log.

Where i setting the creation of this file ? thank you very much,

Susovan1
Contributor
Contributor

How to check last access time for qlik saas file? Can anyone please guide