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
