CMDB Query / duplicate rows

[drslry2]

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....

[drslry2]

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?

[Dr Atul G- LNG]

No, @drslry2 

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

[Mercedes Pons 1]

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.

[MichaelScotland]

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.