sorry for the delay that didn't work either and its actually not even spitting out an error; <? xml version = '1.0' encoding = 'UTF-8' ?> < soapenv:Envelope xmlns:soapenv = "http://schemas.xmlsoap.org/soap/envelope/" > < soapenv:Body > < ns:executeSQLQueryResponse xmlns:ns = "http://www.cisco.com/AXL/API/12.0" > < return/ > </ ns:executeSQLQueryResponse > </ soapenv:Body > </ soapenv:Envelope > i feel like we are getting close but i cant figure it out.
... View more
were you able to run this i am not able to run it gives me a syntax error it all looks like it should work but doesnt. i took out the double where and that wasnt it, below is the error i am getting. < faultcode > soapenv:Client </ faultcode > < faultstring > A syntax error has occurred. </ faultstring > < detail > < axlError > < axlcode > -201 </ axlcode > < axlmessage > A syntax error has occurred. </ axlmessage > < request > executeSQLQuery </ request >
... View more
i am trying to get the current logged in users for that hunt pilot, but my query is returning everything but UDP which is what they are logged in on their phones. so i tried adding UDP to the query and it didn't work, so ultimately what i am trying to accomplish is the ability to query who is currently logged in on the phone right now. your query returns the following for me; < return > < row > < sep_device > SEPB4A8B94DB8C0 </ sep_device > < user > 30057987 </ user > < udp > UDP30057987 </ udp > </ row > < row > which is fine but i am using python to display who is logged in by the <hlog>t</hlog> tag which i cant figure out how to add to your query. what i need returned to me is the hlog status of udp weather it is logged in or not and then the other information below. < row > < linegroup > HR_Benefits-LG </ linegroup > < name > TCT30056473 </ name > <-- This needs to Be UDP < description > User name is in description </ description > < dnorpattern >user number is here </ dnorpattern > < hlog > f </ hlog > <- This current status of UDP logged in or not </ row > also thank you for your help i really appreciate you taking the time to help me, i've been trying to figure this out for weeks and my sanity is dipping fast.
... View more
so this is close but doesnt have the devicehlogdynamic which is what i was using to tell me if they are logged in or not, but thank you this is a good start i will try and figure how to get dhd.log and limit to the two pilot groups
... View more
need help guys trying to get UDP from CUCM via AXL and i get everything but that below is my query and what it pulls, what i need it to pull is the UDP. my end game is to pull the logged in users and then use python flask to get that on a webpage to show who is logged in thanks for your help <ns:executeSQLQuery> <sql> select lg.name as LineGroup,d.name,d.description,n.dnorpattern,dhd.hlog 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 d on dmap.fkdevice=d.pkid inner join devicehlogdynamic as dhd on dhd.fkdevice=d.pkid where lg.name IN ('HR_Benefits-LG','HR_ServiceCenter-LG') order by lg.name </sql> </ns:executeSQLQuery> < return > < row > < linegroup > HR_Benefits-LG </ linegroup > < name > CSF555556473 </ name > < description > UserFirst UserLast </ description > < dnorpattern > \+15555558846 </ dnorpattern > < hlog > f </ hlog > </ row > < row > < linegroup > HR_Benefits-LG </ linegroup > < name > TCT555556473 </ name > < description >UserFirst UserLast </ description > < dnorpattern >\+15555558846 </ dnorpattern > < hlog > f </ hlog > </ row > < row > < linegroup > HR_Benefits-LG </ linegroup > < name > BOT555556473 </ name > < description >UserFirst UserLast </ description > < dnorpattern >\+15555558846 </ dnorpattern > < hlog > f </ hlog > </ row >
... View more