List Software with added procedures from SD Library using SQL query
search cancel

List Software with added procedures from SD Library using SQL query

book

Article ID: 47148

calendar_today

Updated On:

Products

CA Client Automation - IT Client Manager CA Client Automation

Issue/Introduction

How to retrieve the list of procedures added to all Software in Software Delivery Library using a SQL query?

Environment

Client Automation - All supported versions.

Resolution

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)