Query is to find the Machine and Email ID for Full user name

Query is to find the Machine and Email ID for Full user name :


Select distinct Netbios_name0,USer_domain0,v.User_Name0,Mail0,v_R_User.Full_User_Name0,Last_Logon_Timestamp0
 from v_r_System v
 inner join v_R_User on v_r_user.User_Name0 = v.User_Name0
 where v_R_User.Full_User_Name0  in ('Donn xxxxxxxx','xxxxxxxxxx','xxxxxxxxx','xxxxxxxxxx',
'xxxxxxxxx Davis','Darla xxxxxxxx')