The CreatorCon Call for Content is officially open! Get started here.

SAM Content Service tables

Jason Nichols
ServiceNow Employee
ServiceNow Employee

Below is a list of the content service tables available in Software Asset Management. These tables are located in your ServiceNow instance and are updated by the Content Service team. Looking at data in these tables is often helpful when investigating the normalization of discovery models, the retrieval of publisher lifecycle data, how software products are categorized for spending reports, etc.

 

Number

Table

Description

1

Software publishers

[samp_sw_publisher]

Software publishers

2

Software products

[samp_sw_product]

Software products, version agnostic.

Record indicates if software is subscription software, and licensable or not. Also contains normalized references to the UNSPSC product classification as well as the product category content service tables (see below).

3

UNSPSC Classifications

[samp_sw_product_classification]

The 8-digit United Nations Standard Products and Services Codes, a registry of codes for products and services.

4

Product categories

[samp_sw_product_category]

Product categories maintained by ServiceNow.

5

Software Product Definition

[samp_sw_product_definition]

Contains the Publisher Part Number. Can also contain the license type and license metric. References the entitlement definition (discovery map).

6

Discovery maps

(Entitlement definition)

[samp_sw_entitlement_definition]

Contains the specific version, edition, platform and language of the product.

7

Suite definitions

[samp_m2m_suite_entitlement_def]

Parent/child relations between discovery maps (software models).

8

Lifecycle data

[sam_sw_product_lifecycle]

 

Publisher lifecycle data.

 

9

Processor factors

[samp_processor_factor_map]

The processor factors used by Microsoft and Oracle license metrics.

10

Software product processes

[samp_sw_product_process]

The running process name for the software.

11

Content versions

[samp_content_version]

The content version (8-digit date stamp). All content service records reference the content version that they are part of.

12

Product maps

[samp_product_map]

Contains the product hash = publisher + display name/discovered product. Used for normalizing discovery models.

13

Package maps

[samp_package_map]

Contains the software package hash = publisher + display name/discovered product + version. Used for normalizing discovery models.

5 REPLIES 5

Vaibhav Sharma1
Tera Contributor

Please share same for HAM content service