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