populating state on the dashboard vms report