The DCM Blog

How to Improve Foundation Data with Examples

By Mikko Juola

February 2, 2023
Building a Strong Foundation

With the Common Service Data Model (CSDM) now recognizing the importance of Foundation Data, we decided to take a fresh look at our article from years ago. We originally published this article in 2019 and updated it a few times because Foundation Data remains relevant. Maybe more so now than ever before.

For us, it has always been clear that without a solid Foundation, you will not be able to enjoy the full benefits of your CMDB. This is as true in ServiceNow as in any other similar system. 

So – is your foundation in perfect shape? Do you really know?

Of course, it doesn’t have to be perfect, and it probably never will be with things in constant flux. Nevertheless, keeping your Foundation Data in good shape will ensure other things can work as expected.

 

What is Foundation Data?

 

What do I mean by Foundation Data? Many IT Service Management systems, such as ServiceNow, refer to common data tables shared between multiple applications, processes, or use cases as foundation data. Usually, this refers to users, organizational structures, cost centers, locations, groups, etc.

ServiceNow added Foundation Data into their Common Service Data Model (version 3.0) in late 2020. In the 4.0 version of CSDM, the Foundation data is shown below the other domains. And ServiceNow describes these as “Core data tables” in the platform.

Learn more about CSDM 4.0 version from our CSDM 4.0 webinar companion page.

 

CSDM and Foundation Data

Foundation domain in the CSDM 4.0 conceptual data model by ServiceNow.

Foundation data can create a foundation for good service automation, reporting, and management. You can get the most out of your investment on the ServiceNow platform with a strong foundation.

With a strong foundation, you can expect to get the most out of your investment on the ServiceNow Platform.

 

Example Foundation Data Model for Users

 

I will show you a data model for user and organizational data. I will then dive into some example use cases that can fail due to issues in foundation data. In the end, I will also tell you what you can do to prevent such problems.

Data Model for Users

Simple User data model with organizational structures, location, groups, and managers.

The example data model above is still relatively simple but includes lots of important and useful information about the user and its relationships to organizational structures, locations, groups, and managers.

 

Examples: When Incomplete Foundation Data Causes Failures

 

Approvals

Foundation data is often used for approvals. For example, a line manager can approve small purchases or orders. However, above a certain level, upper-level approval is required from the Department head, for example.

Let’s look at it through the data model. First, it’s obvious that if there is no reference between the user requesting approval, and the approving line manager, the request will fail.

Line Manager Approval

Line Manager Approval

The Manager information on User records can be invalid in many ways. Maybe it’s simply missing, or the selected Manager is no longer in the house and has been deactivated. Check out this article on how to catch people leaving and keep this data up to date.

It is no different for higher-level approvals. The same issues apply to high-level approval requests or some other, alternative and more complex approval logic. The difference from the data point of view is that now more details can be wrong. For example, the link between a User and a Department or a Cost Center usually contains multiple references that need to be correct for the approval to go through as expected.

Department Head Approval

Department Head Level Approvals

 

Reporting

 

Often, the most important reason for having consistent and up-to-date foundation data is to ensure reliable reporting. Most, if not all, activities managed within ServiceNow reference Users as Customers, Assignees, and Managers. Behind these Users, a vast array of other foundation data should be available to report different activities based on users’ organizational unit, location, or role within a company. Being able to report tasks, assets, and other essential information based on various organizational aspects is crucial to proper management and decision-making.

Reporting Structures

Organizational Structures are often used in Reporting.

I could bring up many examples related to reporting, but let’s leave it to this one for now and move on.

My other favorite reporting-related data model is Common Service Data Model and how a (technical) CMDB should be connected to services. But we already talk about that in many you can access from our CSDM Solution page. Also, check out our CSDM Content Pack.

 

Service Subscriptions

 

ServiceNow has excellent capabilities for managing users who use or subscribe to different services. When creating a Service Portal for your customers and end users, the Service subscriptions can play a significant role in how the portal works and which services and catalog items are available to the user.

Again, the portal may not work as intended if the references are missing or incorrect. We had a webinar called “CSDM 4.0 Examples for a Data-Driven Portal” a while ago to discuss this topic with Venni Mäkäräinen, from ServiceNow, based on a related article on the ServiceNow Community.

Subscriptions Failure

Users can subscribe to the services via many different routes. 

 

Roles and Permissions

 

Using Groups to manage the roles and permissions of users in ServiceNow is recommended. Group memberships can also impact licensing.

Making sure that users belong to the correct groups may take time and effort. However, using Data Content Manager, you can establish simple controls to ensure that certain users belong to at least some active groups and are connected to different roles.

Group Memberships

Users often get their permissions via group memberships.

 

Foundation Data is Important

From the use cases above (and many more not listed here), it is evident that Foundation Data is important. Furthermore, with Foundation Data displayed in the latest CSDM frameworks, it is clear that ServiceNow thinks so, too.

