Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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,868 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