4.1(3) Query

Unanswered Question
May 21st, 2008
User Badges:

Dear all,


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.


Anybody ?


Thanks


Steffen

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
stephan.steiner Wed, 05/21/2008 - 22:15
User Badges:
  • Silver, 250 points or more

There's no way to get it via one single query.. you always have to combine information from the database (axl) with information from the risport (devicelistx.asp for your ccm version)

Actions

This Discussion