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         lfu.user_id = lulf.user_id
    left outer join externallocal_user eu on
        lf.user_id = eu.user_id

 

select lf.name as task_name,
       lf.start_dtm as task_start_dtm,
       lf.end_dtm as task_end_dtm,
       lu.first_name || ' ' || lu.last_name as local_user_name,

            eu.first_name || ' ' || eu.last_name as domain_user_name,

            lf.complete_boo as task_complete_boo,

            lm.message_type,

            lm.message

from
    log_file lf
    inner join log_message lm on
        lf.log_file_id = lm.log_file_id
    left outer join local_user lu on

...

lu on lu.user_id = lf.user_id

...

 

...

   left

...

 join external_user eu on

...

 eu.user_id = 

...

lf.user_id


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

...

The following message types (m.message_type) are found in PhixFlow log files:

  • WARNING
  • DEBUG
  • ERROR
  • INFO

The task_name field in the results will be one of:

  • A task plan name, if a task plan was run directly or under a schedule
  • A stream name, if a Stream was run directly (for example, from a model view)
  • An action name, if an 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.