select t2.fname,t1.createdate,t2.fphonenumber,t2.frole,t3.fprovince,t3.fcity,t3.fcounty
from DSBCRM..tattachment_downlog 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 convert(varchar(10), t1.createdate, 120) = convert(varchar(10), getdate(), 120)