How do I retrieve information from Software Delivery Library about the software that contains added procedures ?

Document ID : KB000047148
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

  How do I retrieve information from Software Delivery Library about the software that contains added procedures ?

 

Environment:                                        

  CA Client Automation - All Versions

 

 

Answer:

·      Open SQL Management Studio

·     Select New Query 

·        Run the below SQL query

 

    use mdb 
        SELECT r.itemname ‘Package Name’, r.itemversion ‘Package Version’, a.itemname
        ‘Procedure Name’
        FROM usd_actproc a, usd_rsw r
        WHERE a.rsw = r.objectid and includedproc in (0,3)
 

 

·   The results will be listed at the bottom of the page.

 

Additional Information:

  As always, please contact CA Technologies support for CA Client Automation if you have any further questions.