ServiceNow Hardware asset management key tables and their data model

VaranAwesomenow
Mega Sage

Hardware asset management key tables 

Introduction 

This document covers some of the key ServiceNow hardware asset management tables along with their screenshots and data models 

These tables play a key role in implementation of HAM solution. 

These data models are created based on Xanadu version of ServiceNow. 

Some of the images are doesnt render in word due to the size of those images, hence a link to high resolution images is provided here anilvaranasi/AwesomeNowScopedAppDesign: Provides design details of ServiceNow scoped apps

Table1: HAM Resource Categories 

HAM resource category table references sys trigger table. 

HAM Resource Categories | ServiceNow 

VaranAwesomenow_0-1742021137073.png

 

 

VaranAwesomenow_1-1742021137074.png

 

 

Table2: Asset (alm_asset) 

VaranAwesomenow_2-1742021137074.png

 

 

Table3: Hardware Model(cmdb_hardware_product_model) 

VaranAwesomenow_3-1742021137075.png

 

 

VaranAwesomenow_4-1742021137077.png

 

 

Table4: Service Catalog item 

VaranAwesomenow_5-1742021137078.png

 

 

VaranAwesomenow_6-1742021137079.png

 

 

Table5: Vendor catalog item (pc_vendor_cat_item) 

VaranAwesomenow_7-1742021137080.png

 

 

VaranAwesomenow_8-1742021137081.png

 

 

Table6: Request, Requested item, catalog task 

 

VaranAwesomenow_57-1742021205215.png

 

 

 

VaranAwesomenow_58-1742021205218.png

 

 

VaranAwesomenow_59-1742021205219.png

 

 

VaranAwesomenow_60-1742021205221.png

 

 

VaranAwesomenow_61-1742021205222.png

 

 

 

Table7: Stockrooms 

VaranAwesomenow_62-1742021205222.png

 

VaranAwesomenow_63-1742021205223.png

 

 

Table8: Consumables (alm_consumable) 

VaranAwesomenow_64-1742021205223.png

 

VaranAwesomenow_65-1742021205224.png

 

 

VaranAwesomenow_66-1742021205225.png

 

 

 

VaranAwesomenow_105-1742021271876.png

 

 

VaranAwesomenow_106-1742021271877.png

 

 

 

Table9: Expense lines (fm_expense_line) 

VaranAwesomenow_107-1742021271878.png

 

 

VaranAwesomenow_108-1742021271880.png

 

 

 

Table9: Transfer Order (alm_transfer_order) 

VaranAwesomenow_109-1742021271881.png

 

VaranAwesomenow_110-1742021271882.png

 

 

Table10: Transfer Order Lines (alm_transfer_order_line), Transfer Order Line task  (alm_transfer_order_line_task) 

VaranAwesomenow_111-1742021271883.png

 

 

VaranAwesomenow_112-1742021271884.png

 

 

VaranAwesomenow_113-1742021271885.png

 

 

VaranAwesomenow_114-1742021271886.png

 

VaranAwesomenow_116-1742021345793.png

 

 

Table11: Stock Rules (alm_stock_rule) 

VaranAwesomenow_117-1742021345796.png

 

 

 

VaranAwesomenow_118-1742021345797.png

 

 

VaranAwesomenow_119-1742021345798.png

 

 

Table12: Stock orders (sc_req_item) 

VaranAwesomenow_120-1742021345799.png

 

 

VaranAwesomenow_121-1742021345799.png

 

 

 

VaranAwesomenow_122-1742021345801.png

 

VaranAwesomenow_123-1742021345802.png

 

VaranAwesomenow_124-1742021345802.png

 

 

VaranAwesomenow_125-1742021345803.png

 

 

Table13: Subscription Contract (ast_contract) 

VaranAwesomenow_131-1742021432441.png

 

 

VaranAwesomenow_132-1742021432442.png

 

 

VaranAwesomenow_133-1742021432443.png

 

 

VaranAwesomenow_134-1742021432445.png

 

 

VaranAwesomenow_135-1742021432446.png

Table14: Assets covered (clm_m2m_contract_asset) 

VaranAwesomenow_136-1742021465653.png

 

 

 

VaranAwesomenow_137-1742021465665.png

 

 

 

VaranAwesomenow_138-1742021465666.png

 

 

Table15: Contract Rate card(fm_contract_rate_card) 

VaranAwesomenow_139-1742021465667.png

 

 

VaranAwesomenow_140-1742021465668.png

 

 

 

VaranAwesomenow_141-1742021465669.png

 

 

Table16: Deprecation (cmdb_depreciation) 

 

VaranAwesomenow_142-1742021482210.png

 

 

VaranAwesomenow_143-1742021482211.png

 

 

VaranAwesomenow_144-1742021482214.png

 

 

VaranAwesomenow_145-1742021482216.png

 

 

Table17: Fixed asset (alm_fixed_assets) 

VaranAwesomenow_146-1742021482216.png

 

VaranAwesomenow_147-1742021482218.png

 

 

All together 

VaranAwesomenow_148-1742021482218.png

 

 

High resolution images for data models are available anilvaranasi/AwesomeNowScopedAppDesign: Provides design details of ServiceNow scoped apps 

VaranAwesomenow_0-1742460750773.png

 

0 REPLIES 0