This content has been marked as final. Show 2 replies
2 of 2 people found this helpful
select p.taskpsetid, pt.taskid as etl_id, t.name as etl_name, p.value as gm, s.schedulerid, c.name as scheduler, h.hostname as scheduler_host from task_pset_props p join task_pset pt on p.taskpsetid=pt.taskpsetid join task t on pt.taskid = t.taskid join scheduler_def s on t.schedulerid=s.schedulerid join component_def c on s.componentid=c.componentid join host_def h on c.hostid=h.hostid where p.taskpsetid in( select taskpsetid from task_pset where taskid in( select taskid from task where etlmodid = 120 ) ) and p.name = 'extract.bpa.gm.url'
This query get all VIS file parser connected to a gateway server as list associated host/scheduler.
Great ! Thank you.