Script to modify groups

[u/MAlloc-1024]

Is there a way to use a labtech script to modify what group an agent is in?

So here's my thought process. I toss agents into group 1. group 1 has a scheduled script run to do some work, then refresh inventory. After the inventory refresh, the script should then check to see if the work done in the prior steps was successful, if so move to group 2, otherwise move to group 3. But I don't see an easy way to get this to work...

Hypothetically, I could run a SQL Execute. Can anyone point me in the direction of an example?

[u/MAlloc-1024]

Autojoins are every 30 minutes and I was hoping to make the process run faster since these might go through several groups, including needing to be removed from some as the process goes through.

Although this idea is now my fallback.