Re: [cisco-voip] Where does CUCM/informix store the recordingMediaSource and recordingFlag for phones/lines?

2019-09-11 Thread Nick Barnett
Perfect! Thank you! If anyone is searching this in the future, here is the ugly query I came up with that works as an executeSQL AXL call. If you try to run it from the CLI you'll need to mess with the parentheses because the CLI doesn't like them. I also limited the rows to 10 so it doesn't bl

Re: [cisco-voip] Where does CUCM/informix store the recordingMediaSource and recordingFlag for phones/lines?

2019-09-11 Thread Tucci, Ben via cisco-voip
I've never really tried an all in one statement like that but good to know you can't do that. Maybe someday. I just assumed you could... Some of the change controls we have strongly suggest that we keep a log of devices being updated so that there's a way to rollback a DB update. I end up with

Re: [cisco-voip] Where does CUCM/informix store the recordingMediaSource and recordingFlag for phones/lines?

2019-09-11 Thread Anthony Holloway
"... You could update based on criteria after joining..." Keep in mind that you cannot use UPDATE with JOIN on CUCM, due to the level of DB CUCM uses from Informix. Just a limitation we have to deal with, and an unfortunate one. I'm not sure if that's exactly what you were saying or getting at,

Re: [cisco-voip] Enjoy a No-Compromise User Experience with Cisco Jabber 12.7 - Cisco Blog

2019-09-11 Thread Charles Goldsmith
Supported yes, work well, not so much :) On Wed, Sep 11, 2019 at 11:04 AM Anthony Holloway < avholloway+cisco-v...@gmail.com> wrote: > Funny, I was just in a situation this week where the Desk Phone control of > the secondary line issue came up. Looks like 12.7 solves this now. > > However, it

Re: [cisco-voip] Enjoy a No-Compromise User Experience with Cisco Jabber 12.7 - Cisco Blog

2019-09-11 Thread Anthony Holloway
Funny, I was just in a situation this week where the Desk Phone control of the secondary line issue came up. Looks like 12.7 solves this now. However, it still doesn't look like it solves the problem of Jabber VDI and Desk Phone Video though, which remains a Jabber Windows only feature. It's a s

Re: [cisco-voip] Where does CUCM/informix store the recordingMediaSource and recordingFlag for phones/lines?

2019-09-11 Thread Tucci, Ben via cisco-voip
That should be tkpreferredmediasource on the devicenumplanmap; which is where the line info is stored for a given device. You could update based on criteria after joining the device on fkdevice or the dnorpattern fron numplan (fknumplan.) sql select * from typepreferredmediasource enum name

Re: [cisco-voip] Where does CUCM/informix store the recordingMediaSource and recordingFlag for phones/lines?

2019-09-11 Thread Nick Barnett
Valid question. We hit bug CSCvr11455 a week ago and it crippled our company for a few days because it broke A Cisco DB and affected Extension Mobility. We are in an "enhanced" change freeze window until Cisco can get us a p

Re: [cisco-voip] Where does CUCM/informix store the recordingMediaSource and recordingFlag for phones/lines?

2019-09-11 Thread Charles Goldsmith
I don't have an answer to your question, but why not just export all phones and filter that column in excel? On Wed, Sep 11, 2019 at 9:57 AM Nick Barnett wrote: > We're changing our recording platform and have to move from BiB Phone > Preferred to Gateway Preferred. I know we have many phones al

[cisco-voip] Where does CUCM/informix store the recordingMediaSource and recordingFlag for phones/lines?

2019-09-11 Thread Nick Barnett
We're changing our recording platform and have to move from BiB Phone Preferred to Gateway Preferred. I know we have many phones already (erroneously) set to gateway preferred. The way we are set up, this isn't causing an issue but will in the future. I need to find out how many phones we have s

[cisco-voip] Microsoft (?) adds skype link at top of Webex meetings?

2019-09-11 Thread Lelio Fulgenzi
Anyone out there see this strange behavior? We haven't been able to replicate it. For some reason, this appointment had the skype link at the top of the meeting and people were clicking that! [cid:image002.png@01D56883.C9E12E40] --- Lelio Fulgenzi, B.A. | Senior Analyst Computing and Communica

[cisco-voip] Enjoy a No-Compromise User Experience with Cisco Jabber 12.7 - Cisco Blog

2019-09-11 Thread Lelio Fulgenzi
12.7 has dropped. https://blogs.cisco.com/collaboration/enjoy-a-no-compromise-user-experience-with-cisco-jabber-12-7 -sent from mobile device- Lelio Fulgenzi, B.A. | Senior Analyst Computing and Communications Services | University of Guelph Room 037 Animal Science & Nutrition Bldg | 50 Stone R