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