→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎03-31-2015 06:13 PM
Solved! Go to Solution.
‎03-31-2015 07:19 PM
Select Top 1000000 tblAssetCustom.AssetID,
tblAssets.AssetUnique,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber As [Identifying Number],
tblAssetCustom.PurchaseDate As [Purchase Date],
tblAssetCustom.Warrantydate As [Warranty Expiration]
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.Warrantydate < GetDate() And tsysAssetTypes.AssetTypename
In ('switch', 'router') And tblAssetCustom.State = 1
Order By [Warranty Expiration] Desc
‎04-01-2015 11:24 AM
‎03-31-2015 09:00 PM
‎03-31-2015 07:19 PM
Select Top 1000000 tblAssetCustom.AssetID,
tblAssets.AssetUnique,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber As [Identifying Number],
tblAssetCustom.PurchaseDate As [Purchase Date],
tblAssetCustom.Warrantydate As [Warranty Expiration]
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.Warrantydate < GetDate() And tsysAssetTypes.AssetTypename
In ('switch', 'router') And tblAssetCustom.State = 1
Order By [Warranty Expiration] Desc
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now