cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
jbrewster
Engaged Sweeper
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,
1 ACCEPTED SOLUTION
RCorbeil
Honored Sweeper II
Assuming the multiples are a result of multi-processor machines, add the following:
Where tblPROCESSOR.DeviceID = 'CPU0'
to only report on the first processor.

View solution in original post

1 REPLY 1
RCorbeil
Honored Sweeper II
Assuming the multiples are a result of multi-processor machines, add the following:
Where tblPROCESSOR.DeviceID = 'CPU0'
to only report on the first processor.