08-29-2024 08:38 AM
I need to do a report on a user's activity in OnBase for an HR case. They mostly work in Workflow so I was able to get some information from the wflog table. But they also import documents. I need a report of all the login/out times and any documents viewed/created.
I tried running a report out of transactionxlog but it timed out. Same for hsi.itemdata. Even when I put it down to a 1 day date range, they both timed out. Yes, I did the "set transaction isolation level read uncommitted".
Reporting dashboards don't give me any of this information or they timeout as well.
Ideas?
Thanks!
Michelle
08-29-2024 10:25 AM
Good luck,
KP
08-29-2024 10:48 AM
I have been over and over the db maintenance (indexing and stats updates) with the DBA. We had a lot of app performance issues before the optimization.
That's a good thought on the copy. I wonder how much work that would be. We do so much db querying.
I'll take a look at that option in the thick client. I don't use the thick client much so I'm not aware of what is in there.
thank you for the input!
08-29-2024 11:25 AM
If you do not have the logdate index, here is an article (while old, it's still relevant) that speaks to it. If you have further questions on this and would like the index added, please submit a support case and Hyland Technical Support will be glad to assist.
08-29-2024 12:02 PM
I actually got the transaction log report to run in the thick client. Thank you
Michelle
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.