03-14-2022 08:07 AM
So I have been working through what SQL queries I would like to have executed and based on the results to potentially trigger alerts. However, I know that my list is probably small compared to others. So I come to you to see what other OnBase customers/admins run to monitor their system.
Here is a list of the ones that I have come up with so far.
What others have you come up with to help monitor your system?
Thanks.
03-15-2022 04:54 AM
03-15-2022 05:13 AM
I use a combination of Scheduled Tasks, PowerShell, and SQL to check changed permissions for high-value accounts, check for duplicate IDs when users transfer departments, check for failed or inconsistent processes, check for workstation license changes and additions, etc. Some of these are just log while others send notifications to our ticket system to be resolved.
03-15-2022 05:45 AM
Something that recently came up are duplicate emails coming into the system.
I am unclear as to why this happens other than retries due to something in the emails but looking at the email reveals no issues and neither does reprocessing. Thoughts on this issue anyone?
SELECT DISTINCT kt12.keyvaluechar Mail_Messsage_ID_KW12, count(kt12.keyvaluechar) dup_count,
trim(i.itemname) AS 'Document Name'
FROM hsi.itemdata i
left outer join hsi.keyxitem12 kx12 on i.itemnum = kx12.itemnum
left outer join hsi.keytable12 kt12 on kx12.keywordnum = kt12.keywordnum and kt12.keyvaluechar not like 'BATCH%' --Scnaed batches
left outer join hsi.keyitem293 ks293 on i.itemnum = ks293.itemnum --Attachment No
where itemtypegroupnum = 101 --Claims
and status<> 16 --0 – Indexed (available for retrieval) 1 – Awaiting Index 16 – Deleted
and ks293.keyvaluesmall=0
and i.itemdate > cast( '2022-01-01' as date)
group by kt12.keyvaluechar, trim(i.itemname)
having count(kt12.keyvaluechar) >1
03-15-2022 06:35 AM
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.