→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
dallas4u
Engaged Sweeper
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.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
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