Clarity

Hello!

We are trying to develop a logon monitoring report in order to show how often users use Clarity in our company.

We found the "Last Logged In" atribute, but we need all user logon during a month, for example, not only the last one.

Is there a possible way to do it?

Thanks

I think you won't be able to do it with the data available on the database.

You may implement something to generate this data. For example, you can make a process that will record the last login date every couple of hours in a custom table or custom object.

Regards,

Roberto Barra

The access log files could also be analysed.

I thought about them, but I guess that they don't have the user ir ou user name, only client IP.

The access logs contain the session ID as the final parameter now (this change was made sometime during 13.x, I'm not sure which version exactly).

The session ID alone cannot be used to identify someone, but if you gather them from the logs and check the CMN_SESSIONS and/or CMN_SESSION_AUDITS tables before the records are removed again, you can then perform a lookup through the USER_ID to the CMN_SEC_USERS table for the information.

There is a Log Analyzer Package that - if/when it is available (it isn't currently) - may perform this work and provide this information using this method, but the release of this is undetermined currently.  You may wish to follow updates on this thread to see when an update on that can be given: Log Analyzer Package (aka Apache Tomcat Log Analysis Package)

We'll test the tips you proposed. That helped us a lot!

Thanks everyone!

Hi Flor,

There is already a job from 14.1 on wards and you can build reports using the below tables.

From Change and Impact Guide

Apache Tomcat Log Analysis

The following jobs have been added to create and manage data that you can use to analyze performance in an Apache Tomcat environment. You can add custom portlets, queries, or externally available content to provide details regarding system performance. Although the job runs for application servers other than Tomcat, no data is created.

• Tomcat Access Log Import/Analyze JobThis job imports and analyzes Tomcat access log files from the local CA Clarity PPM environment (all app services). The job stores and summarizes the data in the following designated tables:
  • LOG_DETAILS
  • LOG_SUMMARY
  • LOG_FILES
  • LOG_REPORTDEFS
• Delete Log Analysis Data JobThis job removes the analysis-related data that is stored in CA Clarity PPM. The criteria for removing the data is the LOG_DATE on each of the log analysis tables.The job is scheduled to run automatically at 1:00 A.M. each day.

Upgrade Action: None

Regards

Suman Pramanik

We are in 13.2 version, but maybe we'll update it soon

Thanks Suman!

Another option if on premise would be an after update trigger which updated an custom table to track the information you need.

V/r,

Gene