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.