CSA Study Kit

ServiceNow Certified System Administrator study guide

  • Platform overview & navigation7%
  • Instance configuration11%
  • Applications for collaboration20%
  • Self-service & automation20%
  • Database management27%
  • Data migration & integration15%

60 questions in 90 minutes. Database Management alone is more than a quarter of the exam. Expect "choose two" and "choose three" questions; select exactly that many. Use this guide after completing the ServiceNow Administration Fundamentals (SNAF) course on ServiceNow University.

How to use this guide

This guide is a companion to the ServiceNow Administration Fundamentals e-book, not a replacement for it. Everything on the exam is covered in that book. Use this guide to check your understanding after each module and to review the details the exam covers.

Key point: boxes like this mark key facts to remember.

Do everything you read about in a Personal Developer Instance (PDI).

Client vs. server

Knowing where each script type runs helps you answer many questions.

Client side (the browser)

Controls forms and fields as the user works

  • Client Scripts (onLoad, onChange, onSubmit, onCellEdit)
  • UI Policies
  • Catalog Client Scripts and Catalog UI Policies

Server side (the instance)

Controls data no matter how it arrives

  • Business Rules
  • Data Policies
  • Access Control (ACL) scripts
  • Flows, Script Includes, transform maps
A UI Policy only affects data entered on a form. A Data Policy applies to forms, import sets, and web services alike.

2. Instance configuration 11%

Branding, properties, and plugins

System Properties > Basic Configuration UI16 controls the instance look, including: banner image, browser tab title, base theme, header background color, banner text color, module text color, and background and divider colors. System Properties > My Company holds the company banner image and banner text.

Users fix their own date and time display by setting their time zone in user menu > Preferences. Don't change the instance time zone for one person.

Plugins

Plugins add applications or functionality. Activate them from System Definition > Plugins (or All Available Applications).

  • You can't activate a plugin directly in production. Test it on a non-production or Personal Developer Instance, then request it for production through Now Support.
  • When a plugin depends on others, the system tells you before activation and activates the dependencies.
  • Once activated, a plugin can't be deactivated. Some offer demo data at activation.

Admin roles, high security, and impersonation

RoleGrants
admin (System Administrator)Access to all system features, functions, and data, because admins can override ACL rules and pass all role checks. For sensitive data such as HR records, ServiceNow recommends custom admin roles instead.
security_adminElevated role needed to change high security settings and ACLs. Activate it with Elevate Role from the user menu.
impersonatorLets a non-admin impersonate other users, but not admin users

Elevation lasts only for your current session. You can drop it two ways:

  • Uncheck the role: click your user profile icon (avatar) in the top-right corner, select Elevate Role, uncheck security_admin, and click Update (or OK).
  • Log out: log out and log back in, or wait for the session to time out. Elevated privileges reset automatically when the session ends.

Common security modules: System Properties > Security, System Security > High Security Settings, and System Security > Access Control (ACL).

Impersonation

  • Start it from the user menu in the banner. Use it to test what a user sees.
  • Return to your own account with End Impersonation.
  • Impersonation is logged when the glide.sys.log_impersonation system property is true.

Forms, fields, and UI Policies

ToolOpen it fromUse it for
Form LayoutContext menu > Configure > Form LayoutSlushbucket: add, remove, and reorder fields and sections
Form DesignContext menu > Configure > Form DesignDrag-and-drop designer; can also create new fields

Both can add fields and change field order. The Form Designer has three main parts: the page header, the field navigator, and the form layout.

  • Sections display as tabs (when the user has tabbed forms on) once you give the section a name.
  • To change a field's label, right-click the label and choose Configure Label, or edit it from Configure Dictionary.
  • Templates are opened from the form header's More options (…) icon.
  • Form Layout is the traditional slushbucket tool; Form Design is the drag-and-drop (WYSIWYG) designer. Both build form views, which can differ by persona.

Field types

NeedType
Free text with letters, numbers, special charactersString
Drop-down of predefined optionsChoice
Look up a record in another tableReference
CheckboxTrue/False
Date and timeDate/Time

UI Policies

A UI Policy is the no-code way to make fields mandatory, read-only, or hidden based on conditions. Example: make Resolution code mandatory when State is Resolved, and hide a checkbox unless the user has a role. UI Policies run on the client, after Client Scripts, and only for form interactions.

