Adding tblCPlogoninfo table adds thousands of duplicated servers to my report

[kilimats]

I am a noob with custom reports

I was trying to add a column in my report to show who the last user was, so i dragged the tblCPlogoninfo datasource into the report graph view and selected the USERNAME asset, ran the report and i did see the the username listed (not sure if they were the last) but now it added thousand of duplicated server tomy report

how come? what am i doing wrong ?

this is the report i use

Select Top 1000000 tblAssets.Domain,
tblAssets.AssetID,
tblAssets.AssetName,
tblADComputers.Description,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssetCustom.Manufacturer As Vendor,
tblAssetCustom.Model,
tblAssets.IPAddress,
tblAssetCustom.Serialnumber,
tblAssets.Firstseen,
tblCPlogoninfo.Username
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Inner Join tblCPlogoninfo On tblAssets.AssetID = tblCPlogoninfo.AssetID
Where Not tblAssetCustom.Manufacturer = 'XEN' And tblComputersystem.Domainrole >
1 And tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName

[Hemoco · Accepted solution]

You don't need tblcplogoninfo, you can use field username/userdomain from tblassets.