...
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:
...