...
The following query gives the crucial information for each task and log message:
| Code Block | ||||
|---|---|---|---|---|
| ||||
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.