CI Location relationship setup

Viswanatha Red3
Mega Expert

‎10-10-2016 06:14 AM

Currently in CMDB, we have CI to user and CI to Group relationship exists.

I would like to create CI to location relationship since my CI (particularly services) are mapped to one or more locations.

I can create two tables cmdb_rel_loc_type and cmdb_rel_location to store respective records as currently exist.

But i am not sure how to use these in the UI.

The relationship editor doesn't will not have these values. And I don't want to disturb the OOTB.

Does anyone have an idea how to setup the CI-location relationship.

Regards

Viswa

0 Helpfuls
  • 1,621 Views
2 REPLIES 2

Geoffrey2
ServiceNow Employee
ServiceNow Employee

‎10-10-2016 08:01 PM

Have a read of this: Creating a Many-to-Many Relationship - ServiceNow Wiki


I would do this by creating an entry on the sys_m2m table.


0 Helpfuls

Viswanatha Red3
Mega Expert
In response to Geoffrey2

‎10-11-2016 02:11 AM

Hi geoffrey.sage



Thanks for your reply. As stated cmdb_rel_location is an m2m table which stores the CI and Location.



My main concern was how to add/remove this relationship in the editor ?


0 Helpfuls