question Reporting - sys_audit table to heavy to query in Community Central forum

Reporting - sys_audit table to heavy to query

AlejandroV88913 — Wed, 19 Nov 2025 13:42:23 GMT

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!

Re: Reporting - sys_audit table to heavy to query

miftikhar20 — Wed, 19 Nov 2025 14:25:30 GMT

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.

Re: Reporting - sys_audit table to heavy to query

Ankur Bawiskar — Wed, 19 Nov 2025 15:20:59 GMT

@AlejandroV88913

you can check tables shared by @miftikhar20

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

Re: Reporting - sys_audit table to heavy to query

AlejandroV88913 — Wed, 19 Nov 2025 16:36:55 GMT

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

Re: Reporting - sys_audit table to heavy to query

AlejandroV88913 — Wed, 19 Nov 2025 16:39:32 GMT

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