---
sourceDocument: Xanadu Operational Technology Management
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/operational-technology

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu Operational Technology Management

ft:clusterId :

    - optm

bundleId :

    - optm

workflow :

    - Technology


---

# System properties

# System properties that impact SG-OT Device Excel Import processing {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

The SG-OT Device Excel Import process depends on the following system properties for successful completion.

## sn_otsm_sgc.excel.fields.for.transformed.name {#system-properties-sg-ot-asset-excel-import__section_bb5_53x_qtb}

* 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.

{#system-properties-sg-ot-asset-excel-import__ul_i3p_cjx_qtb}

## sn_otsm_sgc.excel.transformed.name.delimiter {#system-properties-sg-ot-asset-excel-import__section_cg3_s1d_25b}

* 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.

{#system-properties-sg-ot-asset-excel-import__ul_yb5_t1d_25b}

## sn_otsm_sgc.excel.fields.for.validation.state.change {#system-properties-sg-ot-asset-excel-import__section_qkv_c5l_d1c}

* 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.
{#system-properties-sg-ot-asset-excel-import__ul_vmr_g5l_d1c}

## sn_otsm_sgc.enable.cmdb.validations {#system-properties-sg-ot-asset-excel-import__section_is1_p5l_d1c}

* 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.
{#system-properties-sg-ot-asset-excel-import__ul_fzz_p5l_d1c}