tag:blogger.com,1999:blog-4421651675096124175.post2261698120876855994..comments2024-03-02T21:14:43.287-08:00Comments on Unified Communications Guerrilla: Using SQL to Look at MOH Source ConfigurationsWilliam Bellhttp://www.blogger.com/profile/02559158040046322600noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-4421651675096124175.post-31026162150954424582014-01-28T14:45:11.046-08:002014-01-28T14:45:11.046-08:00Michael,
You cannot access real time information ...Michael,<br /><br />You cannot access real time information via the AXL API. However, you can access real time information via RISport API. I haven't addressed that heavily on this blog but I did do a write up a while ago on my company's blog site:<br /><br />http://www.netcraftsmen.net/blogs/entry/good-bye-devicelistxasp-hello-risport.html<br /><br />It is a tad dated. I should probably look into refreshing that content and bring it over to ucguerrilla.com. <br /><br />I have polled via SNMP but I found it to be somewhat cumbersome because you have to poll the mib tables independently on each UCM node. With RISPort, the API on one UCM node can provide the entire cluster view. You still have to contend with different registrations states as reported by each node (i.e. if a phone fails from one node to another, node A says "unregistered" while node B says "registered"). <br /><br />So, I'd recommend taking a closer look at RISport API.<br /><br />-Bill<br />UC Guerrillahttps://www.blogger.com/profile/14454391786438461256noreply@blogger.comtag:blogger.com,1999:blog-4421651675096124175.post-47793285221317636242014-01-27T10:31:58.795-08:002014-01-27T10:31:58.795-08:00Excellent series Bill, I'm digging deeper and ...Excellent series Bill, I'm digging deeper and deeper into CUCM AXL SQL queries and this site is very insightful. You mentioned CTI-specific queries, I'm interested in registration status, real time via AXL, and from another angle on the same issue, do you knowhow to/have you ever tried to poll (via SNMP) CTI specific information? <br /><br />Regards,<br /><br />MichaelMichaelnoreply@blogger.comtag:blogger.com,1999:blog-4421651675096124175.post-75082405091135368792013-02-04T08:43:07.425-08:002013-02-04T08:43:07.425-08:00Jimmy,
I assume by "status" you want to...Jimmy,<br /><br />I assume by "status" you want to know registration status. This information is not maintained in the DB. I believe you can retrieve real time information on CTI RPs and Ports from the RISport API. I use that API to get device (phone) registration info but it has a lot more data to offer in regards to real time/registration status.<br /><br />Interestingly enough, I have not explored the options of querying realtime from the CLI. Aside from using the "show perf query" command. Which does provide decent data even though it isn't very flexible.<br /><br />If I am off base with my assumption that you are looking for real time status info (e.g. registration) then let me know. I have several queries that focus on CTI-specific configurations. <br /><br />If you are looking for real time info then I don't have anything to brain dump at present. I would need to go to the source code on my RISport toolkit and see what there is to see with CTI (my toolkit focuses on phones at the moment).<br /><br /><br /><br />-Bill (@ucguerrilla)UC Guerrillahttps://www.blogger.com/profile/14454391786438461256noreply@blogger.comtag:blogger.com,1999:blog-4421651675096124175.post-47507720011844749582013-02-04T07:15:04.249-08:002013-02-04T07:15:04.249-08:00i am looking for a query where i can find the stat...i am looking for a query where i can find the status of a CTI Route Point in a Contact Center Environment.Anonymoushttps://www.blogger.com/profile/09718433741559154277noreply@blogger.comtag:blogger.com,1999:blog-4421651675096124175.post-53364993519399448822013-01-17T15:23:53.727-08:002013-01-17T15:23:53.727-08:00Will,
I wasn't thinking if/else logic here. I...Will,<br /><br />I wasn't thinking if/else logic here. I was thinking more of a basic value comparison in the where clause. Complex clauses with logic operators can get a decent filter going but the CLI doesn't let you do complex operations. It would be handy though!<br /><br />-Bill (@ucguerrilla)UC Guerrillahttps://www.blogger.com/profile/14454391786438461256noreply@blogger.comtag:blogger.com,1999:blog-4421651675096124175.post-63257587959401209362013-01-16T14:21:35.310-08:002013-01-16T14:21:35.310-08:00"You could compare the network hold source I..."You could compare the network hold source IDs to the device and only show records where those settings are inconsistent."<br /><br />Could you share an example of how to incorporate some sort of if/then/else logic into a sql query? That would come in handy for sure. The only way I've been able to do that till now is via multiple axl executesqlquery's and additional logic. It'd be extremely handy to be able to do that directly from the cli!Will Alvordnoreply@blogger.com