Module 6/7 Monitoring and Managing Data Flashcards
Which required tools are used to monitor performance in your instance?
Performance Dashboard
Extending Value
System Diagnostics page
Is used to look for root causes of platform performance issues
A Table
Is a collection of rows and columns (records and fields)
Reference Fields are identified with…
a reference lookup Icon (Magnifying glass)
Reference Fields refer to…
A record elsewhere, on another table
4 Table relationship
One-To-Many
Many-to-Many
Database Views
Extensions
One To Many relationship -
On an incident record, when you go to related records, there is a problem field. The reference to a problem record creates a one to many relationship, because several incidents may relate to that problem. From an incident we can’t indicate more than one problem for example.
Many to Many Relationship Definition…
When you create a record and then a role, and a group, these are all many to many relationships.
Groups and Roles are examples of (what type of relationship?)
Many to Many
Group VIew is an example of a…(record type)
Many to Many Relationship. Group member record has a single name (Sys_user_GRMEMBER), which has a large list of records, junctions between reference fields (Group and User)
Many to Many relationship Defined as
Two or more tables that can be related in a bi-directional relationship
Many to Many relationship Defined as
Two or more tables that can be related in a bi-directional relationship
One-to-Many relationship defined as
Within a table a field can hold a reference to a record on another table
Database Views are defined as
Tables that can be joined using the database views plugin (also known as a table join)
Table Extensions are effectively where…
When a parent table becomes the parent of a child table, that child table inherits all of the database structure (Columns, but none of the rows)
Task Table is a parent, base and core table (T/F?)
True
Core table Types
Incident
User
Task
Base Table Names
What does a Schema Map do?
Schema map provides a graphical representation of other tables related to a specific table
What colors are on the Schema Map? (THIS IS ON THE TEST)
Subject Table - Highlighted in Yellow
Blue Bars - Extend the subject table Further down the line (IE: Unix Servers would also have AIX, HPUX, etc.)
Red Bars - are referenced by the subject table
Green Bars - Extended Tables (all the way back to the base table) (IE: Unix Table would extend the CMDB, CMDB_CI, CMDB_CI_HW, CMDB_CI_COMPUTE)
One-To-Many relationship fields (3)
Reference Fields
Glide List
Document ID Fields
Common Many to Many example
Students and classes - A student can register for many classes, and a class can include many students.
What makes a base table different than a core table?
A bas table is not an extension of another table, and has no parent. A base table can also be considered a parent or core table depending on circumstance
Is CMDB_CI a base table?
No - This is a child and extension of the CMDB base and core table
CRUD - Stands for…
Create - Read - Update - Delete
Access Control is ….
a security rule defined to restrict permissions of a user from viewing and interacting with data
Access control is set at the….
Row and Column Level
Security rules can restrict your ability to view or run reports on a specific table (T/F)
True
When you become a security admin by elevating roles…
You need to log out before you lose those privilages
Access control rule specifies
Operations
Objects
Permissions
Permissions include
Roles
Conditional Expression
Scripts
Three Security Modules used by Sys Admin
Security
Access Control (ACL)
High Security Settings
When you create a custom table servicenow creates access control rules by default (T/F)
True - CRWD
When no specific ACL rule is defined then…
The rule applies to the whole table including all records
table.field ACL would define…
Rules applying to only one field in a record
table.*
This rule would apply to every field where there isn’t already a table.field rule
Table.none rule is the least specific rule, followed by table.field, and then table.*
By Default when a read access control has been established for a new table…
then assume there is complete access to all fields and rows on the table
ServiceNow starts from Generic to Specific security Policies (T/F)
False - ServiceNow goes from specific to general as they review security policies
A user must pass which rules to access a record object
Table First
Field ACL rule second
Record ACL rules are processed in the following order:
Match the object against table ACL Rules (Specific to general)
Match the object against Field ACL Rules (Specific to General)
If a user passes table ACL rules and not Field ACL rules, can they access a record object?
No, both rules must be passed in order to access the table
Should you grant a new role to an individual, or to a group for inheriting those roles?
Group is the best practice, it would be best to add a permission or ACL to a group, and then assign a user to that group
What are import sets?
Import set is a tool used to import data from various data sources, and map that data into ServiceNow tables
Import Set Tables are defined as….
A staging table prior to the transform label and pushing to a target table within the ServiceNow instance
A transform map is…
a set of field maps that define the relationships between fields in an import set table and fields in a target table
Coalesce field is…
A field or multiple fields that will be used as unique keys, the coalesce will override instead of update where there is a match
IF you don’t do coalescence, what will happen?
Data will just be treated as brand new records, and SN won’t look for a match. HUGE TABLES could result
Which roles can import data?
admin
import_admin
Data Source Imports can be accomplished through
Local Source (XML, CSV, Excel)
Network Servers (LDAP), or JDBC
What are the three main sources of data for import sets?
Local Data (excel, flat file)
Network (LDAP)
Java Database Connectivity (JDBC)
Key CMDB system tables are (3)
Base Configuration Item (cmdb)
Configuration Item (cmdb_ci)
CI Relationship (cmdb_rel_ci)
4 “parts” of the ITSM platform related to the CMDB
Incident Management
Change Management
Problem Management
Request Management
What are the benefits of an accurate and up to date CMDB?
Locate failed changes and associated INCIDENTS
Facilitate impact analysis of proposed CHANGES to reduce downtime
Assess PROBLEMS pertaining to specific CIs
Efficiently manage INCIDENTS affecting CIs and Services
What are the three elements of the CMDB Workspace
CI Search
CMDB Health
CI Overview
CIs managed by me
The strength of the dependency view are the…
relationships here, which are based off of records on a table
Common Service Data Model is NOT
A process or implementation guide
Not a set of reports
not code
not a sku or product to buy
not an automatic fix for broken implementations
CSDM Is…
Standard Terms
Best Practices
out of the box CMDB Core Tables
ServiceNow Discovery….
scans the network to inventory devices and applications to update the CMDB
ServiceNow Mapping…
Top Down discovery, augments the CMDB with IT relationships and dependencies between CIs and Models
Which module can you use to create a new table?
Tables
Tables & Columns
Which elevated role is required to modify access control rules?
Security_Admin
What does a CI?
Configuration Item (hardware, software, services etc.)
A parent class that is not an extension of another table is called
Base Table
In what order are access controls evaluated
Table Level - Specific to most general
Field Level - Specific to most General
What are the three key tables in the CMDB?
CMDB
CMDB_CI
CMDB_REL_CI