Overview

---

There are three main tables that Services and Offering touch. The two main ones you will need for building a report are below.

 

Fields on Knowledge Related Tables

---

The two main tables that keep Service and Service Offering data are

cmdb_ci_service

and

service_offering

 

'cmdb_ci_service' is the genera table for Services and Service Offerings. There is not currently a dedicated table for Services, so all Service reporting needs to happen off of this table. If you don't filter correctly on your reports, you will show non-Service items, such as Service Offerings. Service Offering reporting can but doesn't necessarily have to happen on this table. 

When reporting for Services on the cmdb_ci_service table, you want to make sure that class is 'Business Service' and status is 'Operational' this will show only Services. If you want to report on offerings off of this table, change class to 'Service Offering' in your filter.

'service_offering' is the dedicated table for Service Offerings. It contains offering specific details that may be missing from cmdb_ci_service. Everything on this table is a Service Offering.

 

Notable cmdb_ci_service fields

Column label	Column name	Type	Reference	Max length	Reporting Notes
Aliases	aliases	String		40
Approval group	change_control	Reference	Group	32	Unused
Asset	asset	Reference	Asset	32
Asset tag	asset_tag	String		40
Assigned	assigned	Date/Time		40
Assigned to	assigned_to	Reference	User	32	Unused
Attributes	attributes	String		65000
Business contact	business_contact	Reference	User	32
Business criticality	busines_criticality	String		40
Business need	business_need	String		40
Business relation manager	business_relation_manager	Reference	User	32	Unused
Business Unit	business_unit	Reference	Units	32
Category	category	String		40
Change Group	assignment_group	Reference	Group	32
Class	sys_class_name	System Class Name		80
Comments	comments	String		4000
Company	company	Reference	Company	32
Compatibility dependencies	compatibility_dependencies	String		40
Consumer type	consumer_type	String		40
Correlation ID	correlation_id	String		512
Created	sys_created_on	Date/Time		40
Created by	sys_created_by	String		40
Delegate	service_owner_delegate	Reference	User	32
Delivery manager	delivery_manager	Reference	User	32	Unused
Department	department	Reference	Department	32
Description	short_description	String		1000
Details for Troubleshooting	u_details_for_troubleshooting	HTML		8000
Discovery source	discovery_source	String		40
DNS Domain	dns_domain	String		255
Domain	sys_domain	Domain ID		32
Domain Path	sys_domain_path	Domain Path		255
Due	due	Date/Time		40
Due in	due_in	String		40
Duplicate Of	duplicate_of	Reference	Configuration Item	32
End date	end_date	Date/Time		40
Environment	environment	String		40
Fault count	fault_count	Integer		40
First discovered	first_discovered	Date/Time		40
First-tier support group	support_group	Reference	Group	32	First tier support groups are set at the offering, not the Service
Fully qualified domain name	fqdn	String		255
GL account	gl_account	String		40
Has All Hidden Offerings	u_has_all_hidden_offerings	True/False		40
Has All Internal Offerings	u_has_all_internal_offerings	True/False		40
Install Status	install_status	Integer		40
Installed	install_date	Date/Time		40
Intended For	u_intended_for	List	Service Audience	1024
Invoice number	invoice_number	String		40
IP Address	ip_address	IP Address (Validated IPV4, IPV6)		255
Justification	justification	String		80
Knowledge Category	u_knowledge_category	Reference	Knowledge Category	32
Last review date	last_review_date	Date/Time		40
Lease contract	lease_id	String		40
Life Cycle Stage	life_cycle_stage	Reference	Life Cycle Stage	100
Life Cycle Stage Status	life_cycle_stage_status	Reference	Life Cycle Stage Status	100
Location	location	Reference	Location	32
MAC Address	mac_address	String		40
Maintenance schedule	maintenance_schedule	Reference	Schedule	32
Make Category Field Required	u_make_category_field_required	True/False		40
Managed By Group	managed_by_group	Reference	Group	32
Manufacturer	manufacturer	Reference	Company	32
Meta	u_meta	String		1000
Model ID	model_id	Reference	Product Model	32
Model number	model_number	String		255
Monitor	monitor	True/False		40
Monitoring requirements	monitoring_requirements	String		40
More Information	u_more_information	HTML		65536
Most recent discovery	last_discovered	Date/Time		40
Name	name	String		255
Number	number	String		40
Operational status	operational_status	Integer		100	Whether or not the offering is active
Ordered	order_date	Date/Time		40
OT device details	cmdb_ot_entity	Reference	OT Device	32
Parent	parent	Reference	Business Service	32
Phase	portfolio_status	String		40
PO number	po_number	String		40
Prerequisites	prerequisites	Translated HTML		65536
Price model	price_model	String		40
Price unit	price_unit	String		40
Product instance identifier	product_instance_id	String		255
Published Item	published_ref	Reference	Business Service	32
Purchased	purchase_date	Date		40
Rates	u_rates	String		40
Requires verification	unverified	True/False		40
Schedule	schedule	Reference	Schedule	32
Second-tier support group	u_second_tier_support_group	Reference	Group	32	Second tier support groups are set at the offering, not the Service
Serial number	serial_number	String		255
Service classification	service_classification	String		40	Do not report off of this, it is an outdated field. Use 'Class' to differentiate types of items.
Service Group	u_service_group	Reference	Application Service Group	32
Service level requirement	service_level_requirement	Translated HTML		8000	All offerings have the same SLAs and are reportable on the task_sla table
Service manager	managed_by	Reference	User	32	Unused, Services only need an owner.
Service owner	owned_by	Reference	User	32
Service portfolio	spm_service_portfolio	Reference	Service Portfolio	32
Skip sync	skip_sync	True/False		40
SLA	sla	Reference	Agreement	32
SMT	u_smt	Reference	User	32
Stakeholders	stakeholders	List	User	1024
Start date	start_date	Date/Time		40
State	state	String		40
Status	service_status	String		40
Subcategory	subcategory	String		40	Unused
Summary	unit_description	HTML		4000
Supported by	supported_by	Reference	User	32
Sys ID	sys_id	Sys ID (GUID)		32
sys_class_path	sys_class_path	System Class path		255
Taxonomy node	spm_taxonomy_node	Reference	Taxonomy Node	32
Total vulnerable items	total_vulnerable_items	Integer		40
Updated	sys_updated_on	Date/Time		40
Updated by	sys_updated_by	String		40
Updates	sys_mod_count	Integer		40
Used for	used_for	String		40
Users supported	user_group	Reference	Group	32
Vendor	vendor	Reference	Company	32
Version	version	String		40
Vulnerability risk score	vulnerability_risk_score	Integer		40
Warranty expiration	warranty_expiration	Date		40

 

 

Notable service_offering fields