SQL Query for list of SD packages with size

Products

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

Issue/Introduction

How to get the list of all Software packages with the columns:
- Package name
- Package version
- Package size

using a SQL Query ?

Environment

Client Automation 14.5 - All Versions

Resolution

SELECT itemname 'Package Name', itemversion 'Package Version', packagesize 'Package Size'
FROM usd_rsw ORDER BY itemname, itemversion