select u.usernae, u.realname from userdata where username in (select username from appointmentslot where appointment is null)
 and u.mobdetailsid = m.id and m.deploymentmethod like 'IT assisted'