Reporting, SLA and Imports

A company needs to import user records from a CSV file into the User [sys_user] table. The file contains a 'department' column that should map to the 'department' field in ServiceNow. However, the department values in the CSV are full names (e.g., 'Human Resources'), but the department field in ServiceNow uses a reference to the Department [cmn_department] table. What is the best practice for handling this import?

An administrator has configured a report on the Incident table showing the count of incidents by assignment group. The report shows data for the current week, but the numbers seem too low. The administrator suspects that incidents resolved before the current week are not being included. What should the administrator check first?

An organization has a Service Level Agreement (SLA) defined on the Incident table with a condition of 'Category is Network' and a duration of 4 hours. The SLA is triggered when the incident state changes from 'New' to 'In Progress'. A network incident is created and assigned to the Network Support group. The incident state is changed to 'In Progress' immediately. After 3 hours, the incident is resolved. However, the SLA shows a breach despite the resolution being within 4 hours. What is the most likely cause?

A company frequently imports data from an external HR system into the Employee [hr_employee] table using an import set. The import set runs nightly and maps fields correctly. Recently, the import started failing with the error 'Field 'manager' not found in table 'hr_employee''. The manager field exists in the import set rows but not in the target table. What is the most likely cause?

An administrator is creating a new report to show the average time to resolve incidents for the last quarter. They want the report to automatically update as new incidents are resolved. Which report type should they use?

An admin has set up an SLA on the Incident table with a condition 'Priority = 1' and a duration of 1 hour. The SLA is triggered when the incident state becomes 'In Progress'. The SLA definition includes a business schedule that only counts business hours (9 AM to 5 PM, Monday-Friday). An incident with Priority 1 is created at 4:30 PM on Friday and state is changed to 'In Progress' at 4:45 PM. At what time will the SLA breach if it is not resolved?

A manager wants a report that shows the number of incidents opened each day for the past 30 days, broken down by category. They want to see the data as a line chart with multiple lines (one per category). What report type and options should the admin select?

An administrator is setting up an import set to load data from a CSV file into the Incident table. Which TWO of the following are required steps in the import process?

A company uses SLAs on Incident records. They want to notify the assignment group when an SLA is about to breach (within 10 minutes). Which THREE actions can be used to achieve this?

An administrator is troubleshooting an import that is failing silently. The import set rows show 'Processed' with no errors, but no records are created or updated in the target table. Which THREE areas should the admin investigate?

A large enterprise uses ServiceNow for IT Service Management. They have a complex SLA structure with multiple SLA definitions on the Incident table. Each SLA definition has conditions based on category, priority, and assignment group. The company recently merged with another organization, and the new combined company has doubled the number of incidents. The SLA performance has degraded significantly: SLA breaches have increased by 40%, and the SLA engine is taking longer to process. The system administrator has checked the instance health and found that the SLA job is running but taking an average of 5 minutes per execution, and there are often multiple instances of the SLA job queued. The administrator needs to improve SLA performance without changing the business requirements. Which course of action is most effective?

A company uses SLA definitions with a time zone of 'US/Eastern'. A task is created at 10:00 PM Eastern on a Sunday. The SLA definition has a start condition that triggers on creation, a 4-hour duration, and a schedule that includes only weekdays 9 AM to 5 PM. What is the expected SLA state at 2:00 PM Eastern on Monday?

An administrator imports data from a CSV file into the 'cmdb_ci' table using a transform map. The import set row contains fields 'name', 'serial_number', and 'manufacturer'. The transform map has a field mapping for 'name' with a co-paste of 'name' and 'serial_number'. Another mapping for 'serial_number' uses a script to concatenate 'SN-' prefix. The 'manufacturer' field is not mapped. After the import, the resulting 'name' field contains 'Laptop123, SN-12345' and 'serial_number' contains 'SN-12345'. Which statement best describes the outcome?

