→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
chrisjones
Engaged Sweeper II
Afternoon, i have the following querie for a custom report. However this creates duplicates when i run the report. Is there a way i can stop this from happening.

Thanks in advance

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblOperatingsystem.Caption As [OS name],
tblOperatingsystem.OtherTypeDescription,
tblAssets.Domain,
tblAssets.Memory,
tblAssetCustom.Manufacturer As [Computer Manufacturer],
tblBIOS.Manufacturer As [BIOS manufacturer],
tblBIOS.Caption As BIOS,
tblAssets.Assettype,
tblAssetCustom.Model,
tblAssetCustom.Location,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Processor,
tblAssets.Scanserver,
tblAssets.IPAddress,
tblAssetCustom.Department,
tblAssetCustom.Serialnumber,
tblAssetCustom.SystemSKU,
tblADusers.Name,
tblAssetCustom.State
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblADusers On tblAssets.Username = tblADusers.Username
Order By tblAssets.AssetName
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
TblADusers and tblAssets are incorrectly linked. This forum topic explains how to correctly link the tables.

View solution in original post

2 REPLIES 2
chrisjones
Engaged Sweeper II
Excellent thank you
Susan_A
Lansweeper Alumni
TblADusers and tblAssets are incorrectly linked. This forum topic explains how to correctly link the tables.