Update for Line Presence Appearance
Quick command to dump out extensions associated with users so that you can create a BAT update for Line Appearance Association for Jabber Presence status. You can also tweak it to pull Primary Extension.
run sql \ select d.name,e.userid,n.dnorpattern,p.name \ from device as d \ inner join enduser as e on e.pkid=d.fkenduser \ inner join devicenumplanmap as dmap on dmap.fkdevice=d.pkid \ inner join numplan as n on n.pkid=dmap.fknumplan \ inner join routepartition as p on p.pkid=n.fkroutepartition \ where dmap.index='1' !!! Optional for 1st line on phone