3. Configuring applications for collaboration 20%

Users, groups, and roles

ObjectDefinitionTable
UserA person who can log insys_user
GroupA set of users who share a common purpose (a team)sys_user_group
RoleA collection of permissionssys_user_role
  • Best practice: assign roles to groups, then add users to groups.
  • Roles can contain other roles, and groups can contain other groups.
  • Relationship tables: Group Member [sys_user_grmember] links users to groups, Group Role [sys_group_has_role] links groups to roles, and User Role [sys_user_has_role] links users directly to roles (possible but not recommended).
  • A persona (requester, fulfiller, approver) describes a user by the work they do. Personas are implemented with roles.
  • Manage users, groups, and roles in the User Administration application.
  • Setting up a new IT worker: create the user, then add them to each group whose work they'll do.

If an IT user only sees self-service, they're missing the itil role, usually because they aren't in a group that grants it. A manager sees nothing in My Groups Work if they aren't a member of those groups; being listed as the group's manager doesn't count.

Tasks, assignment, and the activity stream

Task work can be assigned to users and groups. Assignment rules automatically decide which group gets which kind of task.

Benefits of assigning to a group: members can pick work by SLA urgency or highest priority, and the group can route work by on-call schedule, skills, and availability.

  • The Activity section (activity stream) shows the most recent updates and the history of work on a record. Use its funnel icon to show only work notes.
  • On a list, the activity stream icon opens a frame with live updates for records you're watching.
  • My Approvals: right-click an approval in the list and choose Approve or Reject.

UI Actions

UI Actions add buttons, links, and context menu items to forms and lists.

Form UI ActionsList UI Actions
Form buttons, form context menu items, form linksList buttons, list context menu items, list choices, list links

Notifications

Notifications inform users about activity. They're created in System Notification > Email > Notifications and can be triggered by record inserts and updates or by events.

TabDefines
When to sendRecord inserted or updated, or event fired; conditions
Who will receiveUsers, groups, and users/groups in fields. Dot-walk from Caller to Caller.Manager to include the caller's manager.
What it will containSubject, message, and an email template for reusable content like a company banner

Reporting and Performance Analytics

Where you find reports depends on your release:

ReleaseWhere reports live
Latest releases (Platform Analytics)Platform Analytics > Library > Data Visualizations. Reports are now called data visualizations; click Create data visualization to build one. The same Library also holds Dashboards, Indicators, Filters, and Scheduled Export.
Earlier releases (classic reporting)Reports > View / Run to see the reports you can access, and Reports > Create New to build one

In either version you can also start a chart by right-clicking a list column header.

Report designer sectionPurpose
DataSource table or report source, and filters
TypeVisualization: list, bar, horizontal bar, pie, donut, semi-donut, speedometer, line, and more
ConfigureGrouping and calculations
StyleColors, titles, legend layout
  • Click Run to see changes without saving.
  • Best practice: copy a report before editing it, using the dropdown next to Save (Insert and Stay / Save as).
  • Reports on Service Catalog fulfillment of a specific item use Requested Item [sc_req_item].
  • Pull in data from a related table with dot-walking. If the same complex data set is reused often, give users a report source. If data lives in two tables and dot-walking can't reach it, create a database view.
  • Share reports with yourself, groups, or everyone; schedule them to be emailed; add them to dashboards.

Performance Analytics

Use Performance Analytics when you need data trended over time and forecast into the future, using scheduled snapshots, KPIs, and dashboards. Standard reports show the data as it is right now. Learn it through a Performance Analytics course on Now Learning.

4. Self-service and automation 20%

Service Catalog

BuildWhen
Catalog itemOne orderable good or service. Options such as color or RAM are variables.
Order guideSeveral related items ordered together in one request (new employee: laptop, monitor, phone, business cards)
Record producerA catalog form that creates a record in another table, like an incident from a "Get Help" item. Skips the request and requested item.
Content itemA catalog item that provides information (for example, a link or article) instead of a good or service
Variable setA reusable group of variables added to many items (four shared mandatory fields across 80 items)

Structure: a Catalog [sc_catalog] contains Categories [sc_category], which can have subcategories, and categories hold Catalog Items [sc_cat_item]. A company can have many catalogs. Shoppers use Self-Service > Service Catalog; admins use the Service Catalog application.

