SAM Content Service tables

[Jason Nichols]

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.

[Ananth Srinivas]

Thank you. Really helpful. 

[Scott Delker]

Thanks, Jason.  Follow up question ... are some of those tables populated as part of core platform, some with SAM foundation, others with subscription-based plugins?  In our instances, we notice data in the first two but not all the others.

[Jason Nichols]

Hi Scott, the Content Service tables are bundled with SAM Professional. I can't say why you would see data in only some of them. The settings in the Content Service Setup module determine which data you wish to upload/share with ServiceNow. However, the download jobs are independent of these settings. You can check the scheduled jobs – they all begin with "Download Software Content", e.g., "Download Software Content: Product Lifecycles".

[Jason Nichols]

This table is also helpful: samp_cds_schedule_view. It lists all content download jobs, together with the current number of records downloaded.