I am working on a SQL query to list the device name, description, model, class type ,product, pool name and the associated DN if any using the following query: select a.name as device, a.description, b.name as pool, typemodel.name as model,p.name as product, c.name as class,n.dnorpattern as DN from device as a,numplan as n left join devicepool as b on a.fkdevicepool = b.pkid inner join typemodel on a.tkmodel=typemodel.enum inner join typeproduct as p on p.tkmodel = a.tkmodel inner join typeclass as c on c.enum = a.tkclass inner join devicenumplanmap as dnpm on dnpm.fkdevice = a.pkid where c.name="Phone" and dnpm.fknumplan = n.pkid and a.tkclass = 1 But i am not able to get the result. It's showing the error  An ON clause has an invalid table reference ... View more

I am using AXL to add a User in the CUCM. I am using the following AXL syntax: <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/9.1"> <soapenv:Header/> <soapenv:Body> <ns:addUser sequence="?"> <user> <firstName>John</firstName> <lastName>Doe</lastName> <userid>john.doe</userid> <password>1234</password> <mailid>jd@g.com</mailid> <department>IT</department> <enableMobility>T</enableMobility> <phoneProfiles> <profileName>john.doe_EM</profileName> </phoneProfiles> <associatedDevices> <device>SEP001F3A924223</device> </associatedDevices> </user> </ns:addUser> </soapenv:Body> </soapenv:Envelope> The above works when I remove the tags for adding defaultProfile and primaryExtension. As a turn around i used the SQL statement for adding the defaultProfile but I am still not able to add the primaryExtension. is there an SQL statement for that?  ... View more

I have the following AXL syntax for removing all the associations of devices from the User: <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <SOAP-ENV:Body> <axl:updateUser xmlns:axl="http://www.cisco.com/AXL/API/11.5" sequence="12055"> <userid>john.doe</userid> <associatedDevices> </associatedDevices> </axl:updateUser > </SOAP-ENV:Body> </SOAP-ENV:Envelope> I just keep the associated devices tag blank, and all the association is deleted. My problem is what if I have to remove a single association from a list of associatedDevices, how will the syntax be like. And after removing the association will the ownerUserName in the Phone config be removed. ... View more

I am working on a script to automate the adding of DN to Phone and than adding then making directory number association with a User. I am not able to figure out the AXL syntax for that, will it using SQL or there is some tag for it. ... View more

I am using Python to automate the User Device association, what I have achieved is making an association of device to a User using the following call: <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <SOAP-ENV:Body> <axl:updateUser xmlns:axl="http://www.cisco.com/AXL/API/1.0" sequence="12055"> <userid>ar</userid> <associatedDevices> <device>SEP12334555D455</device> </associatedDevices> </axl:updateUser > </SOAP-ENV:Body> </SOAP-ENV:Envelope> But now what I want to achieve is the association UserID in a Phone. is this possible with a single API call? What might the syntax of the XML be? ... View more