EN
Español
English
Português
    Common Data Model (DCM) - CMDB9

    ↩ CMDB Integration


    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.

    ADVANTAGES: - Automatic creation of CIs in the CMDB.
    - Automatic creation of relationships between CIs in the CMDB
    - Automatic modification/deletion of relationships between CIs in CMDB based on ADM events.
    - Ability to add new ICs via discovery (coming soon)


    Enable New Common Data Model (DCM) - CMDB9

    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‘ 
    

    2. To configure or modify the integration with Aranda V9, go to the configuration view of the ADM Management Console, in the General from the main menu, select the Enterprise Integration and the CMDB. In the information view, activate the corresponding CMDB connection version (old or new).


    3. To set up version 9, enter the following information: Service and Token (see Token configuration) and verify that the connection is successful.

    4. If the connection is successful, the button will change color to green indicating that the information entered is correct. If the connection is unsuccessful, the button will be orange.


    5. If the connection was successful, click the Save. If the information is stored correctly, you can display a confirmation message of the operation.


    New Connection to the CMDB

    6. When selecting the New Connection to the CMDB, a confirmation message is displayed. Click Accept to continue.

    7. Click the Save to store the information. If the trade is successful, a confirmation message will be displayed and the side menu will be automatically hidden.

    Note: Once selected, this new model will not be able to revert to the previous traditional CMDB9 model.


    8. To remove the connection, select the Clean Connection. A message is generated requesting confirmation to execute the action.


    9.By confirming the connection cleanup request, all associated data will be deleted, and you will be able to display a message confirming the success of the operation.

    Clearing the ADM connection removes all information linked to the CMDB, including synchronized CIs. If you need to integrate with the same CMDB, you can generate duplication of the CIs.


    This section will explain the relationship between CMDB9 native CIs and their visualization as ADM assets.

    Categories of IC’s

    The categories of configuration items (CIs) “native” from CMDB9, associated with ADM assets are:

    Asset Type (ADM) Origin (ADM) CI Category (CMDB)
    Application Applications installed on each of the workstations, notebooks and servers inventoried. E.g. “Word 2013” Application
    Workstation Workstation inventoried in ADM. e.g. “BG-D-ACANON01” Personal Computer
    Portable Laptop inventoried in ADM. e.g. BG-P-ACANON01 Personal Computer
    Printer Printer detected in the discovery process via SNMP protocol Printer
    Router Router detected in the discovery process via SNMP protocol Router
    Switch Switch detected in the discovery process over SNMP protocol Switch
    Server Physical server inventoried in ADM. E.g. “SRVAPP01” Server
    Operating system Operating system installed on each of the workstations, notebooks and servers inventoried. E.g. “Windows 2012 Server” Operating system
    User Responsible or frequently used user of an asset inventoried in ADM. User

    Configuring Native Categories in CMDB


    Types of relationships

    Based on the categories of native ICs, the following types of native relationships are established

    Category CI 1 (Father) Category CI 2 (Child) Direct Relationship Name (1 -> 2) Name direct relationship (2-> 1)
    Application Personal Computer It runs in Runs
    Application Server It runs in Runs
    Personal Computer Operating system Used Installed in
    Personal Computer User Responsibility of Responsible for
    Server Operating system Used Installed in
    Server User Responsibility for Responsible for

    Configuring Native Relationship Types in CMDB


    CI synchronization with ADM assets

    The CI’s are automatically synchronized after the correct configuration of the new CMDB9 model through the generation of the Hardware and Software inventory, the following table exposes the information that is displayed in ADM for each asset.

    Native CIs for category types

    Asset Type (ADM) Category CI (CMDB) Native CIs for category types Additional information
    1. Workstation Personal Computer Name CI
    •Brand
    •Model
    •Serial
    Is Laptop
    False
    2. Portable Personal Computer Name CI
    •Brand
    •Model
    •Serial
    Is Laptop
    True
    3. Server Server Name CI
    •Brand
    •Model
    •Serial
    N/A
    4. Application Application Name CI
    •Brand: Manufacturer Information
    •Model: NULL
    N/A
    5. Operating System Operating system Name CI
    •Brand: Manufacturer Information
    •Model: NULL
    N/A
    6. Responsible User Not displayed in ADM, is associated as responsible
    of the asset in cmdb (Personal Computer or server)
    N/A


    1. Workstation

    Information corresponding to the Native categories of the new Common Data Model (MSCD) CMDB is displayed. If the ADM and CMDB websites are not on the same domain or you have problems viewing all the IC information, select the “Click here” option, a new tab will open in the browser with the CI information.

    The responsible user is displayed in the CMDB relationship when it is assigned (See Responsible User Assignment) and the device CI is updated from the ADM console.


    2. Portable

    Information corresponding to the Native categories of the new Common Data Model (MSCD) CMDB is displayed. If the ADM and CMDB websites are not on the same domain or you have problems viewing all the IC information, select the “Click here” option, a new tab will open in the browser with the CI information.

    The responsible user is displayed in the CMDB relationship when it is assigned (See Responsible User Assignment) and the device CI is updated from the ADM console.


    3. Server

    Information corresponding to the Native categories of the new Common Data Model (MSCD) CMDB is displayed. If the ADM and CMDB websites are not on the same domain or you have problems viewing all the IC information, select the “Click here” option, a new tab will open in the browser with the CI information.

    The responsible user is displayed in the CMDB relationship when it is assigned (See Responsible User Assignment) and the device CI is updated from the ADM console.


    4. Application

    Information corresponding to the Native categories of the new Common Data Model (MSCD) CMDB is displayed, for each application installed on the device. If the ADM and CMDB websites are not on the same domain or you have problems viewing all the IC information, select the “Click here” option, a new tab will open in the browser with the CI information.


    5. Operating System

    Information corresponding to the Native categories of the new Common Data Model (MSCD) CMDB is displayed, by operating system product installed on the device. If the ADM and CMDB websites are not on the same domain or you have problems viewing all the IC information, select the “Click here” option, a new tab will open in the browser with the CI information.


    Automatic CI Relationship Creation and Deletion

    The respective relationships are created between the CIs synchronized from ADM to CMDB, according to the native relationship types defined above. These relationships are created later after synchronizing the information of the CIs (in the processing of the Hardware and Software inventory).

    The Printer, Router, and Switch ICs are synchronized in the SNMP discovery process after 10 minutes.

    The elimination of the relationship between the ICs is carried out from changes in the respective assets in ADM that do not imply the elimination of the asset and that modify any indicative attribute of a relationship with another asset, the current relationship between the CIs is eliminated and a new one is created. View relationship information in CMDB


    Disable New Common Data Model (DCM) - CMDB9

    If you need to disable synchronization with the Common Data Model (DCM) - CMDB9.

    1. Run the following script:

        
    INSERT INTO afw_settings 
    
            ([sett_key] 
    
            ,[sett_application_id] 
    
            ,[sett_value] 
    
            ,[sett_description] 
    
            ,[sett_project_id]) 
    
    VALUES 
    
            ('Disable_CMDB_Sync' 
    
            ,1 
    
            ,'true' 
    
            ,'Activa o inactiva la sincronización con CMDB' 
    
            ,null) 
    

    2. If you want to turn sync back on, you need to change the sett_value field to False

    Note: Disabling and then enabling sync loses data that was pending sync during the period that sync was disabled.


    ↩ CMDB Integration