Review the system properties used by the Service Graph Connector for Microsoft Excel

  • Release version: Yokohama
  • Updated July 17, 2025
  • 1 minute to read

    • As an OT Admin or CMDB Integration Admin, view system properties related to the Service Graph Connector for Microsoft Excel.

    Before you begin

    View a filtered list of all the system properties that are used by the Service Graph Connector.

    Role required: cmdb_ot_admin or cmdb_inst_admin

    Procedure

    1. Navigate to All > Industrial Workspace Admin > OT Manager Admin > Import OT Devices - System Properties.
      The list shows records whose names begin with sn_otsm_sgc.excel.
    2. Review the following system properties.
      Table 1. Service Graph Connector for Microsoft Excel system properties
      System property Description
      sn_otsm_sgc.excel.fields.for.transformed.name

      • This property enables the user to provide the fields to construct the transformed name.

      • The field value or column names must be separated by comma.

        This transformed name is used as the name of the configuration item (CI) instead of the name field directly from the staging table. By default, the name field value is itself used as the transformed name value.

      • This property belongs to the sn_otsm_sgc scope and is automatically appended to this property name.

      • Requires the admin, cmdb_ot_admin, and cmdb_inst_admin roles for read and write operations.
      sn_otsm_sgc.excel.transformed.name.delimiter

      • This property specifies the delimiter to be used when computing the transformed name with more than one field or column value specified in the system property fields.for.transformed.name.

      • If only one column name is specified in the fields.for.transformed.name property, the delimiter is not used.

      • This property belongs to the sn_otsm_sgc scope and is automatically appended to this property name.

      • Requires the admin, cmdb_ot_admin, and cmdb_inst_admin roles for read and write operations.
      sn_otsm_sgc.excel.fields.for.validation.state.change
      • This property enables you to provide a comma-separated list of attributes so that their validation state is changed to Pending validation. The default value is Empty.
        Note:
        Changes to the identifier fields, such as Mac Address, Serial Number, Transformed Name, and slot number (for OT control modules), the validation state is changed to Pending validation.
      • This property belongs to the sn_otsm_sgc scope and is automatically appended to this property name.
      • Requires the admin, cmdb_ot_admin, and cmdb_inst_admin roles for read and write operations.
      sn_otsm_sgc.enable.cmdb.validations
      • This property enables CMDB validations for the staging devices. If set to True, staging devices are validated against existing CMDB CIs for reconciliation.
      • This property belongs to the sn_otsm_sgc scope and is automatically appended to this property name.
      • Requires the admin, cmdb_ot_admin, and cmdb_inst_admin roles for read and write operations.