→ 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: 
kilimats
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
You don't need tblcplogoninfo, you can use field username/userdomain from tblassets.

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
You don't need tblcplogoninfo, you can use field username/userdomain from tblassets.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now