SNOW-CSA Reporting, SLA and Imports — All Questions With Answers

Refer to the exhibit.

Error log:
2024-03-15 14:32:10 (source) Import Set: sys_import_set_2c9a3b1e6f7a8d
2024-03-15 14:32:10 Transform: sys_transform_map_8d7e6f5a4b3c2d
2024-03-15 14:32:10 Target table: incident
2024-03-15 14:32:10 Field mapping: short_description <- co-paste(short_description, ' - ', caller_id)
2024-03-15 14:32:10 Error: Field 'caller_id' not found in source table
2024-03-15 14:32:10 Transform aborted.

Condition:
   state = 2
   AND category = 'network'
   AND assignment_group IS NOT EMPTY
   AND NOT caller_id = javascript:gs.getUserID()

Field Mapping:
   'short_description' -> 'description'
   'category' -> 'category'
Coalesce: 'number'

Report Condition:
   'active' = true
   'frequency' = daily
   'time_of_day' = '08:00:00'
   'roles' = ['itil']
   'state' = 'ready'

Refer to the exhibit.

[SLA definition configuration]
Table: Incident
Name: High Priority Response
Start condition: Priority = 1 AND State = New
Stop condition: State = In Progress OR State = Closed
Breach condition: Breach = (Create time + 1 hour)
Schedule: 8x5 (Monday-Friday 8:00-18:00)
Pause condition: (empty)
Reassessment: (empty)

Refer to the exhibit.

[Import Set Row XML]
<?xml version="1.0" encoding="UTF-8"?>
<import_set_row>
  <source>csv_import</source>
  <staging_table>u_import_incident</staging_table>
  <field name="u_number">INC001</field>
  <field name="u_short_description">Server down</field>
  <field name="u_category">Infrastructure</field>
  <field name="u_assigned_to">admin</field>
</import_set_row>

[Transform Map Log]
Transform started for source csv_import on table u_import_incident
Field mapping: u_number -> number (coalesce true)
Field mapping: u_short_description -> short_description
Field mapping: u_category -> category (script)
Script error: Cannot read property 'sys_id' of null
Field mapping: u_assigned_to -> assigned_to (direct)
Transform completed: 0 records created, 0 updated

Refer to the exhibit.

[SLA Context]
Task: INC001 (Priority 1)
SLA Definition: High Priority Response
SLA Instance:
  Start time: 2024-03-15 09:00:00
  Stop time: (blank)
  Pause duration: 0 seconds
  Schedule: 8x5
  Breach time: 2024-03-15 10:00:00
Current time: 2024-03-15 09:45:00

[Task State History]
09:00 - New
09:15 - On Hold (Pause condition met? Yes)
09:30 - In Progress (Pause condition released? Yes)
09:45 - On Hold (again)

Refer to the exhibit.
```
if (current.state == 2) {
    return true;
} else {
    return false;
}
```

Refer to the exhibit.
```json
{
  "transform_action": "insert",
  "target_table": "incident",
  "field_map": [
    {"source_field": "short_desc", "target_field": "short_description"}
  ]
}
```

Refer to the exhibit.
```
Error log: SLABreach: Condition not met for SLA on incident sys_id=123
```

Refer to the following transform map script:

(function executeTransformMap(source, target, log) {
    if (!source.u_employee_id) {
        return false;
    }
    if (target) {
        target.u_department = gs.getUser().getDepartment();
    }
    return true;
})(source, target, log);

{
  "name": "Critical Incident SLA",
  "table": "incident",
  "start_condition": {
    "condition": "priority=1"
  },
  "stop_condition": {
    "condition": "state=6"
  }
}