CMDB Relationship Esxi Server and VM's

[trinadhgottipat]

Hi,

We are building CI Relationships using import sets.We have implemented this for all other Applications, taking manual inputs from respective teams.Now, we should be able to create the same for ESXi applications,VM's and all other components, if any.

Since we are importing the Relationships without using discovery, i need to reach out to the team and ask them to fill in a template.Which was like -- 

CI1  (Parent)                        CI2(Child)                         Relationshp

My question now is,how do I request the ESXi team to fill in the data.Any specific Excel template so that we get all the CI's and their relationships.

Regards,

Trinadh Gottipati.

[Sanjeev Kumar1]

Hi,

I think you are asking about three CI.

1. ESXi Host [Physical Server]

2. VM's

3. Applications that are runing on VM.

If I am correcte you need  create relationship between these CI

[ESXi Server] --> [Virtualizes::Virtualized by] --> [VM] --> [Used by :: Depends on] --> [Application]

So In this case you just need information about three CI

[ESXi ] -- [VM] -- [Application]

Busing import you will create relationship between these CI. To create relationship you need to use CMDBUtil

@ https://docs.servicenow.com/bundle/london-application-development/page/app-store/dev_portal/API_reference/CMDBUtil/concept/c_CMDBUtilAPI.html#r_CMDBU-createCIRel_S_S_S_S_O 

Let me know if you need any help.

[DaveHertel]

Hi - 1 way to get an Excel template is to look at the list view of the relationship table.  In filter navigator, enter . cmdb_rel_ci.list to show the list of relations, then on the header of any column in that list view, right click, then select Export> Excel. 

 This will give you a excel file of existing data.  Now take that file, clear out existing rows except the header... give it to your team.   As they fill in the Parent & Child, be sure the spreadsheet has valid TYPES for the relationships.   Such as Runs on:: Runs,  Contains::Contained By, etc... whatever is appropriate for the parent-child relations.

Does this help?  Hope so...