question CMDB Query / duplicate rows in Developer forum

CMDB Query / duplicate rows

drslry2 — Thu, 29 Feb 2024 16:22:39 GMT

Hi Gurus,

I have a CMDB query that is the source for a report, it appears each time the query executes it doubles the number of records found on the report. Is there a way to return the distinct records or at least the latest result set, not including previous runs of the query....

Re: CMDB Query / duplicate rows

Sohithanjan G — Thu, 29 Feb 2024 16:26:06 GMT

Hi @drslry2,

Can you please provide the query you are trying to run, to know more ?

Re: CMDB Query / duplicate rows

Dr Atul - LNG — Thu, 29 Feb 2024 16:29:46 GMT

Its look duplicate, but seems 1/ 2 field must be different like parent or child.

Re: CMDB Query / duplicate rows

drslry2 — Thu, 29 Feb 2024 16:30:02 GMT

Here's the query, thanks for the reply...

Re: CMDB Query / duplicate rows

AshishKM — Thu, 29 Feb 2024 16:53:22 GMT

some table relationship is creating this duplicate result ( if so ), you can detach one-by -one OR condition class and check the result. This way you will get the "causing" class.

Re: CMDB Query / duplicate rows

drslry2 — Thu, 29 Feb 2024 16:57:25 GMT

Does the duplicate 'problem' occur when the query is run multiple times, ie if the query runs 3x in one day, then there are three versions of the returned results?

Re: CMDB Query / duplicate rows

Dr Atul - LNG — Thu, 29 Feb 2024 16:59:55 GMT

No, @drslry2

I agree with @AshishKM its class creating issue and some thing similar i said 🙂

Re: CMDB Query / duplicate rows

Mercedes Pons 1 — Tue, 20 Aug 2024 20:26:43 GMT

Hi, this happened to me and I found out that when I create the report directly from Query Builder interface, it creates a report that is updated, and it doesn't duplicate the results every time the schedule runs.

When I create the reports from "Create Report" and select the Table query, it's when i get duplicates, but if I create the report from the Query Builder interface, it works fine. I hope it helps.

Re: CMDB Query / duplicate rows

MichaelScotland — Sun, 16 Feb 2025 23:20:37 GMT

In short, when you use the report select the cmdb query result as the Report Source and not the Table. If you use the Table as Data source you will see duplicates for every time the report runs.