- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-10-2024 07:13 AM - edited 09-10-2024 07:20 AM
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.
Solved! Go to Solution.
- Labels:
-
Architect

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-11-2024 06:08 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-11-2024 02:32 AM
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
Asset | Computer (configuration item table) |
A financial representation of the device, including cost, ownership | An operational representation of the device, including software installed, operational status and config options |
Managed by - individual responsible for this asset | Managed by |
Company - organisation that owns the asset | Company |
Location - physical location of the asset | Location |
Department - which department owns the asset | Department |
Support group - which IT group supports the asset | Support 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) |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-11-2024 05:31 AM - edited 09-11-2024 05:40 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-11-2024 06:08 AM
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.