‎05-21-2015 04:24 PM
Solved! Go to Solution.
‎05-22-2015 02:49 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Model,
tblAssetCustom.Manufacturer,
tblAssetCustom.Serialnumber,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate
From tblAssets
Left Outer Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Left Join tblPortableBattery On tblAssets.AssetID = tblPortableBattery.AssetID
Where tblAssetCustom.Model Not Like '%virtual%' And
tblAssetCustom.Serialnumber Not Like '%virtual%' And
(tblAssetCustom.PurchaseDate < GetDate() - 365 Or
Coalesce(tblAssetCustom.PurchaseDate, '1900-01-01') = '1900-01-01') And
tblComputersystem.Domainrole < 2 And Coalesce(tblPortableBattery.AssetID, 0) =
0
Order By tblAssetCustom.PurchaseDate
‎05-22-2015 04:10 PM
‎05-22-2015 02:49 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Model,
tblAssetCustom.Manufacturer,
tblAssetCustom.Serialnumber,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate
From tblAssets
Left Outer Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Left Join tblPortableBattery On tblAssets.AssetID = tblPortableBattery.AssetID
Where tblAssetCustom.Model Not Like '%virtual%' And
tblAssetCustom.Serialnumber Not Like '%virtual%' And
(tblAssetCustom.PurchaseDate < GetDate() - 365 Or
Coalesce(tblAssetCustom.PurchaseDate, '1900-01-01') = '1900-01-01') And
tblComputersystem.Domainrole < 2 And Coalesce(tblPortableBattery.AssetID, 0) =
0
Order By tblAssetCustom.PurchaseDate
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now