Advanced Settings - Custom User Schema

You can use the Custom Devices schema and the Custom Users schema to add a JSON file that fetches information from one object to another, such as from a source or to enrich a device with information from a different object. You can add more than one JSON file.

Using Custom Schema Entries to Fetch Information from One Object to Another

The JSON file must be of the format:

{
        "type": "link",
        "link_type": "reverse_reference",
        "source_table": "u_computer_users",
        "source_field": "Software",
        "destination_table": "u_sn_cmdb_ci_class_configuration_item_has_users",
        "linked_record_identifier": "u_user",
        "link_to_field": "ax_local_accounts"
}

• link_type - The only supported type is reference.
• source_table - The type of the source object type in ServiceNow. This is the table that will be enriched from the data in the destination_table.
• source_field - The attribute of the object type from which the values should be brought. Enrich the contents of the source_table which has the same name as the value of the source_field in the destination_table, with the contents of the destination_table field.
• destination_table - The destination object type in ServiceNow from which the data will be imported.
• linked_record_identifier - The name of the attribute that identifies the object.

All of the above are mandatory.

It is not necessary to list all of the source tables; instead of listing all source_tables, it is possible to add “$ROOT” in the “source_table” field.

[
  {
    "id": "35452789AI",
    "type": "link",
    "link_type": "reference",
    "source_table": "$ROOT",
    "destination_table": "sys_user",
    "source_field": "u_user"
  }
]

For example, if the source table contains the field "owner", then the system fetches the object of the sort "user" for all of the tables. This will populate associated users for all source objects that have the field "owner".