Maximo 7.6.1.2:

I have routes that have thousands of assets. For example, I have a route for all the sidewalks in a specific zone.

Instead of adding or removing assets from the route manually, I want to automatically update it via criteria on the ASSET table.

Example: In the route, specify a query that will be used to refresh the route on a schedule.
The query would be something like: select from assets where status=ACTIVE and hierarchypath=ROADS\SIDEWALK and zone=10.

Is there a way to create dynamic routes?

Thank you.

#Maximo
#AssetandFacilitiesManagement

Not out of box, but interacting with route stops is pretty easy to script. We added two custom fields (one for assets & one for locations) where we allow the user to specify the where clause we want to use to identify assets/locations that should be on that route. When both are null we know they are manually maintained and do nothing with them. We then built a cron task automation script that removed anything that didn't match that criteria and added anything that did but wasn't in the list.

I can't share the actual script but can share that adding route stops for us is literally just adding a new mbo to the set and setting the ASSETLOCSITEID and ASSETNUM or LOCATION fields.

------------------------------
Steven Shull
Director of Development
Projetech Inc
Cincinnati OH
------------------------------