How to find or get a list of all jobs where "Show job on Desktop" option is checked (on Windows tab)?

Document ID : KB000088512
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Affects Release version(s): null

null
Resolution:

The query below will return all the Windows job where the option "Show job on Desktop" is checked.

select oh.oh_client, oh.oh_idnr, oh.oh_otype, oh.oh_name,  host_hostattrtype ,jba_rest  
from jba , oh, host, oh ohost   
where 1=1 
and jba_oh_idnr = oh.oh_idnr  
and jba_hostdst = ohost.oh_name 
and ohost.oh_idnr = host.host_oh_idnr  
and host.host_hostattrtype = 'WINDOWS' 
and jba_rest like '%H=''1''%' 
union all 
select oh.oh_client, oh.oh_idnr, oh.oh_otype, oh.oh_name, ohg_hostattrtype ,jba_rest  
from jba , oh, ohg, oh ohost   
where 1=1 
and jba_oh_idnr = oh.oh_idnr  
and jba_hostdst = ohost.oh_name 
and ohost.oh_idnr = ohg_oh_idnr  
and ohg_hostattrtype = 'WINDOWS' 
and jba_rest like '%H=''1''%'