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 thedd
Stats
Member since
02-02-2016
46
Posts
1
Helpful
3
Solutions
12-03-2019
01:41 PM
I think the DN you try to use does not exist. Please verify. If it is like this first add the line.
... View more
11-18-2019
01:58 PM
Just try this SQL Statement: select lg.name as LineGroup, sep.name as SEP, udp.name as UDP, n.dnorpattern as DN ,dhd.hlog as HuntLog from linegroup as lg inner join linegroupnumplanmap as lgmap on lgmap.fklinegroup=lg.pkid inner join numplan as n on lgmap.fknumplan = n.pkid inner join devicenumplanmap as dmap on dmap.fknumplan = n.pkid inner join device as sep on dmap.fkdevice=sep.pkid left join devicehlogdynamic as dhd on dhd.fkdevice=sep.pkid left join extensionmobilitydynamic as extmob on sep.pkid=extmob.fkdevice left join device as udp on extmob.fkdevice_currentloginprofile=udp.pkid where lg.name Like "%" and dhd.hlog="t" order by lg.name
... View more
11-16-2019
04:22 AM
If there is no Error the SQl Syntax is ok. If there is no Result there has been no match. At the moment you do the sql query be sure there is a UDP logged in on an SEP and logged in on the LG. Do you have a test phone tob e sure that there hast to be an result? Or just ask for lg.name Like "%" then you will not filter a specific LG which will maybe better proof the SQL: Otherwise some of the inner joins have to be changed to left join.
... View more
11-14-2019
02:51 AM
I see the mistake. There is a double where. Use this one: select lg.name as LineGroup, sep.name as SEP, udp.name as UDP, n.dnorpattern as DN ,dhd.hlog as HuntLog
from linegroup as lg
inner join linegroupnumplanmap as lgmap on lgmap.fklinegroup=lg.pkid
inner join numplan as n on lgmap.fknumplan = n.pkid
inner join devicenumplanmap as dmap on dmap.fknumplan = n.pkid
inner join device as sep on dmap.fkdevice=sep.pkid
inner join devicehlogdynamic as dhd on dhd.fkdevice=sep.pkid
inner join extensionmobilitydynamic as extmob on sep.pkid=extmob.fkdevice
inner join device as udp on extmob.fkdevice_currentloginprofile=udp.pkid
where lg.name IN ('HR_Benefits-LG','HR_ServiceCenter-LG') and dhd.hlog="t"
order by lg.name
... View more
11-12-2019
11:52 PM
Try this one select lg.name as LineGroup, sep.name as SEP, udp.name as UDP, n.dnorpattern as DN ,dhd.hlog as HuntLog
from linegroup as lg
inner join linegroupnumplanmap as lgmap on lgmap.fklinegroup=lg.pkid
inner join numplan as n on lgmap.fknumplan = n.pkid
inner join devicenumplanmap as dmap on dmap.fknumplan = n.pkid
inner join device as sep on dmap.fkdevice=sep.pkid
inner join devicehlogdynamic as dhd on dhd.fkdevice=sep.pkid
inner join extensionmobilitydynamic as extmob on sep.pkid=extmob.fkdevice
inner join device as udp on extmob.fkdevice_currentloginprofile=udp.pkid
where lg.name IN ('HR_Benefits-LG','HR_ServiceCenter-LG') and dhd.hlog="t"
order by lg.name This will give you linegroup: LG_Name sep: Hardphone with Hlog = true udp: UDP Name dn: directory_number huntlog: Huntlog Status
... View more
11-11-2019
05:13 AM
The Error "Couldn't load from 'C: mpp\htdocs\AXLAPI.wsdl' " seems to be because you reffer to C: mpp not C:\xmpp or it is a copy mistake. I would suggest you put your wsdl and php file in one folder. The you can reffer to /AXLAPI.wsdl or create a subdirectory maybe AXL the reffer to /AXL/AXLAPI.wsdl
... View more
11-11-2019
02:15 AM
Where is your application running? I would say that the device dos not trust the certificate presented from CUCM.
... View more
11-11-2019
02:13 AM
I think the Problem is not the UDP is logged in but the Hardphone is. So you will have to connect the UDP and "real" Phone. If you have a look into CUCM the UDP dos not have the option "Logged Into Hunt Group". So if you combine mine SQL and yours you will have SEP USER UDP Linegroup hlog
... View more
11-11-2019
01:37 AM
Split it in two seperate AXl Requests. Make a loop to work on after another. This should help. Otherwies what's your reutrned Error Message?
... View more
11-11-2019
01:36 AM
As far as i see you have an error in SOAP Client. This might be because this is not active in your php.ini Do the following: Locate php.ini in your xampp folder Remove the ; from the beginning of extension=php_soap.dll Restart your web server Look up your phpinfo(); again and check if you see a similar picture to the one above If you do, problem solved!
... View more
11-07-2019
11:29 PM
What output are you searching for? What infomration should be included? Do you need the UDP, the SEP or just the information who is logged in into Hunt group?
... View more
11-06-2019
11:01 PM
Try this one: select d.name as sep_device, eu.userid as user , p.name as udp from extensionmobilitydynamic emd, device d, device p, enduser eu where emd.fkdevice=d.pkid and emd.fkdevice_currentloginprofile=p.pkid and emd.fkenduser=eu.pkid This will give you the SEP, logged in UDP and the related user.
... View more
11-01-2019
12:36 AM
Well great that it did work now but i would say this is not how it should be. Why is the input different than the axl get output? Strange behavior i did not have in prior AXL Versions.
... View more
12-03-2019
I think the DN you try to use does not exist. Please verify.If it is
like this first add the line.
11-18-2019
Just try this SQL Statement:select lg.name as LineGroup, sep.name as
SEP, udp.name as UDP, n.dnorpat...
11-16-2019
If there is no Error the SQl Syntax is ok.If there is no Result there
has been no match.At the momen...
11-14-2019
I see the mistake.There is a double where.Use this one:select lg.name as
LineGroup, sep.name as SEP,...
11-12-2019
Try this oneselect lg.name as LineGroup, sep.name as SEP, udp.name as
UDP, n.dnorpattern as DN ,dhd....
Created by
thedd
in Management
11-11-2019
11-11-2019
The Error "Couldn't load from 'C: mpp\htdocs\AXLAPI.wsdl' "seems to be
because you reffer to C: mpp ...
11-11-2019
Where is your application running?I would say that the device dos not
trust the certificate presente...
11-11-2019
I think the Problem is not the UDP is logged in but the Hardphone is.So
you will have to connect the...
11-11-2019
Split it in two seperate AXl Requests.Make a loop to work on after
another.This should help. Otherwi...
Created by
thedd
in Management
11-11-2019
11-11-2019
As far as i see you have an error in SOAP Client.This might be because
this is not active in your ph...
11-07-2019
What output are you searching for?What infomration should be included?
Do you need the UDP, the SEP ...
11-06-2019
Try this one:select d.name as sep_device, eu.userid as user , p.name as
udp from extensionmobilitydy...
Public Statistics
| Date Registered | 02-02-2016 05:53 AM |
| Date Last Visited | 12-13-2019 01:16 PM |
| Total Messages Posted | 46 |
| Total Helpful Votes Received | 1 |
