I was sure I'd tried and failed to do this, so just testing again. Sure enough the quoted works. However two significant problems. 1) You cannot use a SQL update to change from enterprise subscription to a regular service (set enterprisesubscription="f"). 'No UPDATE Permission' - so I take it that means the admin user command has no update permission on the 'enterprisesub scription' column. Thats a shame, that would have been far more useful. 2) I didn't retest this as I don't have suitable phones at home, but I'm also sure that the priority value affects only enterprise subscriptions - so if we change the enterprise subscriptions to regular services we still cannot control the order.
So whilst it does work up to a point the only useful thing I can see is that it allows you to reorder enterprise subscriptions, and that unfortunately doesn't solve most of the issues various people have raised. Of course I've love to be proved wrong... On Wed, Apr 18, 2012 at 6:12 AM, steven moran <[email protected]> wrote: > it works in my lab - I haven't tried it in the exam but it would really > suck if they did this, then you are stuck with creating the entire insert > either from the release notes or from the run sql select command edit the > returned string taking out the extra vendor and version headers like this. > It only takes a less than a minute. > > *Original* > pkid name > urltemplate description > nameascii tkphoneservice vendor version enterprisesubscription > enabled priority tkphoneservicecategory > ==================================== =================== > ==================================== =================== > =================== ============== ====== ======= ====================== > ======= ======== ====================== > d0059763-cdcc-4be7-a2a8-bbd4aac73f63 Missed Calls > Application:Cisco/MissedCalls Missed Calls Missed > Calls 1 t t > 1 0 > > *Modified* > run sql insert into telecasterservice (pkid, name, urltemplate, > description, nameascii, tkphoneservice, enterprisesubscription, enabled, > priority, tkphoneservicecategory) values > ('d0059763-cdcc-4be7-a2a8-bbd4aac73f63','Missed > Calls','Application:Cisco/MissedCalls','Missed Calls','Missed > Calls','1','t','t','1','0') > > > On Wed, Apr 18, 2012 at 2:55 PM, gabriel <[email protected]>wrote: > >> Hi Steve, >> >> Does it work? >> I remember trying to update this same stuff last year and apparently >> the admin user had privileges for 'deletes' and 'inserts' but not for >> 'updates. >> >> Great to see this! >> >> Cheers, >> Gabriel >> >> >> On Wed, Apr 18, 2012 at 1:25 AM, steven moran <[email protected]> >> wrote: >> > there's been much information on this including needless deleting and >> > recreating of services - here is a good method that I found works 100% >> and >> > doesn't need a time wasting dip into the release notes. >> > >> > >> > so >> > >> > SSH into the pub >> > run sql select * from telecasterservice >> > >> > this returns something similar to >> > >> > = ============== ====== ======= ====================== ======= ======== >> > ====================== >> > a0eed443-c705-4232-86d4-957295dd339c Placed Calls >> > Application:Cisco/PlacedCalls Placed Calls Placed Calls >> > 1 t t 2 >> > 0 >> > 0061bdd2-26c0-46a4-98a3-48a6878edf53 Received Calls >> > Application:Cisco/ReceivedCalls Received Calls Received Calls >> > 1 t t 3 >> > 0 >> > 27f92f3c-11ed-45f3-8400-fe06431c0bfc Intercom Calls >> > Application:Cisco/IntercomCalls Intercom Calls Intercom Calls >> > 1 f t 4 >> > 0 >> > 7eca2cf1-0c8d-4df4-a807-124b18fe89a4 Corporate Directory >> > Application:Cisco/CorporateDirectory Corporate Directory Corporate >> Directory >> > 1 t t 1 >> > 0 >> > ca69f2e4-d088-47f8-acb2-ceea6722272e Voicemail >> > Application:Cisco/Voicemail Voicemail Voicemail >> > = ============== ====== ======= ====================== ======= ======== >> > ====================== >> > >> > >> > a bit confusing without the table headers but the only bit I'm >> interested in >> > is the pkid >> > >> > I then: run the following command to change the corporate directory >> priority >> > from 1 to 4; >> > >> > run sql update telecasterservice set Priority="4" where >> > pkid="7eca2cf1-0c8d-4df4-a807-124b18fe89a4" >> > >> > restart the phone >> > >> > this will set the priority of the service and change the order on the >> menu. >> > >> > _______________________________________________ >> > For more information regarding industry leading CCIE Lab training, >> please >> > visit www.ipexpert.com >> > >> > Are you a CCNP or CCIE and looking for a job? Check out >> > www.PlatinumPlacement.com <http://www.platinumplacement.com/> >> > > > _______________________________________________ > For more information regarding industry leading CCIE Lab training, please > visit www.ipexpert.com > > Are you a CCNP or CCIE and looking for a job? Check out > www.PlatinumPlacement.com >
_______________________________________________ For more information regarding industry leading CCIE Lab training, please visit www.ipexpert.com Are you a CCNP or CCIE and looking for a job? Check out www.PlatinumPlacement.com
