CMDB Query / duplicate rows

drslry2
Tera Contributor

‎02-29-2024 08:22 AM

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_0-1709223732881.png

 

0 Helpfuls
  • 743 Views
8 REPLIES 8

Sohithanjan G
Kilo Sage
Kilo Sage

‎02-29-2024 08:26 AM

Hi @drslry2, 

 

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

 

Please mark as Accepted Solution if this solves your query and HIT Helpful if you find my answer helped you. This will help other community mates too..:)
0 Helpfuls

drslry2
Tera Contributor
In response to Sohithanjan G

‎02-29-2024 08:30 AM

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

drslry2_0-1709224190422.png

 

0 Helpfuls

AshishKM
Kilo Patron
Kilo Patron
In response to drslry2

‎02-29-2024 08:52 AM - edited ‎02-29-2024 08:53 AM

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.


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution

Dr Atul G- LNG
Tera Patron
Tera Patron

‎02-29-2024 08:29 AM

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

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************