SELECT DISTINCT lg.name as LineGroup,n.dnorpattern as Extension,dhd.hlog as LoggedIn,n.description from linegroup as lg inner join linegroupnumplanmap as lgmap on lgmap.fklinegroup=lg.pkid inner join numplan as n on lgmap.fknumplan = n.pkid inner join devicenumplanmap as dmap on dmap.fknumplan = n.pkid inner join device as d on dmap.fkdevice=d.pkid inner join devicehlogdynamic as dhd on dhd.fkdevice=d.pkid where dhd.hlog ='t' AND lg.name = 'Line_Group_Name' order by lg.name Cisco Axl code