Need User/PC Report Help

[Quorthon]

I need to take an inventory of all computers, which is a little over 400, and generate a report with each computer and their last user. When I click on a PC I am able to view the last user for that specific one, is there a way I can generate a report for all computers displaying their last users. Thank You.

Example:

COMPUTER | LAST USER

pc101 | pparker
pc102 | bwayne
pc103 | ckent
pc104 | jchan
pc105 | blee

[Quorthon · Accepted solution]

Select Top 1000000 tblAssets.Username,
tblAssets.AssetName,
tblAssetCustom.Model,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.State = 1

[Quorthon]

Nevermind, I solved my own issue. I'm very new to Lansweeper and have just discovered generating custom reports. Thank You.