HDD Report

[nagendra]

i need to generate a report with these fields

Hostname
IP ADDRESS
HDD0
HDD0 serial
HDD1
HDD1 Serial
HDD2
HDD2 Serial
HDD3
HDD3 Serial
HDD4
HDD4 Serial
HDD5
HDD5 Serial
HDD6
HDD6 Serial
HDD7
HDD7 Serial

[Nick_VDB · Accepted solution]

We have added a report below that will give back the hard disks and the information you requested related to them. Do note that the report will give back the different hard drives in rows and not columns. It is possible to make them appear in columns however this requires advanced SQL techniques for which we unfortunately cannot give support. It would also require the use of SQL Server and not SQL Compact. Instructions for adding this report to your Lansweeper installation can be found here.

Select Distinct Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tblAssets.IPAddress,
  tblAssets.Domain As Domain,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblFloppy.Name,
  tblFloppy.SerialNumber,
  tblFloppy.Model,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName