Track how many users have used Clarity timesheet mobile App

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Is there a way to track how many users have used the Mobile app? This will help us to know if we have to circulate the Mobile use with our users.

Environment

Release : 15.9.1

Resolution

Following options are available:

1. When a user accesses the Mobile Time Manager App, an entry is generated to the app-access.log. The entry contains keyword 'GET /niku/odata/getTimeAppInitial?'. Access the log and filter for this entry to get the use count.
2. Run the following query which returns the user name and total number of times the user signed in:

SELECT a.url_short
    ,b.user_id
    ,COUNT(b.user_id) "Total Number of Times"
    ,c.FULL_NAME "Name"
FROM log_details a
    ,log_sessions b
    ,srm_resources c
WHERE a.session_cookie = b.token
    AND a.URL_SHORT = 'odata/getTimeAppInitial'
    AND c.user_id = b.user_id
GROUP BY a.url_short
    ,b.user_id
    ,c.FULL_NAME