From Cisco tech support:
Hello Alexander
Below are the queries provided by the DEV team
-- To get Queue Name and DDI
USE ATTCFG
SELECT QD.Queue_Name AS QueueName, QFI.Filter_Data AS DDI
FROM dbo.Queue_Details AS QD
INNER JOIN dbo.Queue_Filters AS QF ON QD.Queue_Unique_Ref = QF.Queue_Unique_Ref
INNER JOIN dbo.Queue_Filter_Items AS QFI ON QF.Filter_Unique_Ref = QFI.Filter_Unique_Ref
WHERE QD.Queue_Type = 'CNSLQ'
-- To get Operator Name and Queue Assosiations
USE ATTCFG
SELECT AD.Login_Name AS OperatorName, QD.Queue_Name AS QueueName
FROM dbo.Agent_Details AS AD
INNER JOIN dbo.Agent_Skills AS ASk ON AD.Agent_Unique_Ref = ASk.Agent_Unique_Ref
INNER JOIN dbo.Skill_Details AS SD ON ASk.Skill_Unique_Ref = SD.Skill_Unique_Ref
INNER JOIN dbo.Queue_Skills AS QS ON SD.Skill_Unique_Ref = QS.Skill_Unique_Ref
INNER JOIN dbo.Queue_Filters AS QF ON QS.Queue_Unique_Ref = QF.Queue_Unique_Ref
INNER JOIN dbo.Queue_Details AS QD ON QF.Queue_Unique_Ref = QD.Queue_Unique_Ref
WHERE AD.Login_Type = 'CNSLA' AND QD.Queue_Type = 'CNSLQ' ORDER BY OperatorName, QueueName
to cover all bases - The script that lists operator / queue associations will only show operators that have queues associated with them. (So if they have a operator that is not associated with any queue, this operator will be visible within the data export).