Therefore, organizations should put effort into keeping their Foundation Data up-to-date. When talking to our customers, we see increased interest in this. I suspect it has primarily to do with the inclusion of Foundation Data into CSDM (in version 3.0).

Please look at our CSDM Solutions page if you’re not already familiar with it.

 

Data Content Manager Helps Ensure You Have Quality Data

 

With Data Content Manager, you can quickly draw a Blueprint that matches the above data models. You can then run an audit against that Blueprint to check how accurate and up-to-date your current foundation data is.

DCM Blueprint for Users

Example DCM Blueprint for User data.

You can immediately use the audit results to understand your current situation and make informed decisions on how to improve the quality of your Foundation Data. Furthermore, the audit can automatically create tasks when deviations occur and assign them to responsible persons or groups.

This way, the quality of your foundation data will not degrade over time.

There’s an interesting article related to this in the ServiceNow Community that you may want to check: Operationalizing CSDM – approaching CSDM & foundation data considerations.

We have also described other user-related use cases in our blog, for example:

 

Take Control of Your Foundation Data

 

Thanks for reading. Next, I suggest that you watch our video: How to Improve Foundation Data in ServiceNow and CSDM. We talk about improving Foundation Data in detail and we show you how Data Content Manager helps.

Then, Book a Meeting with us, and we will give you a personal demo addressing your situation and challenges. We can also discuss the possibility of a Free Guided Trial in your own ServiceNow instance, with your own data.

There’s no cost or commitment, and if we do a Guided Trial together, the results are yours to keep. So don’t hesitate!

Additional CSDM Resources

We have written a lot on aligning with the Common Service Data Model and how Data Content Manager can help ease the journey.

Here are some excellent places to start:

Please reach out to us if you have any questions!

Mikko Juola

Mikko Juola

Chief Product Officer at Qualdatrix

LinkedIn

Built on now

Featured Posts

5 Challenges to Address for Better CMDB Data Quality

5 Challenges to Address for Better CMDB Data Quality

Comprehending the impact of CMDB Data Quality, especially its absence, can be difficult. It is a big problem since poor data quality is often the main reason ITSM systems, like ServiceNow, don’t meet expectations. We are deeply involved with data quality daily. Our...

How LapIT Improves CMDB Data Quality with DCM

How LapIT Improves CMDB Data Quality with DCM

LapIT designs and implements solutions for information and communication technology environment services in Northern Finland. Their customers are mainly municipal, public administration, and healthcare organizations. We interviewed Leena Broas, Development Manager at...

Video: How to Improve Foundation Data in ServiceNow and CSDM

Video: How to Improve Foundation Data in ServiceNow and CSDM

In this video, Pekka Korpi, CEO of Qualdatrix, and Mikko Juola, Product Owner of Data Content Manager, discuss the importance of Foundation data in ServiceNow and how it can be improved using Data Content Manager. Foundation Data in ServiceNow refers to the critical...

Build a Business Case for Data Quality Improvement

Build a Business Case for Data Quality Improvement

Accurate and reliable data is the backbone of any successful organization. Countless data quality improvement projects are started across organizations since poor data quality can lead to misinformed decisions, wasted resources, and lost opportunities. On the other...

How Metsä Group Improves Data Quality with DCM

How Metsä Group Improves Data Quality with DCM

Metsä Group uses Data Content Manager to improve data quality in their CMDB. We had a chance to interview Mika Lindström, the ICT Configuration Development Manager at Metsä Group. Thanks, Mika, for joining us. Metsä Group are an internationally operating frontrunner...

How to use CSDM to Improve Incident Management

How to use CSDM to Improve Incident Management

It’s been a while since this article was originally published, so I thought it would be time to update it to reflect changes to the CSDM model and our latest thinking. We published this article first in 2020 when ServiceNow’s Knowledge event included the first...

How CMDB Supports Regulatory Compliance at Danske Bank

How CMDB Supports Regulatory Compliance at Danske Bank

Data Content Manager improves data quality within an organization’s CMDB, reducing manual and disparate work for data quality maintenance. This increase in data transparency and ease of data management helps companies to achieve and maintain regulatory compliance,...

Get Started

Book a Call with us Now.

 

Explore how Data Content can enhance the quality of your data in ServiceNow. See how you can accelerate your CSDM journey and improve your CMDB or any data in your platform. All without the need for scripting, additional reports, or customizations.

 

Related Content You Might Like:

CSDM

The Recipe For Success eBook

Contents:
  • Establish Ownership & Roles
  • Manage Your Scope
  • Choose the Right Tools

We talk to people about CSDM alignment every day and constantly see organizations struggle with the same things over and over again. We wrote CSDM - The Recipe for Success to share our experiences.

It gives you hands-on guidance on some of the most important things you must address on your CSDM Journey, regardless of your maturity level.

CSDM The Recipe for Success eBook

Get Your Free eBook