jmlacoste Mon, 01/22/2007 - 04:31
User Badges:

Hello,


On CCM 4.x you can get the all list of IP Phone with Description and IP Address from request https://CCMHost/CCMAdmin/reports/devicelistX.asp


This is no more possible on CCM 5.x and this query use a lot of CCM CPU to get the IP Address.


So the best way is to use a SQLQuery AXL commands on the Device Table to get name and description column. You just need to filter on the tkClass=1 and tkDeviceProfile=0 column to get only the IP Phones.


Rgds,

JMLacoste

Jorge.Severino Mon, 01/22/2007 - 11:36
User Badges:

Hi,

can i do s SQLQuery to get the IP of the IP Phones?.. i al ready hay the Device name.. but i can't have the IP numbers from the phones..


Thnx in advance

jmlacoste Mon, 01/22/2007 - 21:22
User Badges:

No, the IP address is a realtime information.

On CCM 4.x you can get it easily from deviceListX.asp which returns an XML description including the IP address.


With CCM 5.x you are required to use Risport Web Service. Basically, you provide an Array of IP Phone names as parameter and get detailed IP Phone status including IP Address. Have a look to AXL Serviceability chapter in Cisco Unified CallManager Developers Guide for Release 5.0


Rgds,

JML



Jorge.Severino Tue, 01/23/2007 - 04:31
User Badges:

Hi JML,

I work with CCM 4.1(3).. and i can't use the GetDeviceIP.asp script.. cause CCM 4.x need SSL connection (https)..


This script came with the last SDK, and doesnt work to me. I try to modified, but i still cant make it work.


I just know the problem is the https... Can you help me with that??


Thnx in advance. (and sorry for my english, here we speak spanish :P)


Jorge Severino


jmlacoste Tue, 01/23/2007 - 07:21
User Badges:

Yes, you are right you must used https.


We use C# and it is very symple to use https. I can provide ou an example.


What language do you use ?


Rgds,

JM Lacoste

msabir Tue, 03/06/2007 - 11:59
User Badges:
  • Bronze, 100 points or more

Here are the steps you need to pull the phone list on CCM 4.x without requiring HTTPS/SSL:


1. Copy the following file on CCM:

c:\Ciscowebs\Admin\reports\devicelistx.asp


2. Call the new file anything you like, i.e devicelists_noSSL.asp


3. From the CCM Desktop, right click "My Computer" and select "Manage"


4. Select "Services And Applications" > Internet Information Services" > "Default Web Site" > "CCMAdmin" > "Reports"


5. Select the newly copied file (devicelistx_noSSL.asp) and right click properties.


6. Select "File Security" tab and click "Edit" under "Secure Communication".


7. Uncheck "Require SSL".


This will require SSL for all other CCM pages except devicelistx_noSSL.asp. You can then use this file to get the phone list without requiring SSL/HTTPS.


Cheers :)




Stefano Amici Thu, 03/08/2007 - 03:44
User Badges:

Anyone is able to get phone's Ip address from RisPort interface with CCM 5.x?

Hi JML,


Iam facing the problem with RisPort webservice to get the Ip address of the Phones

i also read the Cisco Unified CallManager developer Guide for Release 5.0(pdf) but iam not understanding can u please send me the sample code hoe to send the Array of IP phone names as a parameter,i tried that but iam getting empty values ,please send me the sample code it will be very useful for me

Thanks in advanced


Regards ,

Ravindra


my personal mail id is:"[email protected]

jmlacoste Sun, 05/20/2007 - 23:30
User Badges:

Hello,


here is piece of C# code that calls RIS.

pBy, pRegistered and pDeviceName are function parameters. wsRisPort5 is a C# proxy generated from RIS wsdl. IP address can be obtained then from CMDevice result IpAddress property. Hope it helps.


Rdgs,

JM Lacoste


--------------------------------------------


IPSWS.wsRisPort5.CmSelectionCriteria selCriteria = new IPSWS.wsRisPort5.CmSelectionCriteria();

selCriteria.Class = "Phone";

selCriteria.Model = 255; // all model

selCriteria.NodeName = ""; // all server

selCriteria.SelectBy = pBy;

selCriteria.MaxReturnedDevices = (UInt32)pDevName.Length;


if (pRegistered)

selCriteria.Status = "Registered";

else

selCriteria.Status = "Any";


IPSWS.wsRisPort5.SelectItem[] selItems = new IPSWS.wsRisPort5.SelectItem[pDevName.Length];


for (int i=0; i < pDevName.Length; i++)

{

selItems[i] = new IPSWS.wsRisPort5.SelectItem();

selItems[i].Item = pDevName[i];

}


selCriteria.SelectItems = selItems;

stateInfo = "";

IPSWS.wsRisPort5.SelectCmDeviceResult res = ris5.SelectCmDevice(ref stateInfo, selCriteria);


jmlacoste Thu, 03/08/2007 - 09:57
User Badges:

Yes, you can use SQLQuery AXL method and do a SELECT SQL query on device table to get name and description. You have to filter on tkDeviceProfile = 0, tkClass = 1 to get only ipPhone (and CTI port) device types. If you want to exclude CTI Port you also need to exclude tkModel = 72.


Rgds,

JML

Stefano Amici Mon, 03/12/2007 - 04:05
User Badges:

Hi JML,

are you answering me?


I can't get phone's ip adress by SQLQuery; i must use RisPort interface but the Cisco examples didn't work in my environment.


Regard,

Stefano

msabir Tue, 03/13/2007 - 10:17
User Badges:
  • Bronze, 100 points or more

It has been reported many times in this forum that Cisco's WSDL are broken and they need to be manually fixed to be used in market leading IDEs like visual Studio, NetBeans or Eclipse. Can anyone post the "fixed" WSDL files for CCM 4.1, 4.2 and 5.0?


Thanks


Actions

This Discussion