distinct didnt work, same number of results. Each Index is being repeated 6 times.

The only columns where the value changes are:

--sys.partitions (partition id,hobt_id)

--sys.allocation_units (allocation_unit_id,container_id,total_pages,used_pages,data_pages)

--computed column - index size (which uses the above columes to compute data)

Any help please to avoid the duplicates?