Relationship between CMDB and Intune

To perform the integration, you need to relate the Aranda CMDB device fields to the device fields in Intune using the “ci” section of the configuration file.

JSON Structure

{
    "ci": [
        {
            "reference": "",
            "definition": {
                "name": {
                    "type": "",
                    "key": ""
                },
                "brand": {
                    "type": "",
                    "key": ""
                },
                "model": {
                    "type": "",
                    "key": ""
                },
                "assetTag": {
                    "type": "",
                    "key": ""
                },
                "serial": {
                    "type": "",
                    "key": ""
                },
                "responsible": {
                    "SearchBy": [
                        "Email"
                    ],
                    "type": "",
                    "key": "",
                    "DefaultValue": {
                        "id": 0
                    }
                }
            }
        }
    ]
}

Properties :

Definition

To perform the integration, relate the CI fields in Aranda CMDB to the Intune CI using the “definition” section of the configuration file. These properties in CMDB can be associated with fields in Intune.

Properties:

Ci in CMDB: Reference illustration, IC information in the CMDB

Ci en Intune: Ilustración de referencia, información básica del ci en la plataforma Intune

Propiedades internas

{
  "key": "",
  "type": "",
  "searchBy": [ "Email" ],
  "defaultValue": {
    "id": 0,
    "value": ""
  }
}

Where:

Types of relationship or association of fields

The following types of association determine how the values of the properties of the ci will be obtained.

Example type Value

1. Set the value “computer” to the Reference.
2. In the definition of the Ci Take the property Applicant (model) and assign the association type as Value.

{
  "ci": [
    {
      "reference": "computer",
      "definition": {
        "model": {
          "type": "Value"
        }
      }
    }
  ]
}

1. The relationship implies that a value must be assigned in a common way for all the Ci, this is accomplished by using the “model” property, as shown below:

{
  "ci": [
    {
      "reference": "computer",
      "definition": {
        "model": {
          "type": "Value"
        }
      }
    }
  ],
  "model": [
    {
      "reference": "",
      "id": 10
    }
  ]
}

1. Assign a value to the property “model.reference”:

{
  "case": [
    {
      "reference": "computer",
      "definition": {
        "applicant": {
          "type": "Value"
        }
      }
    }
  ],
  "applicant": [
    {
      "reference": "computer",
      "id": 10
    }
  ]
}

⚐ Note: The Ci associated with the “reference” “computer”, in CMDB they will be assigned the applicant with ID 10.

Mapper type example

1. Set the value “computer” to the Reference.
2. In the definition of the Ci Take the property Applicant (model).
3. “type”: Assign the association type as Mapper.
4. “key”: Name the property in Intune as modelIntune (Intune properties).

{
  "ci": [
    {
      "reference": "computer",
      "definition": {
        "model": {
          "type": "Mapper",
          "key": "modelIntune"
        }
      }
    }
  ]
}

5. The relationship implies that you need to associate your CMDB models with your Intune models, we recommend that you write the Id of the model to be related, as shown below:

{
  "case": [
    {
      "reference": "computer",
      "definition": {
        "model": {
          "type": "Mapper"
        }
      }
    }
  ],
  "model": [
    {
      "reference": "computer",
      "mapping": [
        {
          "id": 5,
          "value": "hp probook"
        }
      ]
    }
  ]
}

⚐ Note: Relates model with CMDB ID “5” to model “hp probook” in Intune

Search Property

The searchBy property is for the responsible field.

This tag allows you to define the property by which the user search will be performed on the CMDB and Intune platforms; the supported property is “Email”.

Use Case

For proper use of the “Email” search property, users of the two platforms must have the same email per user. The following is an example of the responsible property with the “Email” search option.

{
  "responsible": {
      "type": "FieldValue",
      "key": "user",
      "searchBy": [ "Email" ]
      }
}

defaultValue property

1. The property defaultValue allows you to add default values, if you add this property with the value of defaultValue.id for the CI in Aranda.
2. You can only add a default value if the mapping type is “Mapper” or “FieldValue”.

Example:

1. Set the value “computer” to the Reference.
2. In the definition of the Ci Take Responsible Property (responsible).
3. “type”: Assign the association type as FieldValue.
4. “key”: Name the property in Intune as userPrincipalName (Intune properties).
5. “defaultValue”: Assign the defaultValue.

{
  "ci": [
    {
      "reference": "computer",
      "definition": {
        "responsible": {
          "key": "userPrincipalName",
          "type": "FieldValue",
          "defaultValue": {
            "id": 222
          }
        }
      }
    }
  ]
}

FieldValue Example

1. Set the value “computer” to the Reference.
2. In the definition of the Ci Take the property model (model).
3. “type”: Assign the association type as FieldValue.
4. “key”: Name the property in Intune as model (Intune properties).

{
  "ci": [
    {
      "reference": "computer",
      "definition": {
        "model": {
          "type": "FieldValue",
          "key": "model"
        }
      }
    }
  ]
}

↩ Back to Settings