Dublicate entries (multiple lines with assetname)
I am trying for a while now to get this to work, but still getting dublicates.How can i stop getting duplicates in the report?Thanks in advance.Select Top 1000000 htblusers.company As [Owner (Company)], htblusers.department As [Owner (Department)], ...