Computer Assets have a location field that is joined to the Location assets. To automate some of the work for my department I'd like to create a custom ticket rule that runs daily to check for computer assets that don't have a location set, then set it depending on the name of the machine. At this point, I'm trying to get a script that sets the location properly. Here is the sql: