The CreatorCon Call for Content is officially open! Get started here.

Ask the Expert: CMDB Basics with Steven Bell, MVP

Lisa Latour
Administrator
Administrator

CMDB is always a HOT TOPIC!

Now's your chance to ask Steven Bell, Accenture & Community MVP, your CMDB questions.
 
The Configuration Management Database in ServiceNow is the core repository for Configuration Items. The following topics will be covered:

1. CMDB Table Structure
2. Field Inheritance
3. What is a CI?
4. CI Relationships
5. Classification of CIs
6. Useful tips when creating CIs
7. The use of CIs in ITIL, and in Discovery

 

Join us on this discussion to watch the presentation and
Post your questions  (Video Below)

Featured Expert

Steven Bell is an Architect Manager and ServiceNow Trainer for Accenture Cloud-First.   He has over 30 years of Developer experience.   His areas of expertise include Application Development, Development Process, Orchestration, Discovery, Asset Management, Software Quality Assurance.   Steven's prior experience includes web services development in C#/.Net.   He earned a BS in Computer Science from Texas Tech University - Lubbock.

Have your questions ready to post below on this discussion page.

And Please Let our Expert Know how they've helped! Comment Below!

Find more Expert Events Visit "Learn from Experts"

To increase resolution : click the "cog" icon and change to 720HD

Originally recorded February 5, 2019

RESOURCES

Steve’s Article List

Community Code Snippets: Articles List to Date

https://community.servicenow.com/community?id=community_blog&sys_id=289d6a69dbd0dbc01dcaf3231f9619f0

 

1 ACCEPTED SOLUTION

JA:

There are a couple of approaches to this:

1. From the Asset table (Hardware, etc) look for all records with an empty cmdb ci field.  Those will not necessarily have an analog in the CMDB table.

2. From the CMDB tables look for all records with the Asset field not filled in.  Those will likely not have an analog in the Asset tables.

Not all assets will generate CMDB records automatically and visa-versa.  It depends on how your Model Category table is configured.  It also depends on when it was implemented.

This kind of diff reporting takes patience and time.  There is no quick process for this.

Steven.

View solution in original post

19 REPLIES 19

Greetings Steven, one point wanted to clarify when you say 'Not all assets will generate CMDB records automatically and visa-versa', and while agreeing on this comment shouldn't there a Business Rule be triggered every time an ASSET or CI impacting respective table, to automate ASSET & CI compliment each other?

yeskaytee
Kilo Contributor

Hello Steven, is there any automated way to upload CIs into cmdb.

We often get requests to add one/two/few or many CIs at once to the cmdb table.

And these requests come from different teams....server, network, Enterprise application. Which means the  they should be loaded to different tables depending on the class. And each table (class) will have their own custom fields defined.

ServiceNow admin team end up doing these tickets manually thus wasting a lot of time and resources.

How can we automate trough a simple form the upload capability depending the class they want to load data to.

We want each team to have their own automated way to upload and maintain their own data. Few checks we want to put in place is no duplicate CI name. And result summary after each upload on inserts, updates and ignored(due to duplicate name).

 

one way to do it:

extract the Excel template from ServiceNow and have the teams fill in the fields, then you can import it to the table.

Go to the target table
Click on the column menu
find_real_file.png 

Select "Import"

find_real_file.png

When the team sends the excel sheet you can import it and get the job done in a short time.
It can be automated.

You can certainly do so, with various approaches:

     1. if you have DISCOVERY running, utilize schedules by groups/IP segments/Departments, etc...

     2. You can use Import / Transform Maps with relationships Business Rules Trigger everytime an import to certain CI Tables.

     3. Leverage New York+ DISC/CMDB Features to easily adopt & maintain CMDB.

 

Good luck.

Mary Vanatta
Kilo Guru

Are you planning to update to align with CSDM 2.0?