→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎12-20-2017 10:56 AM
Solved! Go to Solution.
‎12-20-2017 11:29 AM
‎12-20-2017 05:20 PM
‎12-20-2017 03:18 PM
Convert(nvarchar,tblAssetCustom.PurchaseDate ,103) As Date
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
Convert(datetime,tblAssetCustom.Custom11,120) As Wartungsvertrag,
tblAssetCustom.Serialnumber,
Convert(nvarchar,tblAssetCustom.PurchaseDate,103) As [Purchase Date],
Convert(nvarchar,tblAssetCustom.Warrantydate,103) As [Warranty Expiration],
tsysAssetTypes.AssetTypename As Type,
tblAssets.IPAddress,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tblAssets.Lastseen
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Where tblAssetCustom.Custom11 < GetDate() + 60 And tblAssetCustom.Custom11 >
GetDate() And tblAssetCustom.State = 1
Order By [Warranty Expiration] Desc
‎12-20-2017 02:42 PM
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
Convert(datetime,tblAssetCustom.Custom11,120) As Wartungsvertrag,
tblAssetCustom.Serialnumber,
tblAssetCustom.PurchaseDate As [Purchase Date],
tblAssetCustom.Warrantydate As [Warranty Expiration],
tsysAssetTypes.AssetTypename As Type,
tblAssets.IPAddress,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tblAssets.Lastseen
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Where tblAssetCustom.Custom11 < GetDate() + 60 And tblAssetCustom.Custom11 >
GetDate() And tblAssetCustom.State = 1
Order By [Warranty Expiration] Desc
‎12-20-2017 11:29 AM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now