My Collab Lab

mycollablab.org

Update for Line Presence Appearance

November 15, 2016 Voice

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

axlcucmupdate

Tropo Dialer POC

Yo Mama Bot


Jon Snipes
LinkedIn

My career progressed from head butcher to Collaboration CCIE. There isn’t much technically that carries over between professions, but 8 years of direct customer service experience and squeezing margin out of processes provided a solid base and direction for the rest of my career. My focus today is deep into collaboration messaging, voice and video with the expertise to develop processes and programmatic solutions to complex business problems.

Principal Architect at Cloverhound
CCIE Collaboration 51786
Cisco Webex Expert
2018-2021 Cisco Champion

Categories
  • Cloud (4)
  • Contact Center (1)
  • Development (1)
  • PHP (10)
  • Python (3)
  • Uncategorized (1)
  • Video (2)
  • Voice (12)
  • Voicemail (5)
  • Webex (7)
Recent Posts
  • Azure OAuth2.0 User Authentication December 4, 2021
  • Pass-through Gateway Routing and Dial Peer Groups December 4, 2021
  • Get Started Coding with Python: System Setup and Running Scripts December 4, 2021
  • Exporting CUCM to an Offline Local DB with Python December 4, 2021
  • Connecting to UCCX INFORMIX DB with Python on Linux December 4, 2021
Proudly powered by WordPress | Theme: Doo by ThemeVS.