Staff & Faculty computers and several info

[juanmasdeu]

Hello,

I created a report that lists all assets who have an assignment "used by" attached to them.
This report lists the computers and the user.
I wanted to add some more information about the computer so I can easily check everything there.
Things I'm missing from this report are:

PC Age, OS, Disk Size, RAM, Processor, Serial number, Model and IP Addess.

How can I add all this info to this report??

This is what I have:

Select Top 1000000 tblAssets.AssetID,
tblAssetUserRelations.Username,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon
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
Where tblAssetUserRelations.Type = 12 And tblAssetCustom.State = 1
Order By tblAssetUserRelations.Username

[Nick_VDB · Accepted solution]

Please use the report below for the information you are after. Instructions for adding this report to your Lansweeper installation can be found here.

Select Distinct Top 1000000 tblAssets.AssetID,
tblAssetUserRelations.Username,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblOperatingsystem.Caption As OS,
tblAssets.Memory As [RAM (MB)],
tblAssetCustom.Model,
tblNetworkAdapter.Speed As [Network Speed],
tblAssetCustom.Serialnumber,
tblAssets.Processor As CPU,
tblAssets.NrProcessors,
DateDiff(yy, tblBIOS.ReleaseDate, GetDate()) As [PC Age (Years)],
tsysAssetTypes.AssetTypeIcon10 As icon
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join tblAssetUserRelations
On tblAssets.AssetID = tblAssetUserRelations.AssetID
Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblNetworkAdapter On tblAssets.AssetID = tblNetworkAdapter.AssetID
Where tblAssetCustom.State = 1 And tblAssetUserRelations.Type = 12
Order By tblAssetUserRelations.Username