Report - unique users logged in within a month

SC17
Tera Contributor

Hi. Is there a way to create a report to track how many unique users logged in within a month?

 

Thank you.

Muhammad Khan
Mega Sage

Hi SC,

 

You can generate report on the field Last Login of sys_user.

 

Hopefully this will help you.

 

Regards,

Muhammad Khan

Hello. But the last login will give me the last time the user logged in. I want to report on unique users in a month, how many unique users logged in for example in February.

Well, then you might need to apply filter on URL (contains /login.do?sys_action=sysverb_login&user_name=) and Created field of  syslog_transaction table, and group by Created By field as follows;

 

find_real_file.png

 

Another approach would be reporting on sysevent table because there is a OOB event known as login.

find_real_file.png

 

But to be honest I have never generated reports using these two approaches.

 

Hopefully this will give you a direction.

Hello. OOB there is no option to report on syslog table because of performance issues.