A ServiceNow administrator needs to create a report that shows the number of incidents opened each month for the last 12 months. The report should display a bar chart with months on the x-axis and count on the y-axis. Which report type and grouping should the administrator use?

Which TWO of the following are valid ways to trigger an SLA in ServiceNow? (Choose exactly 2.)

A transform map for importing incidents uses a co-paste field mapping for 'short_description' that references the source field 'caller_id'. The import fails with the error shown. What is the most likely cause?

A large enterprise uses ServiceNow for IT Service Management. They have recently configured SLA definitions for incident management with a 4-hour resolution time during business hours (Monday-Friday, 8 AM to 6 PM, excluding holidays). The SLA is triggered when an incident is created with priority=2 and assigned to the 'Hardware Support' group. After one week, the IT manager notices that some priority=2 incidents assigned to 'Hardware Support' are not showing any SLA timer. Upon investigation, you find that the incidents were created on weekends and the SLA condition includes 'Assigned to group is Hardware Support'. The SLA definition has 'Start condition' set to 'State changes to In Progress' and 'Pause condition' set to 'State changes to On Hold'. The incidents were created with state 'New' and then assigned to the group, but they remain in 'New' state. How should you fix the issue so that the SLA starts correctly?

A company needs to import data from a CSV file into the User table. The CSV includes fields for first name, last name, email, and department. However, the import fails because some email addresses are invalid. Which feature in ServiceNow can be used to prevent invalid emails from being imported?

Which TWO are true about Service Level Agreements (SLAs) in ServiceNow?

Drag and drop the steps to configure an outbound email account in ServiceNow into the correct order.

Drag and drop the steps to create a new report in ServiceNow into the correct order.

Match each ServiceNow acronym to its full form.

Match each ServiceNow UI element to its description.

A ServiceNow administrator creates a new report showing incident counts by category. After sharing the report with the IT team, some users report they cannot see the report in their navigation menu. What is the most likely cause?

An SLA definition is configured to start when an incident's state changes to 'In Progress'. However, the SLA is not starting for incidents that are moved to 'In Progress'. The incident's assignment group is 'IT Support' and the SLA condition includes an additional filter: 'category = network'. What is the most likely cause?

An import set row fails with the error 'Coalesce field not found on target table'. What is the most common cause?

Which two actions should be taken to ensure a dashboard is visible to all members of the 'service_desk' role? (Choose two.)

Which three conditions must be met for an SLA to start automatically when a new incident is created? (Choose three.)

An import set row is being transformed but the target record is not updated. Which two possible causes should the administrator investigate? (Choose two.)

An administrator imports a CSV file into the incident table using an import set. After the import, several records are duplicated. What is the most likely cause?

A scheduled report is set to run daily but does not execute. What is the most likely cause?

An SLA is paused due to a pause condition. The administrator wants to permanently stop tracking SLA for a specific incident. What should be done?

An import set row shows as 'Error' with message 'Invalid table name'. What is the cause?

During an import, a transform field mapping uses a script to generate a value. The script runs but the target field is empty. What is the first thing to check?

An SLA definition has a duration of 8 hours and a schedule of 9am-5pm weekdays. An incident is updated to a state that triggers the SLA at 3pm on Friday. What is the expected breach time?

Refer to the exhibit. An SLA definition has the condition shown. An incident is created with state=2, category='network', assignment_group=null, and caller_id=user1. Will the SLA start?

Refer to the exhibit. An import set has a row with short_description='Test', category='network', and number='INC001'. The target table has an existing record with number='INC001' and description='Old Desc'. What will happen when the transform runs?

Refer to the exhibit. A scheduled report is configured as shown but does not execute. What is the most likely cause?

A service desk manager wants to create a report showing the number of incidents resolved within SLA for each assignment group over the last 30 days. Which report type should be used?

An administrator notices that a scheduled import set runs successfully, but the imported records do not appear in the target table. The import log shows no errors. What is the most likely cause?

