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.

[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! 🙏