Custom report showing duplicates

[mastj25]

I have attempted to create a custom report starting from a system report and building from there. I am new to Lansweeper and am not sure where my issue is that I am getting duplicate results (sometimes 2 sometimes 10 duplicates). Here is what I have, any help would be appreciated.

Select Top 1000000 tblcomputers.ComputerUnique, Web40OSName.OSname,
tblOperatingsystem.Description, tblDiskdrives.Caption,
Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) As
Free, Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) As
[Total size], Cast(Cast(tblComputersystem.TotalPhysicalMemory As bigint) /
1024 / 1024 As numeric) As [Total Memory], Web40OSName.Compimage As icon,
tblPROCESSOR.NumberOfCores, tblPROCESSOR.NumberOfLogicalProcessors,
tblPROCESSOR.MaxClockSpeed
From tblcomputers Inner Join
tblDiskdrives On tblcomputers.Computername = tblDiskdrives.Computername
Inner Join
tblOperatingsystem On tblcomputers.Computername =
tblOperatingsystem.Computername Inner Join
web40ActiveComputers On tblcomputers.Computername =
web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblcomputers.Computername Inner Join
tblComputersystem On tblcomputers.Computername =
tblComputersystem.Computername Inner Join
tblPROCESSOR On tblcomputers.Computername = tblPROCESSOR.Computername
Where Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) <> 0 And
tblComputersystem.Domainrole > 1 And tblDiskdrives.DriveType = '3'
Order By tblcomputers.ComputerUnique, Cast(Cast(dbo.tblDiskdrives.Freespace As
bigint) / 1024 / 1024 As numeric), dbo.tblDiskdrives.CaptionComputer

[dsnyrs]

So is there a way to suppress these duplicates?

[Hemoco]

dsnyrs wrote:
So is there a way to suppress these duplicates?

We recommend creating separate reports for disks and processors. Note that there will still be one line per disk/processor.

[Hemoco · Accepted solution]

This is expected behavior if you have multiple disks and/or multiple processors. There will be one line per record.