Use Catalog Builder to create and publish catalog items and record producers from templates (a template is a set of pre-made decisions that simplifies building an item).

RoleCan do
adminEverything in the Service Catalog, including related scripting (business rules, UI macros)
catalog_adminFully manage the Service Catalog application, without the scripting functions
catalog_managerUpdate a specific catalog they manage and assign its editors and managers
catalog_editorEdit a specific catalog and its categories and items
catalog_builder_editorCreate and maintain items in Catalog Builder using templates
  • Request flow: Request (REQ, sc_request) → Requested Item (RITM, sc_req_item) → Catalog Task (SCTASK, sc_task).
  • One request has many requested items; one requested item has many approvals and many catalog tasks.
  • When every catalog task for a requested item is complete, the requested item closes. When every requested item is complete, the request closes.
  • Control who can see an item with user criteria (Available for / Not available for).
  • One item needed in two catalogs? Create it once and publish it to both catalogs.

A manager approval is skipped when the requester's user record has no manager. When testing an approval flow: make sure the latest flow is active, impersonate the requester, and confirm the requester has a manager. On instances using legacy workflows, the approval threshold lives in the Service Catalog Request workflow.

Flow Designer

Flows automate business logic such as approvals, tasks, notifications, and record operations with little or no code. Open it from Process Automation > Flow Designer.

  • A flow starts with a trigger (record, schedule, or application) and a condition.
  • Actions do the work. Common core actions: Create Record, Look Up Record, Ask for Approval, Wait for Condition.
  • Each action's output becomes a data pill. Drag data pills into later steps to reference record data. If a later action changes a data pill's value, the new value is used for the rest of the flow.
  • Flows handle multi-level approvals with notifications at each level.

Advantages: less manual scripting, reduced technical debt, and smooth third-party integration through IntegrationHub spokes. Spokes are available from the ServiceNow Store. Process Automation Designer combines cross-enterprise workflows into one unified process.

Knowledge Management

Knowledge Management lets the organization create, categorize, review, approve, and browse information in one shared place.

  • Access is controlled with user criteria on the knowledge base's Can Read and Can Contribute lists. Articles can also have their own Can Read user criteria to narrow access further.
  • If a knowledge base has no user criteria, all users can read it by default. Newer instances can block this with a security property, so always set Can Read.
  • With Match All selected, a user must meet every condition (company AND department AND group).
  • Importing articles requires Can Contribute access.
  • Check a specific user's access with User Criteria Diagnostics.
  • Workflows control publishing and retiring articles. Article states: Draft, Review, Published, Retired.
  • knowledge_admin manages multiple knowledge bases; a knowledge manager owns a specific one.
  • Structure: a Knowledge Base [kb_knowledge_base] has an owner and a publish and retire workflow. It is divided into categories [kb_category]; a category belongs to one knowledge base. Each article [kb_knowledge] belongs to one knowledge base and one category.
  • Articles can include formatted text, images, video, and code, and can be written in the editor or imported from a Word document.
  • Feedback and continuous improvement: star ratings, helpful votes, comments, flagging an article, and creating an incident from an article.

Virtual Agent delivers help, knowledge, and common tasks through a conversational messaging interface.

Scripting basics

A Business Rule runs on the server when a record is displayed, inserted, updated, deleted, or when a table is queried. Its When options are before, after, async, and display. A Client Script runs in the browser.

5. Database management 27%

This is the largest domain. Practice building tables, relationships, and ACLs in your PDI.

Tables, fields, and relationships

A table holds records (rows); each field (column) holds one piece of data for a record. The primary operations on tables are create, read, write, and delete.

TermMeaning
Core tableShips with the platform (User, Task, Incident)
Custom tableCreated by you (u_ prefix in global; scope prefix such as x_ or sn_hr_ in a scoped app)
Base tableNot extended from any other table (Task)
Parent tableHas tables extended from it; may itself extend another table
Child tableExtends another table and inherits its fields

A table can't be both core and custom. Any other combination is possible.

Worked example: Incident extends Task, and Super Incident extends Incident. Task is a base and parent table. Incident is both a child and a parent. Super Incident is a child.

For a new app whose tickets get assigned to a team, extend Task and add your own fields, so you inherit assignment, state, and work notes.

Relationships

