Where are the Identity Manager "Configurations' options stored?

Products

• CA Identity Manager

Issue/Introduction

We would like to know where the 'Configurations' options, Configurure Global Proxy, Configure Task Resubmission Policy, and Configure SMS are stored in Identity Manager:

Environment

Identity Manager 14.5

Resolution

CONFIGURE SMS

Has its own database table, SMS_CONFIGURATION:

 

CONFIGURE TASK RESUBMISSION POLICY

Has its own database table, TASK_RESUBMISSION_POLICY:

 

CONFIGURE GLOBAL PROXY

Stored in the IM_ENVIRONMENT_JDBC_LD under the SECTION_NAME 'misc'

You can query for the misc SECTION_NAME:

SELECT  *
  FROM [IDM].[dbo].[IM_ENVIRONMENT_JDBC_LD]
  WHERE SECTION_NAME = 'misc'

And for the specific Proxy settings with:

SELECT *
  FROM [IDM].[dbo].[IM_ENVIRONMENT_JDBC_LD]
  where ATTRIBUTE_NAME like '%Proxy%'