How to list the command line parameters for the procedures for all registered software packages

Document ID : KB000095868
Last Modified Date : 15/05/2018
Show Technical Document Details
Question:
How to list the command line (including arguments) for all the procedures of each registered software package in ITCM?
Environment:
Client Automation (ITCM) -- any version.
Answer:
The following SQL query will return this information:

select usd_rsw.itemname,
usd_rsw.itemversion,
usd_actproc.itemname,
usd_actproc.proctorun,
usd_actproc.procparameter,
usd_actproc.comment
from usd_rsw
inner join usd_actproc on usd_rsw.objectid=usd_actproc.rsw
where usd_actproc.itemname not in ('delivery proc','undelivery proc')
and usd_rsw.itemtype<>5
order by usd_rsw.itemname, usd_rsw.itemversion


Sample Results:
User-added image