→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
SADAMS1980
Engaged Sweeper
Is there anyway to add the serial number column to the computers in 'domain' page, as it would be really handy to have the serial numbers listed on the page with the other columns without having to go into the individual assets?

Cheers
1 ACCEPTED SOLUTION
Jeremy_D
Champion Sweeper
Only reports found in the Reports tab can be customized, unfortunately. The only way for you to add the serial number to your report is to recreate the same report including an extra column for the serial number.

I included the report below that adds the serial number for the computer to the report. Instructions for adding this report to your Lansweeper installation can be found here. You can filter the computer domain within the report results. I recommend the following if you are interested in building or modifying reports:
  • Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  • Making use of the database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here.

Select Top 1000000 Case Coalesce(tblAssets.OScode, '')
When '' Then 'notscanned.png' Else tsysOS.Image End As Icon,
tblAssets.AssetName,
tblAssets.AssetID,
tblAssets.IPAddress As [IP Address],
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber,
Case Coalesce(tblAssets.OScode, '') When '' Then 'Not scanned'
Else tsysOS.OSname End As OS,
tblAssets.SP,
tblAssets.Memory,
tblAssets.NrProcessors As [Proc],
tblAssets.Processor,
tblAssets.Lastseen,
tblAssetCustom.State As thestate
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Outer Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssets.Assettype = -1
Order By tblAssets.AssetName

View solution in original post

1 REPLY 1
Jeremy_D
Champion Sweeper
Only reports found in the Reports tab can be customized, unfortunately. The only way for you to add the serial number to your report is to recreate the same report including an extra column for the serial number.

I included the report below that adds the serial number for the computer to the report. Instructions for adding this report to your Lansweeper installation can be found here. You can filter the computer domain within the report results. I recommend the following if you are interested in building or modifying reports:
  • Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  • Making use of the database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here.

Select Top 1000000 Case Coalesce(tblAssets.OScode, '')
When '' Then 'notscanned.png' Else tsysOS.Image End As Icon,
tblAssets.AssetName,
tblAssets.AssetID,
tblAssets.IPAddress As [IP Address],
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber,
Case Coalesce(tblAssets.OScode, '') When '' Then 'Not scanned'
Else tsysOS.OSname End As OS,
tblAssets.SP,
tblAssets.Memory,
tblAssets.NrProcessors As [Proc],
tblAssets.Processor,
tblAssets.Lastseen,
tblAssetCustom.State As thestate
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Outer Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssets.Assettype = -1
Order By tblAssets.AssetName