Kronodesk DB structure

Monday, May 7, 2018 4:11:43 PM

Hi, I need to check for entries with duplicate names. Our helpdesk can execute a query for me, but they need to have the working query. In general I need something like this (but I do not have a way to know the DB tables and fields names)

    SELECT [NameColumn], COUNT(*) AS dupeCount
    FROM [Helpdek Tickets]
    GROUP BY [NameColumn]
    HAVING COUNT(*) > 1
 

Can somebody help with the correct names?

2 Replies
Tuesday, May 8, 2018 1:43:34 PM
Avatar
re: vjordanova on Monday, May 7, 2018 4:11:43 PM

Hi

Please use something like:

SELECT NAME, COUNT(*) AS DupeCount
FROM KRN_TICKET
GROUP BY NAME
HAVING COUNT(*) > 0

Regards

Jim

Tuesday, May 8, 2018 3:45:59 PM
Avatar
re: inflectra.jimx on Tuesday, May 8, 2018

Thanks, Jim!

Statistics
  • Started: Monday, May 7, 2018 4:11:43 PM
  • Last Reply: Tuesday, May 8, 2018 3:45:59 PM
  • Replies: 2
  • Views: 349