La propiedad “ci” permite relacionar los campos del CI de la CMDB de Aranda con los campos de las clases o tablas de la CMDB de ServiceNow:
A continuación ejemplo de un CI en la CMDB de Aranda
Los campos del CI en las CMDBs de Aranda y ServiceNow se presenta mediante el siguiente JSON (Archivo de configuración):
{
"numberProcesses": 0,
"bulkLoad": false,
"ci": [
{
"reference": "",
"definition": {
"name": {
"type": "",
"mappingDirection": "",
"searchBy": "",
"key": ""
},
"description": {
"type": "",
"mappingDirection": "",
"searchBy": "",
"key": ""
},
"assetTag": {
"type": "",
"mappingDirection": "",
"searchBy": "",
"key": ""
},
"serial": {
"type": "",
"mappingDirection": "",
"searchBy": "",
"key": ""
},
"rfid": {
"type": "",
"mappingDirection": "",
"searchBy": "",
"key": ""
},
"barCode": {
"type": "",
"mappingDirection": "",
"searchBy": "",
"key": ""
},
"licenseNumber": {
"type": "",
"mappingDirection": "",
"searchBy": "",
"key": ""
},
"price": {
"type": "",
"mappingDirection": "",
"searchBy": "",
"key": ""
},
"installationDate": {
"type": "",
"mappingDirection": "",
"searchBy": "",
"key": ""
},
"reponsibleDate": {
"type": "",
"mappingDirection": "",
"searchBy": "",
"key": ""
},
"size": {
"type": "",
"mappingDirection": "",
"searchBy": "",
"key": ""
},
"measureUnit": {
"type": "",
"mappingDirection": "",
"key": "",
"searchBy": ""
},
"brand": {
"type": "",
"defaultValue": {
"id": 0,
"value": ""
},
"onError": {
"action": "",
"message": ""
},
"mappingDirection": "",
"key": "",
"searchBy": ""
},
"model": {
"type": "",
"defaultValue": {
"id": 0,
"value": ""
},
"onError": {
"action": "",
"message": ""
},
"mappingDirection": "",
"key": "",
"searchBy": ""
},
"responsible": {
"type": "",
"defaultValue": {
"id": 0,
"value": ""
},
"onError": {
"action": "",
"message": ""
},
"mappingDirection": "",
"key": "",
"searchBy": ""
},
"provider": {
"type": "",
"defaultValue": {
"id": 0,
"value": ""
},
"onError": {
"action": "",
"message": ""
},
"mappingDirection": "",
"key": "",
"searchBy": ""
},
"manufacturer": {
"type": "",
"defaultValue": {
"id": 0,
"value": ""
},
"onError": {
"action": "",
"message": ""
},
"mappingDirection": "",
"key": "",
"searchBy": ""
},
"costCenter": {
"type": "",
"defaultValue": {
"id": 0,
"value": ""
},
"onError": {
"action": "",
"message": ""
},
"mappingDirection": "",
"key": "",
"searchBy": ""
}
}
}
],
"brand": [
],
"model": [
],
"responsible": [
],
"provider": [
],
"manufacturer": [
],
"costCenter": [
],
"externalClass": [
],
"category": [
],
"impact": [
],
"risk": [
],
"relationship": {
}
}
La propiedad “reference” del archivo de configuración relaciona la categoría con la definición de los campos para el CI:
Nota: La propiedad “reference” del archivo de configuración se definió en el punto 5 de la sección Registrar la propiedad “category”
1. Asigne el valor de computer en la propiedad “reference”; ya asignado en capítulos anteriores:
{
"ci": [
{
"reference": "computer",
"definition": {
"assetTag": {
"type": "",
"searchBy": "",
"mappingDirection": "",
"key": ""
},
"barCode": {
"type": "",
"searchBy": "",
"mappingDirection": "",
"key": ""
},
"brand": {
"type": "",
"searchBy": "",
"mappingDirection": "",
"key": ""
},
"costCenter": {
"type": "",
"searchBy": "",
"mappingDirection": "",
"key": ""
},
"description": {
"type": "",
"searchBy": "",
"mappingDirection": "",
"key": ""
},
"installationDate": {
"type": "",
"searchBy": "",
"mappingDirection": "",
"key": ""
},
"licenseNumber": {
"type": "",
"searchBy": "",
"mappingDirection": "",
"key": ""
},
"manufacturer": {
"type": "",
"searchBy": "",
"mappingDirection": "",
"key": ""
},
"measureUnit": {
"type": "",
"searchBy": "",
"mappingDirection": "",
"key": ""
},
"model": {
"type": "",
"searchBy": "",
"mappingDirection": "",
"key": ""
},
"name": {
"type": "",
"searchBy": "",
"mappingDirection": "",
"key": ""
},
"price": {
"type": "",
"searchBy": "",
"mappingDirection": "",
"key": ""
},
"provider": {
"type": "",
"searchBy": "",
"mappingDirection": "",
"key": ""
},
"reponsibleDate": {
"type": "",
"searchBy": "",
"mappingDirection": "",
"key": ""
},
"responsible": {
"type": "",
"searchBy": "",
"mappingDirection": "",
"key": ""
},
"rfid": {
"type": "",
"searchBy": "",
"mappingDirection": "",
"key": ""
},
"serial": {
"type": "",
"searchBy": "",
"mappingDirection": "",
"key": ""
}
}
}
]
}
2. Obtenga el nombre de las propiedades de las clases tablas de la CMDB de ServiceNow que relacionará con las propiedades de la CMDB de Aranda, dando clic derecho sobre el nombre del campo y seleccionando la opción show:
| Propiedad en ServiceNow | ||
|---|---|---|
| Label | Name | Tipo de campo |
| Name | name | Data |
| Description | short_description | Data |
| Asset tag | asset_tag | Data |
| Manufacturer | manufacturer | Reference |
| Asset | asset | Data |
| Operational status | operational_status | Choice |
| Risk | u_risk | Choice |
| Company | company | Reference |
| Serial number | serial_number | Data |
| Model ID | model_id | Reference |
| Assigned to | assigned_to | Reference |
3. Cree una relación entre las propiedades de las CMDBs de Aranda y ServiceNow:
| Propiedad en la CMDB de Aranda | Propiedad en la CMDB de ServiceNow | |
|---|---|---|
| name | name | |
| assetTag | asset_tag | |
| manufacturer | manufacturer | |
| – | asset | |
| state | operational_status | * |
| risk | u_risk | * |
| – | company | |
| serial | serial_number | |
| model | model_id | |
| responsible | assigned_to | |
| description | short_description |
Nota: Los campos asignados con asterisco ( * ) se asignan en otra sección.
4. Asigne el tipo de mapeo que realizaran las propiedades :
| FieldValue: | Toma el valor directamente de ServiceNow; si el campo en ServiceNow es de tipo Reference debe agregar el valor “searchBy” en el archivo de configuración, este campo corresponde al campo por el que se buscará el valor |
| Value: | Toma el valor del archivo de configuración para el campo seleccionado |
| Mapper: | Asigne este valor de mapeo si necesita comparar o relacionar valores de ASMS y ServiceNow |
| Propiedad en la CMDB de Aranda | Propiedad en la CMDB de ServiceNow | Tipo de Mapeo |
|---|---|---|
| name | name | FieldValue |
| assetTag | asset_tag | FieldValue |
| manufacturer | manufacturer | FieldValue |
| serial | serial_number | FieldValue |
| model | model_id | Mapper |
| responsible | assigned_to | FieldValue |
| description | short_description | FieldValue |
5. Las propiedades asignadas con el “mapping type” “FieldValue” y el tipo de campo “Reference”, requieren la propiedad “searchBy” en el archivo de configuración, esta propiedad permite realizar la búsqueda en ServiceNow:
Asigne el nombre de búsqueda para las propiedades tipo FieldValue:
| Propiedad en la CMDB de Aranda | Propiedad en la CMDB de ServiceNow | Tipo de Mapeo | Campo de búsqueda |
|---|---|---|---|
| name | name | FieldValue | – |
| assetTag | asset_tag | FieldValue | – |
| manufacturer | manufacturer | FieldValue | name |
| serial | serial_number | FieldValue | – |
| model | model_id | Mapper | display_name |
| responsible | assigned_to | FieldValue | name |
| description | short_description | – |
Nota: Los valores que se relacionarán deben estar en las CMDBs de Aranda y ServiceNow:
6. Escriba en el archivo de configuración la relación realizada en los pasos anteriores:
{
"ci": [
{
"reference": "computer",
"definition": {
"assetTag": {
"mappingDirection": "",
"key": "asset_tag",
"type": "FieldValue"
},
"manufacturer": {
"mappingDirection": "",
"type": "FieldValue",
"key": "manufacturer",
"searchBy": "name"
},
"description": {
"mappingDirection": "",
"type": "FieldValue",
"key": "short_description"
},
"model": {
"searchBy": "display_name",
"mappingDirection": "",
"type": "Mapper",
"key": "model_id"
},
"name": {
"mappingDirection": "",
"type": "FieldValue",
"key": "name"
},
"responsible": {
"mappingDirection": "",
"type": "FieldValue",
"key": "assigned_to"
},
"serial": {
"mappingDirection": "",
"type": "FieldValue",
"key": "serial_number"
},
"size": null,
"costCenter": null,
"price": null,
"provider": null,
"reponsibleDate": null,
"residualValue": null,
"installationDate": null,
"brand": null,
"measureUnit": null
}
}
]
}
7. La propiedad “mappingDirection” determina que plataforma Actualizara los campos del CI después de ser creado, por defecto (sin agregar el campo) el valor del campo es “Both”
Los valores permitidos se describen a continuación:
| Nombre | Descripción |
|---|---|
| Both | Las dos plataformas permiten actualizar el campos, este valor es agregado por defecto |
| Aranda | Sólo la CMDB de Aranda puede actualizar el campo |
| External | Sólo la CMDB de ServiceNow puede actualizar el campo |
8. Para el ejemplo asignaremos los siguientes valores para la propiedad “mappingDirection”:
{
"ci": [
{
"reference": "computer",
"definition": {
"assetTag": {
"mappingDirection": "Aranda",
"key": "asset_tag",
"type": "FieldValue"
},
"manufacturer": {
"mappingDirection": "Aranda",
"type": "FieldValue",
"key": "manufacturer",
"searchBy": "name"
},
"description": {
"mappingDirection": "Aranda",
"type": "FieldValue",
"key": "short_description"
},
"model": {
"searchBy": "display_name",
"mappingDirection": "External",
"type": "Mapper",
"key": "model_id"
},
"name": {
"mappingDirection": "Aranda",
"type": "FieldValue",
"key": "name"
},
"responsible": {
"mappingDirection": "Aranda",
"type": "Value"
},
"serial": {
"mappingDirection": "External",
"type": "FieldValue",
"key": "serial_number"
}
}
}
]
}