Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The following query gives the crucial information for each task and log message:

 


Code Block
languagesql
titleLog Extract SQL
select
 
     lf.name as task_name,
       lf.start_dtm as task_start_dtm,
       lf.end_dtm as task_end_dtm,
    u.username,
    concat(concat(lu.first_name || ,' '), || lu.last_name) as local_user_name,
            concat(concat(eu.first_name || ,' ' ||), eu.last_name) as domain_user_name,
       
    lf.complete_boo as task_complete_boo,
      lm.message_type,
     lm.message_typesequence,
    lm.message_dtm,
       lm.message
from
    log_file lf
    innerleft join log_message lm on         lf.log_file_id = lm.log_file_id
    left outer join localcv_user luu on u.user_id = lf.user_id
    left join local_user lu on lflu.user_id = lulf.user_id
    left outer join external_user eu on         lfeu.user_id = eulf.user_id

 


To run this query you will need read access to the following tables in the PhixFlow schema:

...

  • A task plan name, if a task plan was run directly or under a schedule
  • A stream name, if a stream Stream was run directly (for example, from a model view)
  • An action name, if an streamAction Action triggered the task plan

This is simply what appears in the Name field of the Active Tasks and Completed Tasks windows in the System Console.