update db queries on controllers

Signed-off-by: Adam Stokes <adam.stokes@ubuntu.com>