cancel
Showing results for 
Search instead for 
Did you mean: 

MSSQL Query for Keyword Updater Processes

Melissa_Foster
Star Collaborator
Star Collaborator

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!

0 REPLIES 0