You are currently viewing ServiceNow Data Management Overview

ServiceNow Data Management Overview

Hello,

Welcome to this blog of ServiceNow Spectaculars.

This article is dedicated to the processes and details about ServiceNow Data Management.

What is Data Management?

Data management is the process of classifying, arranging, conserving, safeguarding, and sustaining data throughout the course of its lifespan. This covers everything from gathering and entering data to analyzing and reporting on it to either archiving or discarding it when it is no longer required.

Accuracy, completeness, consistency, & security are key data Managment features. Various technologies & strategies work together to ensure proper data management.

Your ServiceNow instance manages and stores data in accordance with a set of guiding principles that administrators can analyze and customize. Importing, exporting, and archiving database data are among the data administration tasks, along with setting fields and tables.

How data is stored in ServiceNow?

  • All of the information in the instances is stored in tables, which consist of a series of records (rows).
  • The record in turn holds a series of fields that hold the individual bits of data and can be viewed either as a list or a form.

How ServiceNow table connect with other table(s)?

There are many ways a table in ServiceNow connect with other table. This feature make it easy to establish relationship among tables which finally help in maintaining meaningful relationship between two or more tables.

Extensions

  • A table can extend another table.
  • The table doing the extending (child class) includes all of the fields of the other table (parent class) and adds its own fields.
  • For instance, in above fugure the server table [cmdb_ci_server] extends computer table [cmdb_ci_computer] and computer table extends Configuration item[cndb_ci] table.
  • This extension helps in managing data & relationship is a better ways.

One-to-Many relations

  • One table can have multiple relationships with other table i.e. one to many relatiosnhips
  • It happens via when a field of table holds reference to a record of another table
  • For example:-
    • caller field of incident table hold reference of one user from user table
    • assignment group field hold reference of a group from assignment group table.
  • one to many relation can be accomplished by the following type of fields
    • Reference Field:- like called field above
    • Glide List:- Watch List field of incident
    • Document ID:- create a document ID field

Many-to-Many relations

Two tables can have a bi-directional relationship, so that the related records are visible from both tables in a related list.

Example:- one or more incidents can be related to one or more change requests and vice versa.

Database Views relations

Two tables can be joined virtually with Database Views to enable reporting on data that might be stored over more than one table.

Example:- Join incident to sla(task_sla) to report on things like incidents resolved by sla per incident category.

Leave a Reply