Duplicate entrys in Report for Devices

[jbrewster]

When I run the report I get duplicate entries for each device that has more than 1 processor, code below

Select Top 1000000 tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Username,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblSystemEnclosure.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber,
tblOperatingsystem.Caption,
tblAssets.Processor,
tblAssets.NrProcessors,
tblPROCESSOR.NumberOfCores,
tblAssets.Memory,
TsysChassisTypes.ChassisName
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblPROCESSOR On tblAssets.AssetID = tblPROCESSOR.AssetID
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join TsysChassisTypes On tblSystemEnclosure.ChassisTypes =
TsysChassisTypes.Chassistype
Order By tblAssets.AssetUnique

Need to know what i need to do to stop duplication of devices,

[RCorbeil · Accepted solution]

Assuming the multiples are a result of multi-processor machines, add the following:

Where tblPROCESSOR.DeviceID = 'CPU0'

to only report on the first processor.