I am trying to get a detailed information out of our Call Manager 4.1(3)
Using the Devicelistx.asp only gives me a limited result.
Real Time Monitoring Tool gives me all the Information I need but only the first 200 Results.
I am basically looking for all devices on our system including the IP address of the device itself.
Both above Options give me the IP but I would like it all in one go.
At present I am using a SQL Query. The basic Version of it is:
SELECT Device.Name, NumPlan.DNOrPattern, DeviceNumPlanMap.Display,
TypeModel.Name AS Expr1
FROM DeviceNumPlanMap INNER JOIN
NumPlan ON DeviceNumPlanMap.fkNumPlan = NumPlan.pkid INNER JOIN
Device ON DeviceNumPlanMap.fkDevice = Device.pkid INNER JOIN
TypeModel ON Device.tkModel = TypeModel.Enum
WHERE (Device.Name like 'SEP%') and (DeviceNumPlanMap.NumPlanIndex = 1)
I am aware how to get the userID etc but I am missing the IP of the Device (7970 etc) itself.