- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-02-2022 10:36 AM
Hi. Is there a way to create a report to track how many unique users logged in within a month?
Thank you.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-02-2022 10:45 AM
Hi SC,
You can generate report on the field Last Login of sys_user.
Hopefully this will help you.
Regards,
Muhammad Khan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-02-2022 10:53 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-02-2022 11:47 AM
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;
Another approach would be reporting on sysevent table because there is a OOB event known as login.
But to be honest I have never generated reports using these two approaches.
Hopefully this will give you a direction.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-03-2022 12:54 AM
Hello. OOB there is no option to report on syslog table because of performance issues.