Modify Computer Warranty Overview with computers ONLY seen in last 30 days?

[dallas4u]

Hi... I have a custom report for Dell Warranty PCs only (that I called Warranty Overview Report) that I do use, but we are having issues with remote sites taking machines that have been replaced (because of being out of warranty) and putting them back in to use, newer Dell PCs not showing warranty info, and other things driving me up the wall. I have another report that shows me all PCs and includes the Dell warranty info, which is great... but I would like to modify it to ONLY show PCs that have been seen in the last 30 days. Can someone take a look at this for me and let me know what to add (or, if generous, add it in there!)?

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain, tblComputerSystemProduct.IdentifyingNumber, tblComputerSystemProduct.Name As Model, tblCompCustom.Warrantydate, 'Warranty Status' = Case When tblCompCustom.Warrantydate < GetDate() + 90 And tblCompCustom.Warrantydate > GetDate() Then 'Warranty Check Required' When tblCompCustom.Warrantydate < GetDate() Then 'Out Of Warranty' End From tblComputers Left Join tblComputerSystemProduct On tblComputers.Computername = tblComputerSystemProduct.Computername Left Join tblCompCustom On tblComputers.Computername = tblCompCustom.Computername Order By tblComputers.ComputerUnique

I tried modifying with WHERE info I found in another thread, but it threw errors... I just couldn't figure out how to get it correct.

Thanks.

[Hemoco · Accepted solution]

Please use the report below.

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain, tblComputerSystemProduct.IdentifyingNumber, tblComputerSystemProduct.Name As Model, tblCompCustom.Warrantydate, 'Warranty Status' = Case When tblCompCustom.Warrantydate < GetDate() + 90 And tblCompCustom.Warrantydate > GetDate() Then 'Warranty Check Required' When tblCompCustom.Warrantydate < GetDate() Then 'Out Of Warranty' End, tblComputers.Lastseen From tblComputers Left Join tblComputerSystemProduct On tblComputers.Computername = tblComputerSystemProduct.Computername Left Join tblCompCustom On tblComputers.Computername = tblCompCustom.Computername Where tblComputers.Lastseen > GetDate() - 30 Order By tblComputers.ComputerUnique