A company has an SLA definition that starts when the state is 'New' and pauses when the state is 'On Hold'. A task is created with state 'New' at 10:00 AM. At 10:30 AM, the state is changed to 'In Progress'. At 11:00 AM, the state is changed to 'On Hold' for 30 minutes, then back to 'In Progress' at 11:30 AM. The task is resolved at 12:00 PM. The SLA has a 2-hour duration. What is the elapsed time used for SLA compliance?

A report is created but shows no data. The table and conditions appear correct. What is the most likely cause?

An administrator wants to create a dashboard with multiple reports that automatically refresh every 5 minutes. Which feature should be used?

An SLA is defined with a condition of 'Priority is 1' and 'State is not Closed'. A task has Priority=1 and State=New. The SLA starts. Later the task is assigned and Priority is changed to 2, then back to 1. What happens to the SLA?

Which import set transform operation should be used to prevent duplicate records from being created when the source data contains a unique identifier column?

A pivot table report shows 'Number' as the column and 'Assigned to' as the row. The 'Value' field is set to 'Count'. What does each cell represent?

An import set transform map has a field mapping that uses a 'Run script' action. The script sets a reference field by querying the target table. However, the import fails with a 'Null reference' error. What is the most likely issue?

Which TWO options are valid ways to schedule a report in ServiceNow?

Which THREE options are valid fields in an SLA definition?

Which TWO options are true regarding import set transform maps?

A high-priority incident is created on Monday at 16:30 (within schedule). The incident is assigned to an agent at 17:00. The state changes to 'In Progress' at 17:30. What is the SLA breach time?

Based on the exhibit, why did the transform create or update zero records?

At the current time (09:45), what is the total pause duration for this SLA instance?

A company needs to create a report that shows the average time taken to resolve incidents. Which report type would best fulfill this requirement?

An SLA is defined with a condition 'Active = true' but some incidents that are active are not triggering the SLA. What is the most likely cause?

An import set fails with error 'Import set row processing error'. The transform map uses a script that references a table that does not exist. What is the first step to resolve this?

Which role is required to create a report in the Reporting module?

A user wants to view a daily trend of incidents created over the past month. Which report type is most appropriate?

An SLA is breached, but the breach time appears incorrect. The SLA definition uses a business schedule that excludes weekends. The incident was created on Friday at 5 PM and breached on Monday at 8 AM. Why did the breach time not exclude the weekend?

In an import set, where is the staged data stored before transformation?

A manager wants to share a dashboard with the entire team without granting individual roles. What is the easiest way to achieve this?

An import set transform map includes field maps with script actions. The import fails with 'Script execution error'. Where should the administrator look first?

The SLA condition script above is used in an SLA definition. Standard incident states are: 1=New, 2=In Progress, 3=On Hold, 6=Resolved, 7=Closed. What is the effect of this condition?

The JSON above shows part of a transform map configuration. What will happen when an import set row containing a value in the 'short_desc' field is processed?

The error log entry above appears when processing an SLA for an incident. What does this indicate?

Which TWO conditions must be true for an SLA to start tracking on an incident? (Choose two.)

Which TWO data sources are commonly used to import data into ServiceNow via Import Sets? (Choose two.)

Which THREE elements are required when creating a new report in the Reporting module? (Choose three.)

A ServiceNow administrator wants to share a report with the Sales team. The Sales team members do not have direct read access to the underlying table, but they need to see the report results. Which action should the administrator take?

During an import, the source data contains duplicate records that should be ignored (not imported). The target table has a unique key field u_employee_id. Which configuration in the transform map will prevent these duplicates from creating new records?

An SLA is defined with a condition that triggers only when a field 'priority' is 1 or 2. However, some tickets with priority 1 are not getting SLA attached. What should the administrator check first?

A user wants to create a report that shows the number of incidents by category for each month. Which report type best achieves this?

After importing data, some records show as 'Ignored' in the import log. What is the most likely cause?

An SLA is defined to pause when state is 'Awaiting Customer'. The SLA timer continues to run even when the state changes to that value. What should the administrator check first?

