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


    • Related Articles

    • Sample JSON table mapper file for ServiceDesk Plus Cloud CMDB integration

      The JSON file maps ServiceDesk Plus Cloud's tables and fields with Site24x7's CI fields. Here’s a sample JSON mapper for integrating Site24x7 with ServiceDesk Plus Cloud: { "site24x7Mapper": [ { "Monitor_type": "SERVER", "Monitor_sub_type": "LINUX", ...

    • How can I choose resources in a monitor group for third-party integration

      By associating the monitor group with a tag, you can select the resources in a monitor group for third-party integration. Read how to add a tag to a monitor group.    Once you have added a tag to the group, choose the tag to integrate the resources ...

    • Integrating Site24x7 with third-party apps

      You can integrate the following applications with Site24x7: Zoho Analytics helps to obtain a bird's-eye view of your organization's performance across departments by amalgamating data from varied sources.  By integrating Site24x7 with Zoho Analytics, ...

    • Can I disable instrumentation of third party packages?

      Yes, you can exclude specific classes, methods or application packages from being instrumented by the Java agent. To exclude packages from being instrumented, implement the following steps: Add exclude.packages in apminsight.conf file Provide the ...

    • How to integrate Site24x7 with OpenAI (ChatGPT)?

      You can integrate OpenAI with Site24x7 monitors to derive an overall summary of your monitors. The Zia Bot can answer all your queries regarding the monitors to which you have access and answer basic questions about all monitors. The Zia Bot uses the ...