Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Cisco Community
- :
- About tpfrankli
tpfrankli
Contributor
Expertise:
CUCM, UCCX, CUPS, Exchange UM, VMWare, Unity Connection, Jabber.
Recent Badges
Stats
Member since
03-22-2005
78
Posts
11
Helpful
1
Solution
02-29-2016
04:17 PM
Resolved the issue. Value for "useCallingPartyPhoneMask"=>"On", was set to TRUE not on.
... View more
02-29-2016
02:29 PM
Turned AXL logging to debug. Looks like CUCM doesn't see the addRoutePattern API call. 2016-02-29 14:27:29,905 DEBUG [http-bio-443-exec-13] filters.TimingFilter - Received request 1455124524816 from axl-user at IP 192.168.3.2 2016-02-29 14:27:29,906 DEBUG [http-bio-443-exec-13] wrappers.RequestHeaderWrapper - Inside Request Header Wrapper 2016-02-29 14:27:29,927 DEBUG [http-bio-443-exec-13] filters.ThrottlingFilter - DBLCNQueue Count: 0 2016-02-29 14:27:29,928 DEBUG [http-bio-443-exec-13] filters.ThrottlingFilter - Successfully set the value of counter: 4 value: 0 2016-02-29 14:27:29,929 DEBUG [http-bio-443-exec-13] servletRouters.AXLAlpha - Checking request version [11.0] 2016-02-29 14:27:29,929 DEBUG [http-bio-443-exec-13] servletRouters.AXLAlpha - Checking if requested api [addRoutePattern] the implementedHandlers list 2016-02-29 14:27:29,929 DEBUG [http-bio-443-exec-13] servletRouters.AXLAlpha - [addRoutePattern] is not in the implementedHandlers list 2016-02-29 14:27:29,930 DEBUG [http-bio-443-exec-13] servletRouters.AXLAlpha - Checking if version is 8.x 2016-02-29 14:27:29,930 DEBUG [http-bio-443-exec-13] servletRouters.AXLAlpha - function to check if the version is 8.x 2016-02-29 14:27:29,930 DEBUG [http-bio-443-exec-13] servletRouters.AXLAlpha - version is not 8.x 2016-02-29 14:27:29,930 INFO [http-bio-443-exec-13] servletRouters.AXLAlpha - Executing api: addRoutePattern in axis 2016-02-29 14:27:29,931 DEBUG [http-bio-443-exec-13] wrappers.RequestNamespaceWrapper - Inside Request Wrapper 2016-02-29 14:27:29,931 DEBUG [http-bio-443-exec-13] servletRouters.AXLAlpha - AXL REQUEST : <?xml version="1.0" encoding="UTF-8"?> <SOAP-ENV:Envelope xmlns:SOAP-ENV=" http://schemas.xmlsoap.org/soap/envelope/ " xmlns:ns1=" http://www.cisco.com/AXL/API/11.0 "><SOAP-ENV:Body><ns1:addRoutePattern><routePattern><pattern>9.011!</pattern><description>International from US-555-foop</description><routePartitionName>US-555-foop-Routes</routePartitionName><blockEnable>FALSE</blockEnable><useCallingPartyPhoneMask>TRUE</useCallingPartyPhoneMask><callingPartyPrefixDigits>12345</callingPartyPrefixDigits><dialPlanName></dialPlanName><digitDiscardInstructionName>PreDot</digitDiscardInstructionName><networkLocation>OffNet</networkLocation><prefixDigitsOut></prefixDigitsOut><routeFilterName></routeFilterName><provideOutsideDialtone>FALSE</provideOutsideDialtone><destination><routeListName>Local-PSTN-Route-List</routeListName></destination></routePattern></ns1:addRoutePattern></SOAP-ENV:Body></SOAP-ENV:Envelope> 2016-02-29 14:27:29,932 DEBUG [http-bio-443-exec-13] servletRouters.AXLAlpha - Request processed by AXIS 2016-02-29 14:27:29,938 DEBUG [http-bio-443-exec-13] axlapiservice.Handler - dbConnector Initialization in handler.java 2016-02-29 14:27:29,939 DEBUG [http-bio-443-exec-13] axlapiservice.Axl - Connection given to current thread 2016-02-29 14:27:29,942 DEBUG [http-bio-443-exec-13] axlapiservice.AXLCallFlow - In begin transaction of AXLCallflow and created pub connector 2016-02-29 14:27:29,950 DEBUG [http-bio-443-exec-13] axlapiservice.AddRoutePatternHandler - In AddRoutePattern 2016-02-29 14:27:29,951 DEBUG [http-bio-443-exec-13] axlapiservice.Handler - getPkid Query is :select pkid from RoutePartition where my_lower(name ) =my_lower('US-555-foop-Routes' ) 2016-02-29 14:27:29,956 DEBUG [http-bio-443-exec-13] axlapiservice.Handler - Inside addTkdataAXIS utils part 2016-02-29 14:27:29,963 DEBUG [http-bio-443-exec-13] axlapiservice.Handler - select enum from TypeStatus where TypeStatus.name='TRUE' 2016-02-29 14:27:29,967 ERROR [http-bio-443-exec-13] axlapiservice.AXLAPIServiceSkeleton - com.cisco.www.axlapiservice.AXLAPIServiceSkeleton@117c1d2 com.cisco.www.axlapiservice.DataValidationException: ENUM for TRUE not found in TypeStatus at com.cisco.www.axlapiservice.Handler.addTkDataAXIS(Handler.java:3111) at com.cisco.www.axlapiservice.AddRoutePatternHandler.doAdd(AddRoutePatternHandler.java:82) at com.cisco.www.axlapiservice.AXLAPIServiceSkeleton.addRoutePattern(AXLAPIServiceSkeleton.java:16186) at com.cisco.www.axlapiservice.AXLAPIServiceMessageReceiverInOut.addRoutePattern(AXLAPIServiceMessageReceiverInOut.java:11059) at com.cisco.www.axlapiservice.AXLAPIServiceMessageReceiverInOut.invokeBusinessLogic(AXLAPIServiceMessageReceiverInOut.java:1447) at org.apache.axis2.receivers.AbstractInOutMessageReceiver.invokeBusinessLogic(AbstractInOutMessageReceiver.java:40) at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:100) at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:176) at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275) at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:131) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338) at com.cisco.www.servletRouters.AXLAlpha.forwardToAxis(AXLAlpha.java:201) at com.cisco.www.servletRouters.AXLAlpha.doPost(AXLAlpha.java:72) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.www.servletRouters.filters.ThrottlingFilter.doFilter(ThrottlingFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.vos.platform.tomcat.valves.CiscoResponseHeaderFilter.doFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.www.servletRouters.filters.NormalizeHeaderFilter.doFilter(NormalizeHeaderFilter.java:50) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.www.servletRouters.filters.AuthenticationFilter.doFilter(AuthenticationFilter.java:57) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.www.servletRouters.filters.TimingFilter.doFilter(TimingFilter.java:41) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:613) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:312) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) 2016-02-29 14:27:29,969 DEBUG [http-bio-443-exec-13] axlapiservice.AXLCallFlow - In rollback transaction and created pub connector 2016-02-29 14:27:29,970 DEBUG [http-bio-443-exec-13] axlapiservice.Axl - Connection closed and hashmap entry removed in AXL.java closing connection 2016-02-29 14:27:29,970 DEBUG [http-bio-443-exec-13] axlapiservice.AXLCallFlow - Rollback transaction connector object closed 2016-02-29 14:27:29,971 DEBUG [http-bio-443-exec-13] axlapiservice.AXLCallFlow - In AXL CAll Flow class, method getSOAPError 2016-02-29 14:27:29,972 DEBUG [http-bio-443-exec-13] axlapiservice.AXLCallFlow - Setting soap fault 2016-02-29 14:27:29,972 DEBUG [http-bio-443-exec-13] axlapiservice.AXLCallFlow - Setting soap fault2 2016-02-29 14:27:29,980 DEBUG [http-bio-443-exec-13] servletRouters.AXLAlpha - <?xml version='1.0' encoding='utf-8'?><soapenv:Envelope xmlns:soapenv=" http://schemas.xmlsoap.org/soap/envelope/ "><soapenv:Body><soapenv:Fault><faultcode>soapenv:Server</faultcode><faultstring>ENUM for TRUE not found in TypeStatus</faultstring><detail><axlError><axlcode>5003</axlcode><axlmessage>ENUM for TRUE not found in TypeStatus</axlmessage><request>addRoutePattern</request></axlError></detail></soapenv:Fault></soapenv:Body></soapenv:Envelope> 2016-02-29 14:27:29,981 DEBUG [http-bio-443-exec-13] servletRouters.AXLAlpha - Finished processing request 2016-02-29 14:27:29,981 INFO [http-bio-443-exec-13] filters.TimingFilter - Request 1455124524816 received from axl-user at ip 192.168.3.2 was processed in 76ms
... View more
02-29-2016
01:29 PM
I'm getting the following error when calling the addRoutePatern AXL API in CUCM 11.0. "ENUM for TRUE not found in TypeStatus" I don't see that value called out anywhere in the API documentation. Full response below: object(stdClass)#4 (3) { ["axlcode"]=> string(4) "5003" ["axlmessage"]=> string(37) "ENUM for TRUE not found in TypeStatus" ["request"]=> string(15) "addRoutePattern" } } } CUCM RTMT AXL error: 2016-02-29 14:20:53,691 INFO [http-bio-443-exec-12] servletRouters.AXLAlpha - Executing api: addRoutePattern in axis 2016-02-29 14:20:53,705 ERROR [http-bio-443-exec-12] axlapiservice.AXLAPIServiceSkeleton - com.cisco.www.axlapiservice.AXLAPIServiceSkeleton@9b5ce2 com.cisco.www.axlapiservice.DataValidationException: ENUM for TRUE not found in TypeStatus at com.cisco.www.axlapiservice.Handler.addTkDataAXIS(Handler.java:3111) at com.cisco.www.axlapiservice.AddRoutePatternHandler.doAdd(AddRoutePatternHandler.java:82) at com.cisco.www.axlapiservice.AXLAPIServiceSkeleton.addRoutePattern(AXLAPIServiceSkeleton.java:16186) at com.cisco.www.axlapiservice.AXLAPIServiceMessageReceiverInOut.addRoutePattern(AXLAPIServiceMessageReceiverInOut.java:11059) at com.cisco.www.axlapiservice.AXLAPIServiceMessageReceiverInOut.invokeBusinessLogic(AXLAPIServiceMessageReceiverInOut.java:1447) at org.apache.axis2.receivers.AbstractInOutMessageReceiver.invokeBusinessLogic(AbstractInOutMessageReceiver.java:40) at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:100) at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:176) at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275) at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:131) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338) at com.cisco.www.servletRouters.AXLAlpha.forwardToAxis(AXLAlpha.java:201) at com.cisco.www.servletRouters.AXLAlpha.doPost(AXLAlpha.java:72) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.www.servletRouters.filters.ThrottlingFilter.doFilter(ThrottlingFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.vos.platform.tomcat.valves.CiscoResponseHeaderFilter.doFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.www.servletRouters.filters.NormalizeHeaderFilter.doFilter(NormalizeHeaderFilter.java:50) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.www.servletRouters.filters.AuthenticationFilter.doFilter(AuthenticationFilter.java:57) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.cisco.www.servletRouters.filters.TimingFilter.doFilter(TimingFilter.java:41) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:613) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:312) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) 2016-02-29 14:20:53,715 INFO [http-bio-443-exec-12] filters.TimingFilter - Request 1455124524813 received from axl-user at ip 192.168.3.2 was processed in 55ms
... View more
Labels:
01-12-2016
09:59 AM
So I just tested and you are correct it was just the CFWALL CSS being invoked. Is it just SNR that would do Re-routing? I guess I'd like to know which CSS gets invoked and when. And what would be the purpose of having RCSS on a trunk?
Thank you.
... View more
Created by
tpfrankli
in IP Telephony and Phones
in IP Telephony and Phones
01-12-2016
08:59 AM
01-12-2016
08:59 AM
I'm trying to understand when the Rerouting Calling Search Space is invoked and the impact on call routing. Here's a call flow Example:
PSTN Caller <--> ITSP PSTN <--SIP--> CUBE <--SIP--> CUCM Trunk <--SIP--> Cisco 8851 SIP Phone.
The Cisco 8851 is set to do a call forward all back out to a PSTN off-net phone number utilizing the same trunk that the call came in on.
Is the the Rerouting Calling Search Space on the Phone or the SIP trunk that is invoked for this call? The challenge I'm facing is I need to modify the ANI on the call to add in a STN phone number for Verizon so that I can send out the PSTN caller's caller ID to the off-net call forward all destination.
CUCM 10.5.2
IOS 15.4
Thanks
... View more
- Tags:
- cucm css sip
Labels:
08-19-2015
10:29 AM
What as your final resolution to this? I am facing the exact same issue with the same versions of software. I have a TAC case open but they are slowly pouring over logs. Thanks.
... View more
12-01-2014
10:26 AM
Any additional progress on this issue? I see the bug ID there is supposed to be a patched version of 10.5 but it does not appear to be published on CCO.
... View more
06-16-2014
08:23 AM
This may not even be possible but figured I'd ping a few other brains. We are in the process of setting multiple sub-interfaces out to branch offices off our own transport. Part of this is providing them committed sub-rate interface speeds. Easy enough with an MQC shaping policy. However here's the gotcha we'd like if other sub-interfaces on the PHY aren't in use to allow the site to burst. I'm wondering if this kind of dynamic sharper is possible. policy-map Ring-Traffic class Voice priority percent 30 class Signal priority percent 5 class class-default random-detect ! policy-map Shape-DATX class class-default bandwidth 60000 shape average 60000000 service-policy Ring-Traffic ! policy-map Shape-CRCO class class-default bandwidth 20000 shape average 20000000 service-policy Ring-Traffic ! interface GigabitEthernet3/0/1 no ip address speed auto duplex auto negotiation auto ! interface GigabitEthernet3/0/1.39 description CRCO encapsulation dot1Q 39 ip address 10.39.39.1 255.255.255.252 service-policy output Shape-CRCO ! interface GigabitEthernet3/0/1.40 description DATX encapsulation dot1Q 40 ip address 10.40.40.1 255.255.255.252 service-policy output Shape-DATX So in the above example if Gi3/0/1.40 had zero traffic Gi3/0/1.39 should be able to take all of it's 60Mbps. Basically dynamic load sharing. Not sure if this is even possible with QoS MQC. Curious as to others thoughts. Thanks.
... View more
Labels:
06-12-2014
08:32 AM
So either I'm dense or it just doesn't exist. All I really want is a report of what devices are associated to an application user. We have a situation wherein we have two CTI applications and if a single device is associated to both the world comes crashing down. I wasn't able to find this in the GUI interface so I took to the CLI via SQL and I have my query working. The following syntax will spit back all associated devices for user X: /*Show Devices associated with PBC-Genesys User*/ select d.fkdevice,dv.name as DeviceName from applicationuserdevicemap as d inner join device as dv on d.fkdevice=dv.pkid where fkapplicationuser = '5cad9858-2934-82ae-e5a4-6822ac390ed0' And by simply changing the fkapplicationuser I can see devices associated with user Y: /*Show Devices associated with WBC-Genesys User*/ select d.fkdevice,dv.name as DeviceName from applicationuserdevicemap as d inner join device as dv on d.fkdevice=dv.pkid where fkapplicationuser = '0bbacbb2-0c38-7023-936c-733aedd8a9d8' Now I would think a simple AND at the bottom of this query would return me a list of devices that happened to be associated to both but that isn't the case. Is this possible? Here's what I tried that doesn't work. /*Show Devices associated with PBC-Genesys AND WBC-Genesys Users*/ select d.fkdevice,dv.name as DeviceName from applicationuserdevicemap as d inner join device as dv on d.fkdevice=dv.pkid where fkapplicationuser = '5cad9858-2934-82ae-e5a4-6822ac390ed0' AND fkapplicationuser = '0bbacbb2-0c38-7023-936c-733aedd8a9d8' I'm the first to admit I suck at SQL but I'm trying slowly to wrap my head around it. Thanks.
... View more
- Tags:
- sql cucm cli
Labels:
06-09-2014
12:57 PM
I know this is old but ever get anywhere with this I'm seeing the same thing. CUCM 9.1.2SU2 with CUBE 15.1.4 IOS.
... View more
04-30-2014
03:34 PM
Did you ever reach a resolution for this hitting the same thing on System version: 10.0.1.11001-37? Thanks. Never mind re-read the thread. Firefox works.
... View more
Created by
tpfrankli
in Collaboration, Voice and Video Documents
in Collaboration, Voice and Video Documents
04-29-2014
02:41 PM
04-29-2014
02:41 PM
Did you ever find out if this works for the CUCILync 9.2 client?
... View more
Created by
tpfrankli
in Collaboration, Voice and Video Documents
in Collaboration, Voice and Video Documents
04-21-2014
01:39 PM
04-21-2014
01:39 PM
Thanks for the followup that gives me some hope for doing this in my environment. I've been running some tests with 8.6 and even changing the Directory from Active Directory over to ADAM the inactive users still seem to get marked active as long as the UserID matches.
... View more
Created by
tpfrankli
in Collaboration, Voice and Video Documents
in Collaboration, Voice and Video Documents
04-21-2014
01:16 PM
04-21-2014
01:16 PM
Any further word on this? I'm doing the exact same thing. My only other thought is to wait for 10.x of CUCM and then convert all my AD users into local users change the LDAP sync then change them all back.
... View more
02-29-2016
Turned AXL logging to debug. Looks like CUCM doesn't see the
addRoutePattern API call.2016-02-29 14:...
02-29-2016
I'm getting the following error when calling the addRoutePatern AXL API
in CUCM 11.0. "ENUM for TRUE...
01-12-2016
So I just tested and you are correct it was just the CFWALL CSS being
invoked. Is it just SNR that w...
Created by
tpfrankli
in IP Telephony and Phones
01-12-2016
01-12-2016
I'm trying to understand when the Rerouting Calling Search Space is
invoked and the impact on call r...
08-19-2015
What as your final resolution to this? I am facing the exact same issue
with the same versions of so...
Created by
tpfrankli
in Collaboration Applications
07-29-2015
07-29-2015
Columbia Sportswear Company is waiting eagerly for this as well.
07-02-2015
The issue is I believe the release notes for Jabber 11.0 are incorrect.
Per the release notes for 11...
07-01-2015
Is anyone else having and issue with the automatic update to Jabber 11
for Mac? Per the release note...
12-01-2014
Any additional progress on this issue? I see the bug ID there is
supposed to be a patched version of...
06-16-2014
This may not even be possible but figured I'd ping a few other brains.
We are in the process of sett...
06-12-2014
So either I'm dense or it just doesn't exist. All I really want is a
report of what devices are asso...
06-09-2014
I know this is old but ever get anywhere with this I'm seeing the same
thing. CUCM 9.1.2SU2 with CUB...
Public Statistics
| Date Registered | 03-22-2005 03:22 PM |
| Date Last Visited | 09-26-2018 08:29 AM |
| Total Messages Posted | 78 |
| Total Helpful Votes Received | 11 |
Helpful Votes Given To
| User | Helpful Count |
|---|---|
| 5 | |
| 5 | |
| 5 | |
| 4 | |
| 5 |
.jpg "Hall of Fame Community Legend"){kind=icon}
.jpg "VIP Mentor"){kind=icon}
