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

[Sohithanjan G]

Hi @drslry2, 

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

[drslry2]

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

[AshishKM]

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.

[Dr Atul - LNG]

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