Updated the get vms endpoint with the new sql statement Matt came up with. Now joins the tables correctly.
fixed it.