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

CUCM SQL Hunt List Request

Evgeny Udaltsov
Level 1
Level 1

Hi Team!

Could anybody help me with CUCM SQL Request. I have already written the request for getting details of Hunt List. Here it is:

 

   SELECT d.name AS HList,
          d.description AS HL_Description, 
          lg.name AS LGroup,
          lgmap.lineselectionorder AS LineSelectionOrder,
          ucmg.name AS UCMG
     FROM device AS d
LEFT JOIN routelist AS rl ON rl.fkDevice = d.pkid
LEFT JOIN linegroup lg ON rl.fklinegroup = lg.pkid
LEFT JOIN callmanagergroup ucmg ON d.fkcallmanagergroup = ucmg.pkid
LEFT JOIN linegroupnumplanmap AS lgmap ON lgmap.fklinegroup = lg.pkid
    WHERE d.name like 'HL_SPBXX_98123380'

It return the correct information about List, except "LineSelectionOrder"

 

              hlist        hl_description            lgroup lineselectionorder    ucmg
0 HL_SPBXX_98123380 SPB HL_SPBXX_98123380 LG_SPBXX_98123380                  1 Default
1 HL_SPBXX_98123380 SPB HL_SPBXX_98123380 LG_SPBXX_98123380                  0 Default
Executed

For example: Hunt List "HL_SPBXX_98123380" contain only one Line Group as a Member.
In fact, that the "LineSelectionOrder" must be equal "1", however the query returns 2 values.

Could anybody explain this behavior and suggest, how to fix it?

The UCM ver. 11.5

0 Replies 0
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: