...
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 onlf.log_file_id = lm.log_file_id
left outer join local_user lu on lf.user_id = lu.user_id left outer join external_user eu onlf.user_id = eu.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:
...