Make location inactive?

Heather White
Mega Guru

Good morning,

      Is there a way to make locations inactive in ServiceNow?   We imported current(updated) locations from AD and users now have the correct locations within their company.   However, the "old" locatoins are still available in the drop down menu.   We do not want users to see these depricated locations.

Thank you!

Heather

1 ACCEPTED SOLUTION

Chuck Tomasi
Tera Patron

Hi Heather,



Here's how I would handle this - without deleting any of the previous records, because deleting can cause issues with broken references.


  1. Create a new field on the location (cmn_location) called Active (u_active) and make it a true/false field.
  2. Make the locations you want to appear active (true) and those that you don't, leave unchecked.
  3. Create a before/query business rule that automatically filters for the active records only. Use the "user query" business rule as an example (substitute YOURINSTANCE for your instance name in the following URL
    1. https://YOURINSTANCE.service-now.com/nav_to.do?uri=sys_script.do?sys_id=62a7bfaf0a0a0a6500c49682bd82...

View solution in original post

21 REPLIES 21

G24
Kilo Sage

This is helpful, thank you; my related question is...

Why do SOME tables in ServiceNow have an Active flag, while others do not?  Did ServiceNow specifically decide Not to place an Active flag on the Locations table?  And if so, WHY?

Thanks!

It happens the same with company (core_company). Companies also have a lifecycle as locations - people and companies perform updates to the physical and estatutory structures.

This could be the easiser post I ever read. Master Tomasi 's solution provided 5 years ago, of course resolve the issue, but adding a u_active field seems for me quite risky as it seems to be a field that should provided by the OOB solution.