Table of Contents

Introduction

CMDB tables will generally be available to anyone in ITS. ServiceNow's built-in web services enables the derivation of data service endpoints which, combined with knowledge of the data model, lets people and applications consume CMDB data for other purposes. This document defines:

• a set instructions for constructing URLs to identify the CMDB data and metadata exposed by Yale's ServiceNow instances
• a list of query operators for data filtering
• an explanation of the schema so users/agents can grok what they're pulling
• a list examples containing ready-made, commonly requested URLs

Obtaining a Service Account

If you want to do non-interactive batch work, you must obtain a service account. We generally hand these out by department or application. Request a service account by clicking here. Please be sure to:

• mention the department or application name
• route the request to the INF SN App Support group.

URL Building

ServiceNow's documentation for this is their wiki: https://wiki.servicenow.com/index.php?title=Navigating_by_URL. Yale specifics are below.

Server

URL construction begins with the instance names. Below are the instances by environment; generally, you will want production, pre-production, or testing for most purposes.

Tables

The next component is the table. The table name is used in API calls - note that table names in the schema don't always match the object's display name in the ServiceNow UI.

¹ technically, this is not a CMDB table as categories are not CIs in ServiceNow. Use of the available "CMDB" view is recommended for this table.

Query Construction

UI Constuction

• go to the application navigator (Left Pane, Configuration application)
• select the desired class (IT Provider Services, Applications, Modules, etc)
• when the list view appears, you can adjust the filter as desired (see the arrow at the left of the breadcrumb)
• when you have the correct query, right-click on the last term of the breadcrumb and click "Copy Query"
• urlencode this query (optionally, if you use the same steps and click "Copy URL" you will get the encoded query)

External Construction

Sometimes it's quicker to generate a long query with cut-and-paste or a script, especially if there are a lot of similar terms. In this case, you can use the primitives as documented by ServiceNow: Navigating by URL: Elements

Lists vs. Single Records

Filters

Views

Data Formats

URL Examples

Combine the querie with the desired instance name, along with the the https scheme, to get a URL.

CMDB Schema