CUACA 14.0.2 SQL query for 'Personal Directory Groups and Speed Dials'

[Alfredo Naranjo]

Hi Everyone, 

I have an issue with CUACA Client 14.0.2, with have to migrate the operators to another server and our customer wants to get all the "Personal Directory Groups" and "Speed Dials" manually created. the question is, are there SQL Queries to get that information? and wich are the way to take them?

[d.prasad]

Hi @Alfredo Naranjo 

Exporting speed dial numbers can be done in a single step. The speed dial data is stored in the dbo.Speed_Dials table within the ATTCFG database. You can use the SQL query below to retrieve the data.

SELECT [Speed_Dials_Unique_Ref]
,[Agent_Unique_Ref]
,[Number]
,[Name]
,[Company_Name]
FROM [ATTCFG].[dbo].[Speed_Dials]

Or you can export the data by right-clicking on the ATTCFG DB and selecting export. Use the import option in the new SQL Server to upload data.

If you run the SQL query, you can right-click on the result and select the option to export it to a CSV file.

The personal directory groups are not stored in a single table. Therefore, not sure how those are linked to each other.

Contact numbers are in dbo.Contact_Summary_Details

Personal directory groups' info is in the below tables.

dbo.Directory_Groups

[Alfredo Naranjo · Accepted solution]

Hi @d.prasad

I specially would like to thank you for all those information, I am going to try it and tell you something asap.

Best regards.

[Alfredo Naranjo · Accepted solution]

Hi @d.prasad 

I just did this sentence for Personal Directory Groups

SELECT [Agent_Unique_Ref]
      ,[Login_Name]
      ,[ATTCFG].[dbo].[Directory_Groups].[Directory_Group_Name]
      ,[ATTCFG].[dbo].[Contact_Summary_Details].[Last_Name]
      ,[ATTCFG].[dbo].[Contact_Summary_Details].[First_Name]
      ,[ATTCFG].[dbo].[Contact_Summary_Details].[Extension]       ,[ATTCFG].[dbo].[Contact_Summary_Details].[Department]
      ,[ATTCFG].[dbo].[Contact_Numbers].[Device_Type]
      ,[ATTCFG].[dbo].[Contact_Numbers].[Device_Number]
  
  FROM [ATTCFG].[dbo].[Agent_Details]
  JOIN [ATTCFG].[dbo].[Directory_Group_Allocations] ON [Agent_Unique_Ref] = [Allocation_Ref]
  JOIN [ATTCFG].[dbo].[Directory_Group_Numbers] ON [ATTCFG].[dbo].[Directory_Group_Allocations].[Directory_Group_Unique_Ref] = [ATTCFG].[dbo].[Directory_Group_Numbers].[Directory_Group_Unique_Ref]
  JOIN [ATTCFG].[dbo].[Directory_Groups] ON [ATTCFG].[dbo].[Directory_Group_Allocations].[Directory_Group_Unique_Ref] = [ATTCFG].[dbo].[Directory_Groups].[Directory_Group_Unique_Ref]  
  JOIN [ATTCFG].[dbo].[Contact_Summary_Details] ON [ATTCFG].[dbo].[Directory_Group_Numbers].[Contact_Unique_Ref] = [ATTCFG].[dbo].[Contact_Summary_Details].[Contact_Unique_Ref]  
  JOIN [ATTCFG].[dbo].[Contact_Numbers] ON [ATTCFG].[dbo].[Contact_Summary_Details].[Contact_Unique_Ref] = [ATTCFG].[dbo].[Contact_Numbers].[Contact_Unique_Ref]
where Login_Name = 'OPER02'
AND [ATTCFG].[dbo].[Contact_Summary_Details].[Last_Name] like '%PRUEBA_L%'

Best regards,