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


---

# Managing Validations

# Managing Validations {#ariaid-title1}

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

Validation enables you to review and manage the imported data in the staging
table.  
Validations to be executed:

* Missing correlation id (Correlation id)
* Missing parent correlation id in case the type is Control module (Control module parent id)
* Missing serial number (Serial number)
* Missing transformed name (Transformed name)
* Missing MAC Address (validation is executed on column MAC Address 1)
* Missing type (Type)
* Missing rack number (Rack number)
* Missing slot number (Slot number)
* Equipment model entity path does not exist (Equipment model entity path)
* Site name provided is invalid (Site name)
* Validate duplicates on transformed name (Transformed name)  
  Note:  
  This validation is skipped for control modules.
* Validate duplicates on MAC Address (check on all MAC Address 1 columns)
* Validate duplicates on Serial number column (Serial number)
* Validate duplicates on Correlation id column (Correlation id)
* Validate duplicates on rack and slot numbers  
  Note:  
  This validation is only for control modules.
* Validate Has Module and Control module Parent ID  
  Note:  
  This validation is only for PLCs and control modules.
* Validate Invalid types - Compare against the default Excel type to OT device type mapping through the sn_otsm_sgc.SGOTAssetImportExtensionPoint extension point implementation.

  If you have additional
  mappings, create an extension point implementation for the base system sn_otsm_sgc.SGOTAssetImportExtensionPoint extension point.
{#managing-validations__ul_sjy_2dy_c5b}

For more information about adding a custom implementation for device classification, see [Add a custom implementation for device classification](https://servicenow-prod.fluidtopics.net/VkDuW7vMZwiwN6~nN8ZMuA "Customize the base system classification of an device based on the type, os_version, and firmware_version.").
* **[Run Validations](https://servicenow-prod.fluidtopics.net/EBaZ_u04xc_FJkaJU9J1CQ)**   
  Run validations on records to find missing, duplicate, and invalid data.
* **[Use OT staging tasks to remediate invalid records](https://servicenow-prod.fluidtopics.net/Mlp8O6JgoKbwMkZpOgij~g)**   
  Remediate invalid records in the SG OT Excel Stagings table by using Operational Technology (OT) staging tasks. Using OT staging tasks can help you track the invalid records that you need to fix.