Book Image

Learning ServiceNow

By : Sylvain Hauser
Book Image

Learning ServiceNow

By: Sylvain Hauser

Overview of this book

This book shows you how to put important ServiceNow features to work in the real world. We will introduce key concepts and examples on managing and automating IT services, and help you build a solid foundation towards this new approach. We’ll demonstrate how to effectively implement various system configurations within ServiceNow. We’ll show you how to configure and administer your instance, and then move on to building strong user interfaces and creating powerful workflows. We also cover other key elements of ServiceNow, such as alerts and notifications, security, reporting, and custom development. You will learn how to improve your business’ workflow, processes, and operational efficiency. By the end of this book, you will be able to successfully configure and manage ServiceNow within your organization.
Table of Contents (21 chapters)
Learning ServiceNow
Credits
About the Author
About the Reviewer
www.packtpub.com
Customer Feedback
Preface

Enforcing one-to-one relationships


On the topic of few things being impossible in ServiceNow, let's discuss one-to-one relationships.

Strictly speaking, a one-to-one relationship doesn't truly exist in ServiceNow. In database parlance, this would require that the right-hand table records have a primary key which matches the primary key of a record in the left table. Thus, you could have a left-hand record without a right-hand one, but could never have a right-hand record without the left-hand one.

That's interesting, but ServiceNow's Sys IDs are unique amongst all tables - and they have to be, because of the way ServiceNow's databases are structured on the back-end. Technically, ServiceNow has a flat database structure. In a sense, all records in the entire database are in one monster-sized table. This means that the primary key (Sys ID) for a given record really must be globally unique.

Okay, so we can't have one-to-one relationships in the usual way you might have them in an ordinary SQL...