Module 7: Manage Data Flashcards by Alice Cronk

The ServiceNow Infrastructure includes what 3 things?

Tables (contain records)
Records (correspond to rows in table)
Fields (individual piece of data in record and corresponds to column in table)

How well did you know this?

Not at all

Perfectly

The System Dictionary contains the definition for each and every table and field in a database.
Where do you navigate to, to find it?

All > System Definition > Dictionary

How well did you know this?

Not at all

Perfectly

What references and uniquely identifies a record? (32 characters)

sys_id

How well did you know this?

Not at all

Perfectly

Each field has 3 key attributes. What are they?

Field label
Field Name
Field Data (Value)

How well did you know this?

Not at all

Perfectly

What are the 4 ways that Tables can be related to each other?

One-to-Many (a field can hold a reference to a record on another table)
Many-to-Many (related in a bi-directional relationship)
Database Views (tables can be joined using Database Views plugin)
Extensions (extends another table)

How well did you know this?

Not at all

Perfectly

There are 3 One-to-Many relationship fields. What are they?

Reference Fields
Glide List
Document ID Fields

How well did you know this?

Not at all

Perfectly

What are the 3 classes of Tables?

Parent Class
Child Class
Base

How well did you know this?

Not at all

Perfectly

What does the Child Class inherit?

It inherits all fields of its parent, plus anything specific to the child class table.

The INCIDENT table extends the TASK table

How well did you know this?

Not at all

Perfectly

What are the Child Class Tables extended from the Task Table?

Incident

Problem

Change Request

How well did you know this?

Not at all

Perfectly

A Parent Class that is not an extension of another table is called a _?

Base Table (class)

How well did you know this?

Not at all

Perfectly

What are Core Tables?

Tables that exist in the base system (part of the initial SN installation).
Core Tables can be BASE tables and PARENT tables.

How well did you know this?

Not at all

Perfectly

What are Custom Tables?

Tables created by admins or developers

How well did you know this?

Not at all

Perfectly

What provides a graphical representation of other tables related to a specific table?

Schema Map.

It tells you what is a Child table, Parent table…

How well did you know this?

Not at all

Perfectly

Which users is the Schema Map available to?

personalise_dictionary

Admin

How well did you know this?

Not at all

Perfectly

Where are the 2 places you can go to create a table?

Tables Module
Tables & Columns Module

How well did you know this?

Not at all

Perfectly

A new table created in the Global scope will have what?

How well did you know this?

Not at all

Perfectly

A custom table created in custom app will have what?

How well did you know this?

Not at all

Perfectly

3 levels of security before an end user can perform CRUD on a table?

Access to platform/ login
Which applications & modules does the user have access to
Database access

How well did you know this?

Not at all

Perfectly

3 security modules typically used by System Administrator?

All > System Properties > Security
All > System Security > Access Control (ACL)
All > System Security > High Security Settings

How well did you know this?

Not at all

Perfectly

What is an Access Control?

A security rule defined to restrict the permissions of a user from viewing & interacting with data

How well did you know this?

Not at all

Perfectly

What are the ACL Rules?

CRWD (CRUD)
C - Create
R - Read
W - Write
D - Delete

How well did you know this?

Not at all

Perfectly

What does the Access Control List contain?

An instance’s Access Control rules

How well did you know this?

Not at all

Perfectly

What role is needed to maintain the ACL’s?

security_admin role

What does each Access Control rule specify?

A valid operation
The object being secured
The permissions required to access the object

Related to the ACL rule, What are the permissions required to access the object?

- Roles - Conditional Expressions - Scripts

Access Control Rule Types...

table.--None-- (applies to whole table) table.field (applies to only 1 field) table.* (applies to every field on a record without a table.field rule)

Using 'table.*'

- Used when denying the access (mainly) - Don't use when granting access

In what order are access controls evaluated?

Access to the table (most specific table rules to most general) Before evaluating access to the field (most specific to most general)

True or False. A user must pass both table and field ACL rules to access a record object

True

What is an Import Set?

A tool used to import data from various data sources, and map that data into ServiceNow tables

What roles are needed to manage all aspects of Import Sets?

Admin Import_admin

Data Sources are records in ServiceNow that contain information regarding an Import Set data source. Where can you import data from?

-From a local source (XML, CSV, EXCEL) -From a network server -From a file -A Lightweight access Protocol (LDAP) connection -Java Database Connectivity (JDBC) connection

True or False. An import Set Table acts as a staging area for records imported from a data source

True

Steps for importing data using an Import Set?

1. Load the data 2. Create a Transform Map 3. Transform the data 4. Clean up the import data

What are 5 different Data Sources?

1. JDBC 2. HTTP/ FTP 3. EXCEL 4. CSV 5. XML

What is a Transform Map?

A set of fields that define the relationship between fields in an import set table and fields in a target table. If a name is not the same... it will NOT map.

2 Tools used in Transform Map?

1. Automatic Mapping Utility 2. Mapping Assist Utility

Coalesce Fields

Coalescing a field mean the field will be used as a unique key during imports. It's always for Import Sets

What happens if a match is found using the coalesce field(s)?

The existing record will be updated with the information being imported

What happens if a match is NOT found using the coalesce field(s)?

Then a new record will be inserted into the database

Can you have more than 1 coalesce field?

Yes

What are the configurations you can use to coalesce data in Import Sets?

1. Single-field Coalesce 2. Multiple-field Coalesce 3. Conditional Coalesce

What is the Configuration Management Database (CMDB)?

A series of tables and fields that contain all of the Configuration Items (CIs) controlled by your company, as well as their attributes & relationships

What roles do you need to access the CMDB?

asset itil itil_admin cmdb_read

What are the 3 key CMDB tables?

1. Base Configuration Item [cmdb] 2. Configuration Item [cmdb_ci] 3. CI Relationships [cmdb_rel_ci]

What is stored in the CMDB?

Configuration Items

What ITSM processes is the CMDB used in?

Incident Management Problem Management Change Management Request Management

What is used as the central location to explore the CMDB class hierarchy, CI table definitions and Class CIs

CI Class Manager. All > Configuration > CI Class Manager

CSDM stands for what?

Common Service Data Model

What does the CSDM do?

- Identifies where to place the data - A way to make sense of the CMDB - CMDB based framework

ServiceNow Discovery

Is used to maintain and populate the CMDB. It finds the devices

ServiceNow Service Mapping

Tells us how they are related together

Dependency View

1. How to view the relationship between the CIs 2. Provides an interactive graphical interface to visualise relationships between configuration items

Which module is used as the first step for importing Data?

Load Data

Which option allows you to update existing target table records when importing data from an import set?

Coalesce

Which tool is used to determine relationships between field in an import set and an existing table?

Transform Map

Which ServiceNow product can be used to populate the CMDB?

Discovery