How to retrieve the list of procedures added to all Software in Software Delivery Library using a SQL query?
Client Automation - All supported versions.
The following query can be executed using WinOffline or directly on SQL Server Management Studio:
SELECT r.itemname as Package_Name, r.itemversion as Package_Version, a.itemname as Procedure_Name
FROM usd_actproc a, usd_rsw r
WHERE a.rsw = r.objectid
and includedproc in (0,1,2,3)