Query to get the name, version and procedure of jobs connected to a software policy.

Products

• CA Client Automation - IT Client Manager

Issue/Introduction

Query to get the name, version and procedure of jobs connected to a software policy.

Environment

Release : 1405

Component :

Resolution

Execute the below query to get the name, version and procedure of jobs connected to a software policy.

SELECT name 'Software Policy Name', r.itemname 'Package Name', r.itemversion 'Package Version', act.itemname 'Procedure', a.ordernumb 'Order' FROM usd_job_cont j INNER JOIN usd_link_jc_act l ON l.jcont=j.objectid INNER JOIN usd_activity a ON l.activity=a.objectid INNER JOIN usd_actproc act ON a.actproc=act.objectid INNER JOIN usd_rsw r ON act.rsw=r.objectid WHERE j.type=4 and name<>'__SD_Software Templates' ORDER BY 1,a.ordernumb