Finding Which User / Robot previously ran a process via either [Add Automation Task to Queue] or just normal runs.

  • 17 January 2020
  • 0 replies
  • 1 view

To determine what process was ran and who/which robot had triggered the process, it is entirely possible to query the information out from the Kryon Database. 

 

Refer to the script as follows:

 

select

      ls.Title AS "WizardName (First Embedded Wizard)"

      ,lrh.RunTime

      ,lu.UserName

from LeoRunHistory lrh

      inner join LeoScripts ls on ls.ScriptID = lrh.RealScriptID

      inner join LeoUsers lu on lu.UserID = lrh.UserID

where CONVERT(varchar(10),lrh.RunTime,104) = '12.11.2019' --system date format (query first before setting)

Order By RunTime Desc

 

By running the above SQL query in your Leo DB, you will receive the following sorted information:

  • Wizard Name
  • RunTime
  • UserName

 

This will help you and your team to drill down on the timeline each process was ran.

 

All the best!


0 replies

Be the first to reply!

Reply