Skip Navigation LinksHome Page > Forums > KronoDesk Forums > KronoDesk Issues & Questi... > Kronodesk DB structure
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?
Hi
Please use something like:
SELECT NAME, COUNT(*) AS DupeCount FROM KRN_TICKET GROUP BY NAME HAVING COUNT(*) > 0
Regards
Jim
Thanks, Jim!
And if you have any questions, please email or call us at +1 (202) 558-6885
