select t1.tenterprise_userid,t2.fname,t2.fphonenumber,t2.frole,t1.flastrequestdate,t3.fagentname from DSBCRM..tuserrequestlog t1
inner join DSBCRM..tenterprise_users t2 on t1.siteid=t2.siteid and t1.tenterprise_userid=t2.tenterprise_userid
left join DSBCRM..tagents t3 on t2.siteid=t3.siteid and t2.tagentsid=t3.tagentsid
where t1.siteid=$siteid$ and t1.flastrequestdate > DATEADD(MINUTE, -30, getdate())