→ 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: 
juanmasdeu
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Nick_VDB
Champion Sweeper III
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

View solution in original post

1 REPLY 1
Nick_VDB
Champion Sweeper III
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

New to Lansweeper?

Try Lansweeper For Free

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

Try Now