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 08:49 AM
How are you "running a report out of transactionxlog" that it is timing out? I would be surprised if a direct SQL query would timeout for just a one day look up. Reporting Dashboards I would expect to timeout on something like this. More intel is needed to provide more guidance.
KP
08-29-2024 08:54 AM
Michelle
08-29-2024 09:14 AM
We do something similar where we run a PowerShell script in a Windows Scheduled Task to query the transactionxlog table off hours to export data to another table that we then use in a data provider for user productivity reports.
08-29-2024 09:47 AM
I know that this is like asking someone who drives a sports car to consider making the same trip in a pick-up, but why don't you just run a transaction report through the admin section in the Client? That gets you everything they did to what with date and time. It's only documents, but it should cover workflow activity pretty well.
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.