Inflectra Customer Forums: Kronodesk DB structure (Thread) 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? en-US(C) Copyright 2006-2024 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/kronodesk/issues-questions/1847.aspxthreadId=1847Venelina Jordanova (vjordanova@delftdi.com)DB StructureKronodesk 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? Mon, 07 May 2018 16:11:43 -04002018-05-08T15:45:59-04:00/Support/Forum/kronodesk/issues-questions/1847.aspxmessageId=3276Jim R (donotreply5@kronodesk.net) Hi Please use something like: SELECT NAME, COUNT(*) AS DupeCount FROM KRN_TICKET GROUP BY NAME H Hi Please use something like: SELECT NAME, COUNT(*) AS DupeCount FROM KRN_TICKET GROUP BY NAME HAVING COUNT(*) > 0 Regards Jim Tue, 08 May 2018 13:43:34 -04002018-05-08T13:43:34-04:00/Support/Forum/kronodesk/issues-questions/1847.aspx#reply3276messageId=3277Venelina Jordanova (vjordanova@delftdi.com) Thanks, Jim! Thanks, Jim! Tue, 08 May 2018 15:45:59 -04002018-05-08T15:45:59-04:00/Support/Forum/kronodesk/issues-questions/1847.aspx#reply3277