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

View solution in original post

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