Select Top 1000000 tblAssetCustom.AssetID, tblAssets.AssetUnique, tsysOS.OSname, tblAssetCustom.Model, tblAssetCustom.Serialnumber, tblAssetCustom.PurchaseDate As [Purchase Date], tblAssetCustom.Warrantydate As [Warranty Expiration], tsysOS.Image As icon From tblAssetCustom Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode Where tblAssetCustom.Warrantydate < GetDate() + 30 And tblAssetCustom.Warrantydate > GetDate() And tblComputersystem.Domainrole < 2 And tblAssetCustom.State = 1 Order By [Warranty Expiration] Desc
Explore the full platform, free for 14 days.
No credit card required.