Kronodesk DB structure

Monday, May 7, 2018
Avatar

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
Avatar
inflectra.jimx
re: vjordanova Monday, May 7, 2018

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
Avatar
re: inflectra.jimx Tuesday, May 8, 2018

Thanks, Jim!

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

 

Statistics
  • Started: Monday, May 7, 2018
  • Last Reply: Tuesday, May 8, 2018
  • Replies: 2
  • Views: 6511