Best Practices

Let me explain. First i have searched a number of close entries here, but nothing seems to hit me with 'yes, thats the one (with the exception of 1 thread which talks about it'

We have 157 locations (these are smart labels) which contain IP ranges. What I would like to do is assign the label to the Computer Asset's field (location field, which in turn is based on Asset Location type)

I understand this should be done through a ticketing rule. Is there someone who has created such a SQL script or can assist me here? We are fairly new using this KACE appliance but I do have a listing of our Asset Field defintions and ID's if this can help. I assume many would like to try this, and we are fine to run this as a nightly ticket rule during low peak hours. With 4000 or so machines, and only a handful of desktop support technicians it would make life a little easier having the Computer Asset update its location field (associated to location asset type) nightly so we could at a glance, view all assets within a location, or use this in conjunction with other filters on reports of assets.

The issue with manually updates is ... well ... the team can look for the label and figure out where it is on a 1 by 1 basis and likely would be less encouraged to also have to manually update it's location while connected to the network. Of course for available or spare inventory in our storage, we would be happy to manually update but we'd like the connected/matched  machines updated automatically.

Thank you,

Colin