Relating multiple Locations to a single Business Application

[Kirk3]

Hello,

ServiceNow OOB allows a Business Application (cmdb_ci_business_app) to be associated with a single location (cmn_location).  We are a global organization with over 1,000 physical locations so we're seeking a way to link multiple locations to a single Business Application used by multiple locations.

Is there a recommended best approach to create this new many to one relationship?  A new u_cmdb_ci table with database view for example? 

Thoughts are appreciated as I was unable to find any answers in previously posted articles.

 Thanks!

[SandyBatcheller · Accepted solution]

Hello,

You could create a new table that has 2 reference fields:  1) Business Applications and 2) Locations.  Then, you could create records establishing the many-to-many relationship.

For example, if Business App A1 has 3 Locations, you would have 3 records where the Business Application reference field would be filled in with A1 and the Location field would be one of the 3 Locations associated with it.

Once those records have been created, you can add this new table as a related list to your Business Application form (if needed.)

Hope this helps

Sandy

[Kirk3]

Very helpful, thanks Sandy!

[Finlay Marsden]

Bulk location management allows businesses with 10 or more locations to add, verify, and manage their locations all at once, which simplifies the process significantly. To use bulk location management you'll need to create a Google account and location group for your business.

West Penn Power Bill Pay