Reporting - sys_audit table to heavy to query

[AlejandroV88913]

Hi Everyone!

I was wondering about the following statement:

I want a report that shows how many Users were active on specific days throughout the year.

Unable to query the 'sys_audit' table since the system goes down and transactions have to be cancelled.

I need the get the users' list per date.

Can anybody help with this?

Thanks!

[M Iftikhar]

Hi @AlejandroV88913,

You can use User Login Histories [sys_user_login_history] or Event Log [sysevent] table to create similar report.

Also please check this KB article: User login-logout statistics/report for an instance - Support and Troubleshooting

If my response helped, please mark it as the accepted solution so others can benefit as well.

[AlejandroV88913]

Thanks, M!

Yet, the user is looking for ways to create a report with the active/inactive dates, not the logins. I believe it is the 'state' of each user to track per date and determine X date we had Y users active.

Please, can you help? Thanks

[Ankur Bawiskar]

@AlejandroV88913 

you can check tables shared by @M Iftikhar 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[AlejandroV88913]

Ankur, thanks a lot for getting back to me!
When I follow that @m_... link, it takes me to a user's profile but I don't get to see information... Can you help me? Thanks