cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
282
Views
0
Helpful
1
Replies

4.1(3) Query

Steffen.Baier
Level 1
Level 1

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 Reply 1

stephan.steiner
Spotlight
Spotlight

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)

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: