→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎11-26-2012 09:24 PM
Solved! Go to Solution.
‎11-28-2012 09:30 AM
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
‎11-28-2012 09:30 AM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now