Log in to create and rate content, and to follow, bookmark, and share content with other members.
AnsweredAssumed Answered
can anyone help me out in searching the queue time and run time attribute collection attribute? we have searched the whole schema but did not found anything.Is there any logic to determine this attribute?
Question asked by Neha Mehta on Apr 23, 2019 Latest reply on Apr 23, 2019 by Kristian Nordman
I have not found any way to extract queue time from the database, but start and end time are available in T_DATA_RUN_TASKS.
Those two can be used in calculations to get runtime in seconds. The below will return a fair bit of data, depending on your system and you'll probably want to specify the exact columns you want. run_time is in seconds
SELECT(end_time-start_time)*24*60*60AS run_time, task.*, TDC.NAME FROM T_DATA_RUN_TASKS task JOIN T_DATA_COLLECTORS tdc ON task."SOURCE"= tdc.ID WHERE task.TYPE='DataCollection'
Hi!
I have not found any way to extract queue time from the database, but start and end time are available in T_DATA_RUN_TASKS.
Those two can be used in calculations to get runtime in seconds. The below will return a fair bit of data, depending on your system and you'll probably want to specify the exact columns you want. run_time is in seconds
Hope this helps
Regards
Kristian