cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ahcomput
Engaged Sweeper
I am trying to print a report for a Windows Server Asset and have it contain the Warranty Information that is displayed on the "Summary" view of the asset web page.

When I cliek on the report tab of the asset web page, this report doesn't list the warranty status. I am guessing I would need to edit this report to include it, but don't know the name of the report to edit or where it's located.

Also on this report I would like to show free hard drive space graphically depicted as on the summary page rather than just the byte count that this report shows.

I'm trying to produce reports that will be given to a new client as part of a new client audit report to give them a general picture of servers/switches/firewalls/computers/ etc. that are on their network and our reccommendations to remedy any issues.

Any help here is appreciated.

1 REPLY 1
Hemoco
Lansweeper Alumni
The "Report" tab of an asset's Lansweeper webpage cannot be edited. You can create a custom report to list the information you are after instead. A sample report that includes disk and warranty info can be seen below.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
Convert(nvarchar,tblAssets.Firstseen,101) As Firstseen,
Convert(nvarchar,tblAssets.Lastseen,101) As Lastseen,
tsysOS.Image As icon,
Convert(nvarchar,tblAssetCustom.PurchaseDate,101) As PurchaseDate,
Convert(nvarchar,tblWarrantyDetails.WarrantyStartDate,101) As
WarrantyStartDate,
Convert(nvarchar,tblWarrantyDetails.WarrantyEndDate,101) As WarrantyEndDate,
tblWarrantyDetails.ServiceType,
Convert(nvarchar,tblWarranty.ShipDate,101) As ShipDate,
tblWarranty.PurchaseCountry,
tblDiskdrives.Caption As [Disk],
Ceiling(tblDiskdrives.Freespace / 1024 / 1024) As FreeMB,
Ceiling(tblDiskdrives.Size / 1024 / 1024) As TotalMB
From tblAssets
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblWarranty On tblAssets.AssetID = tblWarranty.AssetId
Inner Join tblWarrantyDetails On tblWarranty.WarrantyId =
tblWarrantyDetails.WarrantyId
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssetCustom.State = 1 And tblDiskdrives.DriveType = 3
Order By tblAssets.Domain,
tblAssets.AssetName,
[Disk]