Sample format of the JSON mapper used in ServiceNow

Sample JSON table mapper file for ServiceNow CMDB integration

The JSON file maps ServiceNow's table and fields with Site24x7's CI fields.
​
Here’s a sample JSON mapper for integrating Site24x7 with ServiceNow:
  1. {
        "site24x7Mapper": [
            {
                "Monitor_type": "SERVER",
                "Monitor_sub_type": "LINUX",
                "ci_type_name": "cmdb_ci_linux_server",
                "fields": [
                    {
                        "s247_column_name": "HOSTNAME",
                        "ci_field_name": "host_name",
                        "type": "string",
                        "max_size": 100
                    },
                    {
                        "s247_column_name": "CPUCORES",
                        "ci_field_name": "cpu_core_count"
                    },
                    {
                        "s247_column_name": "FQDN",
                        "ci_field_name": "fqdn"
                    },
                    {
                        "s247_column_name": "DOMAIN_NAME",
                        "ci_field_name": "sys_domain"
                    },
                    {
                        "s247_column_name": "TOTALRAM",
                        "ci_field_name": "ram"
                    },
                    {
                        "s247_column_name": "BIOS_VENDOR",
                        "ci_field_name": "vendor"
                    },
                    {
                        "s247_column_name": "SERIAL_NO",
                        "ci_field_name": "serial_number"
                    }
                ]
            },
            {
                "Monitor_type": "SERVER",
                "Monitor_sub_type": "WINDOWS",
                "ci_type_name": "cmdb_ci_linux_server",
                "fields": [
                    {
                        "s247_column_name": "HOSTNAME",
                        "ci_field_name": "host_name",
                        "type": "string",
                        "max_size": 100
                    },
                    {
                        "s247_column_name": "CPUCORES",
                        "ci_field_name": "cpu_core_count"
                    },
                    {
                        "s247_column_name": "FQDN",
                        "ci_field_name": "fqdn"
                    },
                    {
                        "s247_column_name": "DOMAIN_NAME",
                        "ci_field_name": "sys_domain"
                    },
                    {
                        "s247_column_name": "NAME",
                        "ci_field_name": "name"
                    },
                    {
                        "s247_column_name": "IPADDRESS",
                        "ci_field_name": "ip_address"
                    },
                    {
                        "s247_column_name": "MANUFACTURER",
                        "ci_field_name": "manufacturer"
                    },
                    {
                        "s247_column_name": "MODEL",
                        "ci_field_name": "model"
                    }
                ]
            }
        ]
    }

Explanation

The following table shows the mandatory JSON fields.

Key 
Value
site24x7Mapper

Monitor_type
Mandatory
Specify your Site24x7 monitor type.
Example: SERVER
Monitor_sub_type
Specify your Site24x7 monitors' subtype.
Example: LINUX
ci_type_name
Mandatory
Provide the ServiceNow table name to which data will be pushed.
Example: cmdb_ci_linux_server
s247_column_name
Mandatory
Provide the Site24x7 inventory or configuration field key. Example: HOSTNAME
ci_field_name
Mandatory
Provide the ServiceNow column name to which Site24x7 data should be mapped.
Example: Configure it with the host_name column to push the host field value to it.
type
Provide the data type of configured column in ServiceNow.
Example: string
max_size
Provide the maximum size of configured column in ServiceNow. 
Example: 100