batch-update command applies field values from a CSV or JSON file to all records matching an encoded query. Each row must include a sys_id column to identify the target record.batch-update
Batch-update records matching a query.
The
sn batch-update <table> <query> <file> [--dry-run] Batch-update records matching a query.
Arguments
| Name | Required | Description |
|---|---|---|
| table | Yes | The table to update. |
| query | Yes | Encoded query to filter target records. |
| file | Yes | Path to a .csv or .json file with field values. |
Flags
| Flag | Default | Description |
|---|---|---|
| --dry-run | — | Preview changes without applying them. |
Examples
sn batch-update cmdb_ci_server "environment=production" updates.csvBatch updating cmdb_ci_server...
✓ Updated 12/12 records
Done (1.8s)