Which table in SQL will store the application registration information of CA Client Automation.

Products

• CA Client Automation - IT Client Manager

Issue/Introduction

Which table in SQL will store the application registration information of CA Client Automation ? 

Environment

Client Automation - All versions.

Resolution

Execute the Query : select * from ca_application_registration . The query will display application registrations as below. 

Additional Information

product_specific_data for product_code=2015, indicates which plugins are installed on the Domain Manager.

 

p=AM;p=RC;p=SD;p=DD; means that Domain Manager has following components installed :

 

Asset Management (AM)

Remote Control (RC)

SD (Software Delivery)

DD (Desktop Deployment)

 

If SD component is not installed on the DOMAIN Manager and SD component appears in product_specific_data, it could be removed with :

UPDATE ca_application_registration set product_specific_data='p=AM;p=RC;p=DD;' where product_code=2015"