ITOM table details?

dataWrangler
Giga Expert

Greetings.

 

I've been a ServiceNow end user for a few years, but now have to map source data.  I have a solid background in database fundamentals, but no experience with the ServiceNow innards, other than mapping data I/O between ServiceNow and other systems (at the UI level).

ServiceNow has published the following CDMB table descriptions:
https://docs.servicenow.com/bundle/xanadu-servicenow-platform/page/product/configuration-management/reference/cmdb-tables-details.h...

 

Does anyone know if there's anything comparable for ITOM?

 

I ask because I've been tasked with mapping asset data from existing systems of record.  The mapping of hardware and (some) software data to CMDB seems reasonably straightforward.  However, the tables are *very* hardware specific, storing only what IT assets the organization has.

 

If there are tables for operational data, I'm not seeing them -- data that would answer such questions as "What OS version is on this laptop?",  "What's the latest security patch?", "Who 'owns'/is responsible for a given piece of hardware?"  Where is it physically located?"  "In what organization/department?"

 

Stated alternately, where does person, organization, location, and asset use (history) data reside?

Any & all insight welcome.

1 ACCEPTED SOLUTION

The typical application you'd use to do this is the Intune Service Graph Connector, which adds additional info on last logged in user / device compliance / last check-in date etc. Other connectors are available for other device management platforms eg Jamf but less familiar with those.

View solution in original post

3 REPLIES 3

Ryan Duce
Tera Guru

Worth bearing in mind first that ServiceNow has two records that model a laptop - an asset record, and a configuration item (CI) record. I would refer to this docs page and related pages for more information. Where fields are shared between the CI and the asset, the system keeps them in sync.

 

As for the specific information you mentioned, here is how I'd model it

 

AssetComputer (configuration item table)
A financial representation of the device, including cost, ownershipAn operational representation of the device, including software installed, operational status and config options
Managed by - individual responsible for this assetManaged by
Company - organisation that owns the assetCompany
Location - physical location of the assetLocation
Department - which department owns the assetDepartment
Support group - which IT group supports the assetSupport group
Comments / work notes - history of asset changes<No associated CI field>
<No associated asset field>OS version
<No associated asset field>OS Service Pack
<No associated asset field>Installed software (related list)

 

Thanks kindly, Ryan, for both the link and the useful cognitive handles.

Would I be correct in thinking, assuming that the correct product is licensed, that ServiceNow can also track history of a CI's use online (e.g. - 'When was a laptop last attached to the network?', 'What credentials were used gain access?').  I'm guessing that the product is not CMDB, because I don't see any tables listed in the ServiceNow list of CMDB tables that would hold pertinent data.

The typical application you'd use to do this is the Intune Service Graph Connector, which adds additional info on last logged in user / device compliance / last check-in date etc. Other connectors are available for other device management platforms eg Jamf but less familiar with those.