Query to list software packages meta data

Document ID : KB000098198
Last Modified Date : 27/05/2018
Show Technical Document Details
Question:
How do I create a SQL query to list the following data?
Software Package Name, Version, Procedure Name, Install command used in the procedure and the Parameters used in the procedure.

I see information in different tables but cannot find a way to link the data.
Environment:
All versions of CA Client Automation
Answer:
The following SQL Query can be used to list the Software Package and Procedure details:
select sw.itemname as sofware_name,sw.itemversion as version,act.itemname as procedurename, act.proctorun as Installcommand, act.procparameter from usd_actproc act, usd_rsw sw where act.rsw=sw.objectid