RelationshipExample
One-to-manyOne request has many requested items (a reference field)
Many-to-manyVendors sell many products; products come from many vendors. Related lists show on both tables.
ExtensionIncident extends Task
Database viewJoins two tables for reporting
  • Create tables with System Definition > Tables or Tables & Columns.
  • See a table's relationships with the schema map: System Definition > Tables, open the table, Related Links > Show Schema Map.
  • Dictionary tables describe the database itself: Table [sys_db_object] has a record for every table, and Dictionary Entry [sys_dictionary] has a record for every field. Dictionary overrides change a field's properties on a child table.
  • Every table and field has a name (used in code, no spaces) and a label (shown in the UI).
  • sys_id is the primary key on nearly every table. A reference field stores another table's sys_id.
  • A new custom table gets four ACLs automatically: create, read, write, delete.

Access Controls (ACLs)

ServiceNow is deny-first: ACLs don't deny access, they grant it under set conditions. ACLs are stored in Access Control [sys_security_acl] and managed in the System Security application. They mainly protect records and fields for each operation (create, read, write, delete), and can also protect UI pages, client-callable scripts, and processors. Permissions are set with roles, conditions, and a script that sets answer to true or false. Creating or changing an ACL requires elevating to security_admin.

NameSecures
incident.NoneAll records on the table (row level)
incident.*All fields on the table
incident.short_descriptionOne field

Let itil users create incidents: Name incident.None, Operation create, Role itil.

  • Table (row) ACLs are evaluated before field ACLs, so a user must have access to the table before field access is considered.
  • If a row rule and a field rule both apply, both must pass.
  • Table ACLs go from specific to general: the table, then its parent table, then the wildcard (*).

A user who can see a module but gets a blank page on Create New likely has read but not create access on that table.

Data Policies

Data Policies enforce mandatory and read-only rules on the server, for every way data arrives: forms, import sets, and web services. Use them for rules like "Short description is mandatory on insert everywhere" or "Number is read-only for all users." A Data Policy can also be applied as a UI Policy on forms.

CMDB and CSDM

TableRole
cmdbBase Configuration Item table, top of the CMDB hierarchy
cmdb_ciConfiguration Item table; CI classes extend it (cmdb_ci_server, cmdb_ci_computer)
cmdb_rel_ciRelationships between CIs
cmdb_rel_typeThe relationship types, such as Depends on::Used by
  • Defining suggested relationships between CI classes makes relating CIs easier, because the platform suggests which types fit.
  • The CI dependency view graphically shows a CI's infrastructure relationships. Right-click a relationship line and choose View Relationship Form; right-click a CI for options like View Form and View Related Tasks. Service desk agents use it to trace from a service to the CIs with active issues.
  • On a CI form, Related Items shows the other CIs it's related to.
  • Three ways to populate the CMDB: manual entry (always needed sometimes, but slow and error-prone), integrations that import data, and automated discovery (ServiceNow Discovery, Service Mapping, or third-party tools such as Microsoft SCCM). Each defined source is a discovery source.
  • The Identification and Reconciliation Engine (IRE) uses identification rules and reconciliation (data precedence) rules to match incoming CIs and prevent duplicates. Identification rules say which attributes uniquely identify a CI; reconciliation rules say which source is trusted at the record and field level.
  • CI Class Manager is the main tool for CMDB classes (a class is a CMDB table) and IRE rules.
  • CMDB Data Manager creates and manages CI policies. The CMDB Health Dashboard measures Completeness, Compliance, and Correctness. CMDB Query Builder queries CIs and relationships with drag and drop.

The Common Service Data Model (CSDM) is the standard, shared set of service definitions across ServiceNow products. It's the blueprint for mapping your IT services into ServiceNow and supports service-level reporting.

6. Data migration and integration 15%

Import Sets

Import data with the System Import Sets application. The steps are: load data, create a transform map, transform, and clean up the import set table.

  1. Load Data (first step) brings the source into an import set row table, the staging area.
  2. A transform map defines where incoming columns go on the target table (field mapping).
  3. Transform copies data from staging to the target.
Mapping toolWhen
Automatic mapping (Auto Map Matching Fields)Source and target field names match
Mapping AssistMap source fields to target fields yourself in a slushbucket-style interface

Coalesce fields are the unique key. Match found: the record is updated. No match: a new record is inserted. No coalesce field: every row is inserted as new, and nothing is updated.

