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

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Affects Release version(s): null

null

Environment

Release:
Component: AAUTEN

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''%'