06-01-2021 07:43 PM
I am looking to see when someone not in the Admin Group last ran the different Keyword Updater updates.
Is there a better table than the TransactionXLog table?
What table stores the Keyword Update processes? Does it have a last run time?
I hope that there's a better solution than this:
select top 10 *from hsi.transactionxlog tlogwhere --1032: Keyword Update – Doc Type--1033: Keyword Update – Globaltlog.action in (1032, 1033)and tlog.actionnum = 5--3: Keyword Update – Doc Type--4: Keyword Update – Globaland tlog.subactionnum in (3, 4)and tlog.usernum not in ( <LIST OF USER IDS> )order by transactionnum desc
Thanks!
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.