List SD packages in the Software Delivery Library using SQL Query

Products

• CA Client Automation - IT Client Manager
• CA Client Automation

Issue/Introduction

How, with a SQL query, can I get a list of all the Software Delivery packages in the Software Delivery Library or just those in a specific Software Group?

Environment

Client Automation

Software Delivery

Microsoft SQL Server

Resolution

To list all the packages in the Software library you can run:

use mdb
select distinct itemname, itemversion, objectid from usd_rsw

 

To list all the software packages that are members of a Software Group, for example "Patch Management" group, you can run:

use mdb
select distinct itemname, itemversion, objectid

from usd_rsw inner join (select sw from usd_link_swg_sw where swg in (select objectid from usd_swfold where name = 'Unicenter Patch Management Packages'))  as t1 on t1.sw=objectid order by itemname