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

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

book

Article ID: 243778

calendar_today

Updated On:

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"