Overview

---

Hardware Assets use a combination of specific Hardware Asset tables as well as CMDB / CI tables. Most data is contained within the two tables below, but if you want most specific data (like contract data), you'd have to expand into more tables. Because there are 20+ tables touching CMDB or Hardware Assets, we are only showing the most used below. As our needs change or our usage changes, this page will be updated accordingly.

Fields about Hardware Assets

---

On this page:

Notable Fields on cmdb_ci_hardware

Notable Fields on alm_asset

 

Notable Fields on cmdb_ci_hardware

Display Name	Label	Element	Field Type	Reference	Max Length	Reporting Notes
	Attestation Score	attestation_score	Integer		40
	Attested	attested	True/False		40
	Attested By	attested_by	Reference	User	32
	Attested Date	attested_date	Date/Time		40
	Duplicate Of	duplicate_of	Reference	Configuration Item	32
	Environment	environment	String		40
	Life Cycle Stage	life_cycle_stage	Reference	Life Cycle Stage	40
	Life Cycle Stage Status	life_cycle_stage_status	Reference	Life Cycle Stage Status	40
	Managed By Group	managed_by_group	Reference	Group	32
	Created by	sys_created_by	String		40
	Created	sys_created_on	Date/Time		40
	Sys ID	sys_id	Sys ID (GUID)		32
	Updates	sys_mod_count	Integer		40
	Updated by	sys_updated_by	String		40
	Updated	sys_updated_on	Date/Time		40
Asset	Asset	asset	Reference	Asset	32
Asset tag	Asset tag	asset_tag	String		40
Assigned	Assigned	assigned	Date/Time		40
Assigned to	Assigned to	assigned_to	Reference	User	32
Assignment group	Assignment group	assignment_group	Reference	Group	32
Attributes	Attributes	attributes	String		65000
Can print	Can Print	can_print	True/False		40
Category	Category	category	String		40
Change control	Approval group	change_control	Reference	Group	32
Checked in	Checked in	checked_in	Date/Time		40
Checked out	Checked out	checked_out	Date/Time		40
Comments	Comments	comments	String		4000
Company	Company	company	Reference	Company	32
Correlation ID	Correlation ID	correlation_id	String		512
Cost	Cost	cost	Floating Point Number		40
Cost cc	Cost currency	cost_cc	String		3
Cost center	Cost center	cost_center	Reference	Cost Center	32
Default Gateway	Default Gateway	default_gateway	String		40
Delivery date	Order received	delivery_date	Date/Time		40
Department	Department	department	Reference	Department	32
Discovery source	Discovery source	discovery_source	String		40
Dns domain	DNS Domain	dns_domain	String		255
Due	Due	due	Date/Time		40
Due in	Due in	due_in	String		40
Fault count	Fault count	fault_count	Integer		40
First discovered	First discovered	first_discovered	Date/Time		40
Fqdn	Fully qualified domain name	fqdn	String		255
Gl account	GL account	gl_account	String		40
Hardware Status	Hardware Status	hardware_status	String		40
Install date	Installed	install_date	Date/Time		40
Install status	Status	install_status	Integer		40
Internet Facing	Internet Facing	internet_facing	True/False		40
Invoice number	Invoice number	invoice_number	String		40
IP address	IP Address	ip_address	String		255
Justification	Justification	justification	String		80
Last discovered	Most recent discovery	last_discovered	Date/Time		40
Lease ID	Lease contract	lease_id	String		40
Location	Location	location	Reference	Location	32
Mac address	MAC Address	mac_address	String		40
Maintenance schedule	Maintenance schedule	maintenance_schedule	Reference	Schedule	32
Managed by	Managed by	managed_by	Reference	User	32
Manufacturer	Manufacturer	manufacturer	Reference	Company	32
Model ID	Model ID	model_id	Reference	Product Model	32
Model number	Model number	model_number	String		255
Monitor	Monitor	monitor	True/False		40
Name	Name	name	String		255
Operational status	Operational status	operational_status	Integer		100
Order date	Ordered	order_date	Date/Time		40
Owned by	Owned by	owned_by	Reference	User	32
Po number	PO number	po_number	String		40
Purchase date	Purchased	purchase_date	Date		40
Schedule	Schedule	schedule	Reference	Schedule	32
Serial number	Serial number	serial_number	String		255
Short description	Description	short_description	String		1000
Skip sync	Skip sync	skip_sync	True/False		40
Start date	Start date	start_date	Date/Time		40
Subcategory	Subcategory	subcategory	String		40
Substatus	Substatus	hardware_substatus	String		40
Support group	Support group	support_group	Reference	Group	32
Supported by	Supported by	supported_by	Reference	User	32
Sys class name	Class	sys_class_name	System Class Name		80
Sys class path	sys_class_path	sys_class_path	System Class path		255
Sys domain	Domain	sys_domain	Domain ID		32
Sys domain path	Domain Path	sys_domain_path	Domain Path		255
Unverified	Requires verification	unverified	True/False		40
Vendor	Vendor	vendor	Reference	Company	32
Warranty expiration	Warranty expiration	warranty_expiration	Date		40

 

