Sample format of the JSON mapper used in ServiceDesk Plus Cloud.

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:

  1. {

        "site24x7Mapper": [

            {

                "Monitor_type": "SERVER",

                "Monitor_sub_type": "LINUX",

                "ci_type_name": "ci_linux",

                "fields": [

                    {

                        "s247_column_name": "HOSTNAME",

                        "ci_field_name": "txt_hostname",

                        "type": "string",

                        "max_size": 100

                    },

                    {

                        "s247_column_name": "CPUCORES",

                        "ci_field_name": "txt_cpucores"

                    },

                    {

                        "s247_column_name": "FQDN",

                        "ci_field_name": "txt_fqdn"

                    },

                    {

                        "s247_column_name": "DOMAIN_NAME",

                        "ci_field_name": "txt_domain_name"

                    },

                    {

                        "s247_column_name": "TOTALRAM",

                        "ci_field_name": "txt_ram"

                    },

                    {

                        "s247_column_name": "BIOS_VENDOR",

                        "ci_field_name": "txt_bios_vendor"

                    },

                    {

                        "s247_column_name": "SERIAL_NO",

                        "ci_field_name": "txt_serial_number"

                    }

                ]

            },

            {

                "Monitor_type": "SERVER",

                "Monitor_sub_type": "WINDOWS",

                "ci_type_name": "ci_windows",

                "fields": [

                    {

                        "s247_column_name": "HOSTNAME",

                        "ci_field_name": "txt_hostname",

                        "type": "string",

                        "max_size": 100

                    },

                    {

                        "s247_column_name": "CPUCORES",

                        "ci_field_name": "txt_cpucores"

                    },

                    {

                        "s247_column_name": "FQDN",

                        "ci_field_name": "txt_fqdn"

                    },

                    {

                        "s247_column_name": "DOMAIN_NAME",

                        "ci_field_name": "txt_domain_name"

                    },

                    {

                        "s247_column_name": "NAME",

                        "ci_field_name": "txt_display_name"

                    },

                    {

                        "s247_column_name": "IPADDRESS",

                        "ci_field_name": "txt_ip_address"

                    },

                    {

                        "s247_column_name": "MANUFACTURER",

                        "ci_field_name": "txt_manufacturer"

                    },

                    {

                        "s247_column_name": "MODEL",

                        "ci_field_name": "txt_model"

                    }

                ]

            }

        ]

    }

Explanation

The following are the mandatory JSON fields:

Key
Value
site24x7Mapper

Monitor_type
Mandatory
Specify your Site24x7 monitor type, e.g., SERVER.
Monitor_sub_type
Specify the sub-type for your Site24x7 monitors. For server monitors, the sub-types can include Linux, Windows, etc. For network monitors, the sub-types can include switch, router, firewall, etc.
ci_type_name
Mandatory
Provide the ServiceDesk Plus Cloud CI type's API name to which data will be pushed.
s247_column_name
Mandatory
Provide the Site24x7 inventory or configuration field key.
ci_field_name
Mandatory
Provide the ServiceDesk Plus Cloud CI type's field key to which Site24x7 data has to be mapped.
e.g., Configuring it with the ip_address field (txt_ipaddress) will push the IP address field value to it.
type
Optional
Provide the data type of the configured field in ServiceDesk Plus Cloud, e.g., string.
max_size
Optional
Provide the maximum size of the configured field in ServiceDesk Plus Cloud, e.g., 100.

Notes
The below fields are mandatory for the JSON mapper: 
site24x7Mapper, Monitor_type, ci_type_name, fields, s247_column_name, ci_field_name