report duplicate rows

[drslry2]

Hey guys,

I'm having a problem when I click on one of my reports to drill into the details it brings back alot more records than it should, duplicate records are returned...

 ..it should only bring back about 7 distinct records, however its returning quite a more...

The source for the report is a cmdb query, could that have something to do with it....

is there a way to distinct these records somehow?

Any info would be greatly appreciated.

thanks,

Rob

[AndersBGS]

Hi @drslry2 ,

I would recommend you to look into how the cmdb query has been created in the query builder - seems something is not right if there should only be seven.

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up,

Best regards

Anders 

[drslry2]

I think it has something to do with the Create Report button being always greyed out even though I've loaded the results and created a schedule......

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

[drslry2]

Sounds good, I'll give it a try..thank you for your response.