[Music] in order to subscribe to my channel please click here or click here please share comment and like my videos and channel hello guys welcome to SAS word service now this is service now system administrator training and this is part 11 this training have been recorded in Orlando version of ServiceNow before we start the training let me show you the topics of this complete training in this eleventh part of the training we will talk about CMDB in ServiceNow but before I start the session let me make a note here that this is not a complete training on CMDB CMDB is very vast and service now we will just provide the information that what exactly the CMDB is which can be utilized for this course as part of ServiceNow administration configuration management database that is CMDB in this section we will learn about CMDB in ServiceNow CMDB tables and structure CI and relationships CI dependency view and CI cross manager we will also try to just edit some or configure some configuration items in my personal developer instance and we will also see that how exactly you can utilize CMDB items in different tasks or records what is CMDB CMDB is configuration management database it is a series of tables and fields which stores information about configuration items managed by organizations it also stores information about relationship between different CIS that is configuration items what is configuration item CI is a tangible or intangible device or application in CMDB example computers servers business service a database instance the laptop or computer you get from your company it is a configuration item a server on which you work upon it is a configuration item application you use in your organization that is a configuration item CMDB application so original has this out-of-the-box application to manage CMDB that is called configuration and you have lot of modules under this application which you can utilize to manage CMDB data in your organization this is my personal developer instance you need to go to application navigator and type configuration and you will type configuration and just come little bit bottom you will see this application and that is the application where you can manage your CMDB it has various modules as you can see here like CI class manager CMDB herbs CMDB query builder lot of modules are there to manage your CMDB data CIA form a CI record contain information about a CI the first field we have is name that is the name of the CI that is the configuration item you have you will mention the name over here then you have asset tag it's kind of a unique tag for all CIS you have in your organization then we have manufacturer which shows the company who has many secured that particular CI then you have asset here you mentioned the associated asset you have in your asset management table where you track all your assets that's what you can mention here then you have class now this is something that which class the CI belongs to that is something you can define here then you have company the company is something that which customer has this particular CI then you have serial number model ID and then assign tube which is kind of a primary person responsible for this particular CI then we have comments I mean if you want to provide any kind of comments you can mention here for this particular CI then we have configurations so this section shows the configuration of that CI and you can see different fields we have like hostname OS domain operating system os service desk dns domain IP address these are the configuration of a particular device that is something you can define here all the configuration you have for a particular CI that can be defined here and the next section we have is related items now in this section you can see the related items that means all those CIS which are related to this particular CI you can see in this particular section CI dashboard view you can also see more details about a CI by a dashboard view it shows that how much healthy your CI is as for the metrics defined related CI and tasks associated with the CI as well are shown you can see like we have an exactly some changes were happened you have completeness you have compliance correctness is the CI stale that mean it have stale data it was not updated may be within a specific time it has some relationships as well you can see it shares relationship for matters then you have the bottom you see it says change incident tasks there whatever tasks associated with the CI that you can see the list here as well Keith CMDB tables so cm TB has three key tables the first table is base configuration item which is the main parent table of whole CMDB then we have configuration item which is extended from base configuration item and then the third main table we have as CI relation which source data related to the relationship between different CI rackets CMDB table hierarchy so let's understand that how CMDB tables are structured the base main table of CMDB is base configuration item which extends another table that is configuration item so that is also one of the base table and then we have tables like hardware or application and there are many other applications or tables you have which are also called as CMDB classes now these classes accent other CI classes like you have computer and for application you have application server you can extend like there are different classes there are different extended classes as for the I think categorization you have for that particular CI that's that's how you divide you categorize these classes into into into different categorizations so that you can have preferred defined classes as part of CMDB in ServiceNow usage of CMD be when you have proper CMD BCI's in ServiceNow then you can use these configuration items for the creation of different records like incident problem request that means these particular items they are related to configuration items these all records these tasks which we are talking about incident change problem or request they are related to configuration items that's something you can define how exactly you can define so you can see on incident form in which CI is selected which means there is an issue related to this particular CI now this helps agents and IT users to fix the issues effectively in the organization sim you have configuration item on problem form and you have configuration item to be selected on change form as well see i dependency view dependency view display graphical infrastructure view of a CI and all others CI connect all related to a CI it also indicates if there is some existing issue or alert for a CI so when you see the dependency view it shows you the graphical infrastructure view where you can see that one particular CI is connected to different C eyes if there is a connection and you can see that if there is some issue existing issue in a particular CI now how this da CI dependency view will be used in in real real world so for example if you have an application it is it is down now that application might have some up streams maybe it should have some down streams so in that case one of the upstream of a downstream they are getting some data may be upstream application may be they have some issues so how would you see that you can see that in this particular view that what all connection connected applications are impacted as of now maybe there is a server impacted maybe there's a multiple issues for a server maybe application server is impacted or any any database instance is impacted that is something you can see here in dependency view next is CI class manager CI class manager displays the entire CI class available in the instance in helical structure like tree showing all CI class definitions in one place so whatever classes you have so whenever you define different classes that is something didn't see NCI class manager you can manage as well and that's what it says it is easier way to view modify or extend a CI class that's an easier way to to provide if you want to modify your classes that is something you can do in via CI class manager and it is really helpful so let's see all these elements which we talked about in my personal developer instance let me show you that how you can utilize CMDB and what is the usage of CMDB so if I go to incident application under incident application if I click on create new and I try to create a new incident so when I when I try to create a new incident it will ask me to information here one is service and configuration item as of now this is not mandatory however in organizations when you implement incident management I think configuration item should always be mandatory but not for end users because end-users they don't know what kind of configuration item it is but if I talk about IT users it should be mandatory so in that case here is the field we have configuration item and another field we have service now both the fields they are targeting to CMDB tables CMDB classes however configuration item shows all the configuration items you have in your instance so if I click on that search icon you can see these are all configuration items regardless of the classes that mean it shows all the classes I can select any computer I can select any server software everything I can select so let's say there is an issue maybe I have this Abkhaz client I have an issue with this particular software so in that case I can just type this down and I can say AB caste is not working it is an issue because if I will just create a random incident for example if I'm not using I'm just I'm just removing this from here and I'm just putting any name here let's select any random name if I just click on save in this case whomsoever person will get this incident he will not be able to identifier and he will not be able to get more details so it's really important you have to select that which configuration item is impacted because I think this will be really useful for everything for reporting purpose I know you can still mention in short description but if I ask that how how how many tickets you got for this particular CI that is how you can get it from here maybe it might happen and that's what you do in service now with the help of CI whenever I select any CI it gets assigned to the primary group maybe that that lot of organizations they do that so in that case if I will just mention the application name in short description in that case I won't be able to reroute it or route it automatically but if I will select configuration item and that application will be available here I select it and incident will be automatically routed that is also you can kind of implement in your ServiceNow instance and I think ServiceNow also provides that kind of feature out-of-the-box but as of now I think it's not enabled you have to you have to apply that feature but ServiceNow if you if you go to service not documentation you will find that feature so as I mentioned here you have a configuration item so I can select that application that configuration item so it can be a server it can be an application whatever classes we have now what are those different classes we have so if I go to configuration item let's in let's say configuration so I go to configuration application and if I go to let's say from here application now these are all applications or all this is definitely extending from CMDB so you can see these are all applications you have so if I right click and see the table let's see which table it is so it should be a CMDB application table so you can see it's an application table however it is extending from configuration item that means it is one of the class you have in your instance that is application and you can create different applications if I click here you will see these are the applications we have if I go a little bit bottom you will see different categories like you can have application servers you can have servers clusters database I think different category of devices you have in the organization or in the whole world having that which is used in different organizations that is what ServiceNow has provided you those classes those categorizations out of the box I think directly from ServiceNow you don't have to create it but it might happen as part of your implementation in your organization sometimes organizations they you they do use their own classes custom classes so that's totally up to you what is recommended what is not I'm not going to tell you in this particular session because there's just about the glimpse of CMDB so here you can see we have this like all database catalogs you have you have network devices like networks services you have load balancers data centers infrastructure services as well like email FTP these are all different classes you have and their data and you can define you can mention these these configuration items in different records as I mentioned like incident change problem now let me open one of the configuration item maybe let me open this one alternate SMTP it is kind of a IP service or maybe let me open really I think which will have more fields maybe so I will open maybe a server let me open a server so we have this Windows Server so I am I'm opening this or Windows Server let me check what all details it has yep it's opens ok so you can see these are the details which we were talking about like name as a tag all the configuration how much RAM is there on this server CPU speed what kind of operating system so that is the configuration you can see here you have related items now if you before that I showed you two views one is the form view this is the one and then you have dashboard view in dashboard view you can see different details more details about the health check of this particular CI whether your CI is healthy is there any relationships for matter do you have any stale data any compliances there completeness relationship you can see we have a lot of these change records we have I think no no incident records if I click on task you will get me with these tasks these fi are rackets as well so how many how many records are associated with this configuration item that is something you can see here so if I open this again and so here we have related items you can see the different items which are related to this now these are also see I is like you can see receives data from mass storage devices here you have VM SD for now this should be a CI if I click on it you will see this will open a CMDB CI server it's kind of it's another server you have for the same similar kind of details like asset and asset tag manufacturer company configurations it is again showing that which items are related to this particular that's how you define that what items are related to what other different CI that means configuration items now if you have any new relationship if you have if you want to add in that case you can just click on this plus button you will see this new screen which says a relationship editor that means you can add different items into your configuration items and add their relationships so in this case if I select any one for example it says used by child it is one of the suggested relationship and that's how ServiceNow is suggesting you that you can utilize these relationships for your adding different relationship with a different configuration items so if I select this one and if I go riddle it bottom you will see these are the configuration items and we have these existing relationships so in that case I can select maybe this one this one this one this one and then I will just click on plus icon I have to after selecting these configuration items I will click on plus what you will see it will be added here you can see that these items are added here and says used by child and these are added here if I click on save and exit yes I want to okay if I do that let's see what happens when I added that relationship you will see that these five items are added now used by computers so I added those see eyes and it can be seen here so this is how you can add relationships manually now this is something you can do automatically as well by pushing the data directly into CIA relationship table so if I go to configuration I think let me go to configuration and if you go a little bit bottom you will you will see that relationships module we have here you have relationships you also have suggested relationships if you want to create a new relationship you can also create it from here so for example if I click here you can mention that within what what kind of base class the reason for suggested relationship is that like for example an application it cannot be maybe it cannot be associated with her may be may be directly with with the with any database instance I'm just giving example that it cannot be associated may be may be a firewall cannot be connected to a to a router just I think it will be connected in in real world but I'm just giving example but if that's the reason suggested relationships are really important because you don't want those kind of relationships to be to be misused I would say that means for a particular CI class what kind of relationships you should use that is how you can define for your organization so any any any person who wants to create different CI relationships they should create those relationships with different configuration items as for the suggested as for the recommended CI relationships and that's how you can create these suggested relationships and you can use them as part of adding relationships in in CMDB so that's how you can configure just a high level high level details about CMDB that how exactly you can utilize CMDB relationships one more thing I think we were just talking about dependency view so I will quickly show you that as well so if I go back maybe I'll just open that servers this one server maybe maybe this one so if I go a little bit bottom in in related items if I show you here if I click this button called show dependency views if you click this button it will show the dependency view that means this application is associated with what different configuration items that is what you can see in this particular view it is loading dependency view you can see as of now I don't think it is it has any any relationship even if I if I go here you can see it is blank maybe let me let me go to another server so that you can understand better maybe we will select the same CI which we had this one so you remember we added these relationships with these configuration items so I will click on this dependency view it is loading dependency view now and you can see now it is showing you that relationship that graphical representation that how different servers how different services how different configuration items are related to this particular server which we have just opened you can see that and where exactly it is it is located that is something you can see here it is here Windows Server and these are all like used by because that was the dependency used by that means this particular Windows server is used by these particular computers that is what you can mention here and these are the servers associated with this Windows Server that is something you can see it's really a great view now one more important thing which I was talking about that you can also see the issues some alerts now you can see some icons here like if this particular CI or maybe in this view if do you have any associated CI with your primary CI which you're looking for or maybe which is the impacted CI you can see if there is any existing incident problem or any kind of maintenance available for that particular CI so if I give you the actual example the for example you're one of the application is down so what you can do you can open the dependency view and you will see that what all may be database instances servers are connected are related to that particular application you might find that your application is down and they are heller of incidents created for app fall for one of the database instance maybe which is connected to this application application so in that case you can just quickly check that in check particular CI that means that database instance and check if the incidents created their existing incident they are open they're active and they're they and they are like they just created they just got created recently when this application was down in that case you will get real and clear picture that which element is impacted and that's a I would say the power CMDB has it's a gray I think it's really powerful I would say powerful application for any organization to use to identify issues to fix them to resolve them as soon as possible so this is what this is what the glimpse of CMDB which you have to use in your in your different rackets you create like incident change problem