Custom created software signatures in database

Products

• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Asset Management

Issue/Introduction

Where are stored the custom created software signatures in database.

How to retrieve details about custom created software signatures using SQL Queries ?

Environment

Client Automation - All Versions

Resolution

Custom Signature are stored in tables ca_software_def and ca_signature_def with source_type_id=2

 

Here are some SQL Queries :

 

- Get the list of custom product :

select * from ca_software_def where source_type_id=2 and software_type_id=8

 

- Get the list of custom release

select * from ca_software_def where source_type_id=2 and software_type_id=3

 

- Get the signature data definition of the release :

select r.name 'Release Name', r.sw_version_label 'Release Version', s.signature_data from ca_software_signature s, ca_software_def r where s.source_type_id=2 and s.sw_def_uuid=r.sw_def_uuid and r.software_type_id=3

 

- Releases are linked to product. Get the list of products with linked releases and its signature data :

select p.name 'Product Name', p.sw_version_label 'Product Version', r.name 'Release Name', r.sw_version_label 'Release Version', s.signature_data
from ca_link_sw_def l, ca_software_def p, ca_software_def r, ca_software_signature s
where l.source_type_id=2 and l.primary_sw_def_uuid=p.sw_def_uuid and p.source_type_id=2 and p.software_type_id=8
and l.secondary_sw_def_uuid=r.sw_def_uuid and r.source_type_id=2 and r.software_type_id=3 and s.source_type_id=2 and s.sw_def_uuid=r.sw_def_uuid