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:

{
    "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`

Sample format of the JSON mapper used in ServiceNow

Sample JSON table mapper file for ServiceNow CMDB integration

Explanation