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…