Warranty Overview Report Empty

[pmcnamara]

This has been frustrating me for some time, but now I actually need to start using some of these reports. There are many report in Lansweeper that have no data, and I would like to know what I need to do to get data in the reports? I just went through the reports section in the documentation and it really doesn't address it. I'm specifically interested in understanding the warranty overview report and any reports that store warranty information, purchase data, warranty expiration etc. The report I have shows no computers, even though I know i've got many that are out of warranty. Everything at this particular site is Dell so any help would be appreciated. Thanks in advance

[Hemoco]

The idea behind the warranty reports is that you first submit warranty information, manually or through the available third party tool. The reports will then notify you of upcoming warranty events.

[pmcnamara]

Well thank you for this. I guess I still don't understand the computer:warranty overview report (and why it's there if it doesn't populate data) but I'll find another way to do what I need done. Thank you for the sql code, i'll check it out.

[Hemoco]

Given how the report is structured, no. The report "Computer: Warranty overview" is set up so that computers without warranty info are not included. The report below will list all computers.

Select Top 1000000 tblCompCustom.Computername, tblComputers.ComputerUnique,
Web40OSName.OSname, tblComputerSystemProduct.Name As Model,
tblComputerSystemProduct.IdentifyingNumber As [Identifying Number],
tblCompCustom.PurchaseDate As [Purchase Date], tblCompCustom.Warrantydate As
[Warranty Expiration], Web40OSName.Compimage As icon
From tblCompCustom Right Join
tblComputers On tblCompCustom.Computername = tblComputers.Computername
Left Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Left Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername
Order By tblCompCustom.Warrantydate Desc

[pmcnamara]

but I'm talking about the actual warranty overview report that already exists in lansweeper. The report is completely empty, it doesn't even list the computers that are in the lansweeper domain listings. Shouldn't the computer data at least be in there?

[Hemoco]

Lansweeper does not automatically populate warranty fields. You can submit warranty info manually on computer webpages under "Custom Fields" or use a third party tool to automatically pull this information into your database. (Please note that we cannot provide support for these tools.)