1. Enable Common Data Model (DCM) - CMDB9
2. Extend cache times
3. CIs Replica Data Synchronization Time Configuration

Enable Common Data Model (DCM) - CMDB9

In the new common data model, native IC categories are implemented from CMDB9, which are associated with ADM assets and are aligned with ITSM industry standards. These native categories are automatically synchronized to the CMDB and without the need for user intervention, in addition to the initial configuration of the connection itself to the CMDB.

To Enable Common Data Model (DCM) - CMDB9, you need to:

1. Run the following script:

SELECT  * FROM afw_settings WHERE sett_key = 'ShowCmdbCommonDataModelOption' 

UPDATE afw_settings SET sett_value = 'true' WHERE sett_key = 'ShowCmdbCommonDataModelOption‘ 

Extend cache times

Currently, ADM has a 10-minute caching time for configuration data when making requests to the CMDB. Extending the cache time reduces the number of requests made to the CMDB on the configuration data.

To change the value of the cached configuration data, you need to:

• Run the following script

Insert

   INSERT INTO [dbo].[AFW_SETTINGS]
              ([sett_key]
              ,[sett_application_id]
              ,[sett_value]
              ,[sett_description]
              ,[sett_project_id])
   VALUES
              ('CmdbCacheTime'
              ,1
              ,'1'
              ,null
              ,null)

⚐ Note:
-The duration of the field sett_value must be expressed in minutes.

CIs Replica Data Synchronization Time Configuration

If the CI data in the CMDB does not change frequently, it is recommended to keep the default value or increase it to extend the refresh interval. If the CI data is frequently modified and the replicas in ADM require updating, reduce the refresh interval. Reducing the default value can lead to an increase in the number of requests.

To modify the replica data synchronization value, you need to:

• Run the following script

Insert

  INSERT INTO [dbo].[AFW_SETTINGS]
           ([sett_key]
           ,[sett_application_id]
           ,[sett_value]
           ,[sett_description]
           ,[sett_project_id])
     VALUES
           ('DaysSynchronizeLocalCmdbData'
           ,1
           ,'1'
           ,null
           ,null)
   

⚐ Notes:
- The duration of the field sett_value must be expressed in days.