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

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Operational Technology Management

ft:clusterId :

    - optm

bundleId :

    - optm

workflow :

    - Technology


---

# Validate imported staging records

# Validate imported staging records {#ariaid-title1}

Release version: Yokohama  
Updated July 23, 2025  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
Validate the imported staging records from your import task to find missing, duplicate, and invalid data.

## Before you begin

Role required: ot_excel_import_user

## Procedure

1. Navigate to AllIndustrial Workspace.
2. Select the List (![List icon]()) icon.
3. Under the OT Excel SGC - Import Task module, select one of the available lists.
4. Select the Import Task record that you want to validate.
5. Ensure you're the assigned to the import task so you can see the Validate UI action.  
   Note:  
   If you aren't in the Assigned to field of the import task, click the Assign to me UI action before proceeding with the next step.
6. Click the Validate UI action.  
   Once the validation process is complete, the State field of the Import Task record changes to Validation complete. The Validation state of the staging records created can update to one of the following values.
   * Valid
   * Invalid
   * Partially invalid

   {#run-validations__ul_gpq_smz_tfc}If invalid, the Validation comments field contains the cause or causes of the invalid state.

   If an imported staging record matches an existing configuration item (CI) in the CMDB, you can preview the existing OT records. For more information, see [Preview existing OT records in the CMDB](https://servicenow-prod.fluidtopics.net/V9HZbc43L~5lGpRP6Nwpjg "Preview existing Operational Technology (OT) device records in the Configuration Management Database (CMDB) before you import any new records from the staging table. By previewing existing records, you can avoid reconciling or merging unrelated records.").

## What to do next

For valid records, you can directly trigger the Configuration Management Database (CMDB) import. For more information, see [Trigger a CMDB import for valid staging records](https://servicenow-prod.fluidtopics.net/Rbprwb9lMnln8MfS6AYZGA "Trigger a Configuration Management Database (CMDB) import for your valid staging records to directly import them into the CMDB").

To resolve invalid or partially invalid records, you can optionally create remediation tasks. For more information, see [Create a remediation task for invalid staging records](https://servicenow-prod.fluidtopics.net/4C4P0Zcpt~jyqo_IAPbOPQ "After running validations for the Operational Technology (OT) device data imported with the Service Graph Connector for Microsoft Excel, optionally create a remediation task to resolve invalid staging records.").
* **[Managing Validations](https://servicenow-prod.fluidtopics.net/dsjwLbVX~t~N0F5p~JF3VA)**   
  Validation enables you to review and manage the imported data in the staging table.
* **[Preview existing OT records in the CMDB](https://servicenow-prod.fluidtopics.net/V9HZbc43L~5lGpRP6Nwpjg)**   
  Preview existing Operational Technology (OT) device records in the Configuration Management Database (CMDB) before you import any new records from the staging table. By previewing existing records, you can avoid reconciling or merging unrelated records.

*[\>]: and then