Usage Information on Clarity PPM MUX Staffing Page

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

• It is required to determine the usage of the Modern UX 'Staffing' module
• Is it possible to identify the users or the user groups that are using this module, or pages within it?

Resolution

This information is captured in the access logs. The access logs are loaded into tables such as log_details and log_sessions, if the 'Tomcat access log import/analyze' job is scheduled to run in the system. These tables can therefore be queried to determine this information.

Additional Information

Sample query:

select
    csu.full_name,
    ld.start_time,
    ld.url_short,
    ld.action_method,
    ld.url_action
from
    log_details ld
    join log_sessions ls on ld.session_cookie = ls.token
    join cmn_sec_users csu on csu.id = ls.user_id
where
    lower(ld.url_action) like '%obastaffs%'
order by
    ld.start_time desc
;