...
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_sequence, lm.message_dtm, lm.message |
...
from |
...
log_file lf |
...
...
left join log_message lm on |
...
|
...
lf.log_file_id = lm.log_file_id |
...
left |
...
join |
...
cv_user |
...
u on |
...
u.user_id = lf.user_id left join local_user 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.