- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-17-2022 11:51 PM
Hi All -
I need active users per month not the current active users in the system. I know that we can report on the user table by last login date but I want the history information of the users who has been active previous month and not active now.
How can I report on this information .? should we do perofrmance analytics if so on what table should we do indocator source on?
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-18-2022 12:18 PM
You can configure a metric definition on sys_user table for active column.
Metric instance will be created when active flag changes in user record and you can then report on metric_instance table.
Also, you can generate metric instance for historical records using a script.
Regards,
Sachin

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-18-2022 12:18 PM
You can configure a metric definition on sys_user table for active column.
Metric instance will be created when active flag changes in user record and you can then report on metric_instance table.
Also, you can generate metric instance for historical records using a script.
Regards,
Sachin