Notable Fields on alm_asset

Display Name	Label	Element	Field Type	Reference	Max Length	Reporting Notes
	Created by	sys_created_by	String		40
	Created	sys_created_on	Date/Time		40
	Sys ID	sys_id	Sys ID (GUID)		32
	Updates	sys_mod_count	Integer		40
	Updated by	sys_updated_by	String		40
	Updated	sys_updated_on	Date/Time		40
Account	Account	account	Reference	Account	32
Acquisition method	Acquisition method	acquisition_method	String		40
Active transfer order	Active transfer order	active_to	True/False		40
alm_asset			Collection		40
Asset tag	Asset tag	asset_tag	String		255
Assigned	Assigned	assigned	Date/Time		40
Assigned to	Assigned to	assigned_to	Reference	User	32
Beneficiary	Beneficiary	beneficiary	Reference	Company	255
Checked in	Checked in	checked_in	Date/Time		40
Checked out	Checked out	checked_out	Date/Time		40
Class	Class	sys_class_name	System Class Name		80
Comments	Comments	comments	String		4000
Company	Company	company	Reference	Company	32
Configuration Item	Configuration Item	ci	Reference	Configuration Item	32
Consumer	Consumer	consumer	Reference	Consumer	32
Cost	Cost	cost	Currency		20
Cost center	Cost center	cost_center	Reference	Cost Center	32
Department	Department	department	Reference	Department	32
Depreciated amount	Depreciated amount	depreciated_amount	Currency		20
Depreciation	Depreciation	depreciation	Reference	Depreciation	32
Depreciation effective date	Depreciation effective date	depreciation_date	Date/Time		40
Display name	Display name	display_name	String		255
Disposal reason	Disposal reason	disposal_reason	String		255
Domain	Domain	sys_domain	Domain ID		32
Domain Path	Domain Path	sys_domain_path	Domain Path		255
Due	Due	due	Date/Time		40
Due in	Due in	due_in	String		40
Expenditure type	Expenditure type	expenditure_type	String		40
GL account	GL account	gl_account	String		40
Installed	Installed	install_date	Date/Time		40
Invoice number	Invoice number	invoice_number	String		40
Justification	Justification	justification	String		80
Lease contract	Lease contract	lease_id	String		40
Location	Location	location	Reference	Location	32
Managed by	Managed by	managed_by	Reference	User	32
Model	Model	model	Reference	Product Model	255
Model category	Model category	model_category	Reference	Model Category	32
Old status	Old status	old_status	String		40
Old substatus	Old substatus	old_substatus	String		40
Order received	Order received	delivery_date	Date/Time		40
Ordered	Ordered	order_date	Date/Time		40
Owned by	Owned by	owned_by	Reference	User	32
Parent	Parent	parent	Reference	Asset	32
PO number	PO number	po_number	String		40
Pre-allocated	Pre-allocated	pre_allocated	True/False		40
Primary Contact	Primary Contact	primary_contact	Reference	Contact	32
Purchased	Purchased	purchase_date	Date		40
Quantity	Quantity	quantity	Integer		40
Request line	Request line	request_line	Reference	Requested Item	32
Resale price	Resale price	resale_price	Price		20
Reserved for	Reserved for	reserved_for	Reference	User	32
Residual date	Residual date	residual_date	Date		40
Residual value	Residual value	residual	Currency		20
Retired date	Retired date	retired	Date		40
Salvage value	Salvage value	salvage_value	Currency		20
Scheduled retirement	Scheduled retirement	retirement_date	Date		40
Serial number	Serial number	serial_number	String		100
Skip sync	Skip sync	skip_sync	True/False		40
Status	Status	install_status	Integer		40
Stockroom	Stockroom	stockroom	Reference	Stockroom	32
Substate	Substate	substatus	String		40
Support group	Support group	support_group	Reference	Group	32
Supported by	Supported by	supported_by	Reference	User	32
Vendor	Vendor	vendor	Reference	Company	32
Warranty expiration	Warranty expiration	warranty_expiration	Date		40
Work notes	Work notes	work_notes	Journal Input		4000