CallManager Query Script

Unanswered Question

Hi,


Is there a way to query CallManager?


In particular, we are trying to query the hunt group login status of certain phones. We used to be able to do this, when we used CallManager Express, by way of a PHP script which was linked to a webpage displaying which phones were logged in to the hunt group.


We've tried the same script with CallManager and it doesn't seem to work.


(We are using Callmanager version 7.0.2)


Any advice appreciated.


Thanks,

YM

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 4.7 (3 ratings)
Loading.

Thanks.


Basically, what we're trying to do is periodically query (every 60 seconds, for example) the 'hunt group' status, so we can tell which phones are currently logged into the hunt group.


From what I can gather (please correct me if I'm mistaken), the available options are either Administrative XML (AXL) Programming - in which you are able to make changes to the CM database, or Serviceability XML Programming - which is passive and used to query CM.


I did see "getAttendantConsoleHuntGroup", in the XML Developers Guide, but do you have any advice on how to use this?


Thanks

Hi,


I think (but not sure) the "getAttendantConsoleHuntGroup" is used to view the status of attendant. But it is perrhaps related to the attendant PC application.


Your problem is about a LineGroup and I don't know simple method to do it.


The solution I imagine is to create a IP Phone services which do the same work as the hlog button (via AXL) and keeps a database of ip phone status.


But it is more complicate than just querry the CUCM to get the LineGroup Status ...


rate if it helps,


Rémy



dhook Mon, 10/26/2009 - 08:38
User Badges:

Hi,


It it is the HLog status of a line group member You need You can read the status from the SQL table "devicehlogdynamic". This table contains a boolan field with the Hlog status along with a field that shows the guid of the phone. See the database dictionary for more information. You can query the database through the AXL interface with the executeSQLQuery method.


I looked at the serviceability Hlog-data about a year ago, and as far as I remember You ca'nt get the info You want from there. The serviceability can provide things like received calls, missed calls etc.


Kind regards,


//Dan

dhook Fri, 10/30/2009 - 07:05
User Badges:

Hi,


Yes, indeed there is but You must query it through AXL with the executeSQLQuery method if You want something automated. If You just want to check out the tables manually You can run "run sql select * from devicehlogdynamic" in the CUCM CLI. The database dictionary describes the tables. You can download the dictionary from http://developer.cisco.com/web/axl/docs.

Actions

This Discussion