cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
MrCount
Engaged Sweeper III
Hi,

I have this report for showing some details in changes.
Is it possible to show the users Fullname from tblUsers?

If I add the table tblUsers and select Fullname to be shown, the report has multiple lines from the same user but some other entries are not shown anymore.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssetUserRelations.Username,
tblAssetUserRelations.Lastchanged,
tblAssetCustom.Custom1 As Inventarnummer,
tblAssetCustom.Custom2 As Kostenstelle,
tblAssets.Description,
tblAssetCustom.OrderNumber,
tblAssetCustom.Serialnumber,
tblAssetCustom.Location,
tblAssets.Firstseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetUserRelations On tblAssets.AssetID =
tblAssetUserRelations.AssetID
Inner Join tblUsers On tblAssets.AssetID = tblUsers.AssetID
Where tblAssetCustom.State = 1
Order By tblAssetUserRelations.Lastchanged Desc
0 REPLIES 0

New to Lansweeper?

Try Lansweeper For Free

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

Try Now