Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

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
Highlighted
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

8 Replies
Highlighted
Specialist III
Specialist III

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

Highlighted
Specialist
Specialist

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

Highlighted
Luminary
Luminary

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

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

Highlighted
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

Highlighted

Hi,

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

Regards

ASHFAQ

Highlighted
Specialist
Specialist

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

Highlighted
Not applicable

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,