A scheduled report is generated but not sending email notifications to recipients. What should the administrator check first?

When importing data, the import set table rows are not appearing after running the import. What is the most likely cause?

What is the effect of this script on the import transform?

Which TWO are best practices for creating dashboards in ServiceNow?

Which TWO elements are mandatory when defining an SLA definition in ServiceNow?

Which THREE factors can cause a transform to skip a row (resulting in 'Skipped' status in the import log)?

A large organization uses a weekly scheduled report to analyze incident trends. The report queries a database view that joins several tables. The report has filters: ((category=Network OR category=Database) AND priority<=2) OR (assigned_to in (specific group)). The report takes over 30 minutes to run and often times out. The administrator wants to improve performance without altering the report's output. Which action should be taken?

An SLA is defined for incident resolution with a 4-hour breach timer. The SLA should not count time when the incident is in 'Awaiting Customer' status. The administrator has configured a pause condition on the SLA definition. However, when the state changes to 'Awaiting Customer', the SLA timer continues to run. The administrator wants to troubleshoot the issue. What should the administrator check first?

A company imports employee data from an HR system weekly. The import set table always retains the data from previous imports, causing storage issues. The administrator wants to automatically delete the import set rows after a successful transform to free up space. Which configuration should be made?

An organization is importing help desk tickets from a legacy system using ServiceNow Import Sets. The import runs successfully, but no records are created in the Incident table. Which two steps should the administrator verify to resolve this issue?

A company uses Service Operations Workspace to manage incidents. They have configured an SLA definition for 'Resolution' with a stop condition when the incident state is 'Resolved'. However, the SLA is not stopping when the incident is resolved. The administrator checks the SLA log and sees that the SLA is still running. The SLA definition is active and attached to a specific SLA definition record. The administrator notices that the incident state is indeed set to 'Resolved', and the SLA timeline is set to 24x7. What should the administrator do to fix the issue?

A large import set of 10,000 user records from an HR system is failing intermittently during transformation to the sys_user table. Some rows are inserted successfully, but others show errors in the import log: 'Transform script error: null reference at line 15 of the transform map script.' The administrator reviews the transform map and finds a script that sets the department field by looking up a department table. The script assumes the department code always exists in the department table, but some records have codes that are not present. The administrator needs to ensure all rows are imported reliably, even if some data is missing. What is the best course of action?

A manager requests a report showing the average time to resolve incidents, grouped by assignment group, for the last month. The administrator creates a report on the Incident table using a bar chart with a 'Group By' on Assignment group and a 'Aggregate' on Resolved time (duration). The report displays an average that seems too low. Upon investigation, the administrator notices that incidents with very long resolution times (e.g., over 30 days) are not included in the report. The report filter is set to 'Active = false' and 'Resolved time is not empty'. The administrator suspects the time filter is incorrect. What is the most likely cause of the missing long-duration incidents?

A ServiceNow administrator needs to create a report that shows all incidents with a priority of '1 - Critical' that have been assigned to the 'Hardware' assignment group. The report should only include incidents that were created in the last 30 days. Which approach should the administrator take to create this report?

Refer to the exhibit. A ServiceNow administrator has created an SLA definition for critical incidents. Which TWO statements accurately describe the behavior of this SLA?

A ServiceNow administrator is responsible for importing data from an external HR system into the Employee table. The import set uses a transform map that creates new records and updates existing ones based on the employee number. Recently, the administrator noticed that some existing records are being incorrectly duplicated. The transform map is configured with a coalesce on the 'Employee Number' field. After reviewing the import log, the administrator finds that the import set rows are being processed, but the coalesce is not matching correctly. The HR system sends data with employee numbers that have leading zeros, but the ServiceNow employee number field is stored without leading zeros. For example, employee number '0123' in the source is '123' in ServiceNow. The administrator needs to fix this issue without modifying the HR system data. Which course of action should the administrator take?