Performance Analytics - How to report on active users

MR13
Tera Contributor

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?

1 ACCEPTED SOLUTION

sachin_namjoshi
Kilo Patron
Kilo Patron

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

View solution in original post

1 REPLY 1

sachin_namjoshi
Kilo Patron
Kilo Patron

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