A data source [sys_data_source] tells the platform how to connect to external data and load it into an import set table. Types include files (CSV, Excel, XML, local or from a network server), JDBC, LDAP, and REST. Target tables can be in the current scope, in global, or in other scopes that allow write access.

RecordTablePurpose
Data sourcesys_data_sourceWhere and how to get the data
Transform mapsys_transform_mapImport set table to target table
Field mapsys_transform_entryField-by-field mapping inside a transform map
Scheduled data importscheduled_data_importRuns an import automatically on a schedule

A robust transform is a more advanced transform used mainly for the CMDB: it can load several target tables and create relationships between the imported records.

Best practice: plan time before importing to clean out obsolete or inaccurate data.

Update Sets

Update sets capture configuration changes so you can move them between instances.

  1. Create a named update set and make it current.
  2. Make your changes, then mark the set Complete.
  3. On the target: retrieve, preview, then commit.
  • Never use the Default update set to move changes between instances.
  • Update sets carry configuration, not task or process data. Not captured by default: data records and homepages and content pages. Add a homepage manually (Homepage Admin > Pages, right-click > Unload Portal Page) or a dashboard with Unload Dashboard.
  • Keep update sets small to reduce conflicts and make changes easier to review.
  • Moving several at once? Batch them.
  • Move data with import sets or XML export and import, not update sets.

Table names to memorize

The exam asks for exact names. Type each one followed by .list in your PDI.

LabelTable
Usersys_user
Groupsys_user_group
Rolesys_user_role
Tasktask
Request / Requested Item / Catalog Tasksc_request / sc_req_item / sc_task
Catalog Itemsc_cat_item
Base CI / CI / CI relationshipcmdb / cmdb_ci / cmdb_rel_ci
System Properties / Business Rules / Client Scriptssys_properties / sys_script / sys_script_client
Group Member / Group Role / User Rolesys_user_grmember / sys_group_has_role / sys_user_has_role
Table / Dictionary Entrysys_db_object / sys_dictionary
Access Controlsys_security_acl
Catalog / Categorysc_catalog / sc_category
Knowledge / Knowledge Base / Categorykb_knowledge / kb_knowledge_base / kb_category
CI relationship typecmdb_rel_type
Data source / Transform map / Field mapsys_data_source / sys_transform_map / sys_transform_entry

Off the top of your head

Answer each question, then open it to check.

Insert vs. Insert and Stay?

Both create a copy of the current record. Insert closes the form; Insert and Stay keeps the copy open.

Which table holds a record for every table? For every field?

sys_db_object for tables, sys_dictionary for fields.

Open a big table's list without running the query?

Type table_name.filter in the navigator.

Three parts of a filter condition?

Field, operator, value.

Column search for "contains"?

Start the term with *.

Where do you find the update set picker?

The globe icon in the banner.

Role needed for high security settings, and how do you drop it?

security_admin, elevated for the session. Drop it two ways: open your user profile icon (avatar) > Elevate Role, uncheck security_admin, and click Update (or OK); or log out and back in, or let the session time out. Elevated privileges reset when the session ends.

How do you return from impersonation?

End Impersonation from the user menu.

Group vs. role?

A group is a set of users; a role is a collection of permissions. Assign roles to groups.

Where do you find reports in the latest releases? In earlier releases?

Platform Analytics > Library > Data Visualizations. Earlier: Reports > View / Run.

Report designer section for grouping? For colors and titles?

Configure. Style.

Trend and forecast data over time?

Performance Analytics.

Laptop, phone, and badge in one request?

Order guide.

Catalog form that creates an incident?

Record producer.

Same four variables on 80 items?

One variable set added to every item.

Why would a manager approval be skipped for one requester?

The requester's user record has no manager.

Where does action output live in a flow?

In data pills.

Knowledge base with no user criteria: who can read?

All users, by default.

Tool to check one user's knowledge access?

User Criteria Diagnostics.

Business Rule When options?

Before, after, async, display.

ACL to let itil users create incidents?

incident.None, operation create, role itil.

No-code mandatory field on forms only? On all data entry?

UI Policy. Data Policy.

Three key CMDB tables?

cmdb, cmdb_ci, cmdb_rel_ci.

Blueprint for mapping IT services into ServiceNow?

CSDM.

What happens with no coalesce field?

Every row is inserted as a new record.

Two things not in an update set by default?

Data records and homepages.

Moving several update sets at once?

Batch them.