06-25-2013 02:41 AM
06-25-2013 01:53 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
Convert(nvarchar,tblAssets.Firstseen,101) As Firstseen,
Convert(nvarchar,tblAssets.Lastseen,101) As Lastseen,
tsysOS.Image As icon,
Convert(nvarchar,tblAssetCustom.PurchaseDate,101) As PurchaseDate,
Convert(nvarchar,tblWarrantyDetails.WarrantyStartDate,101) As
WarrantyStartDate,
Convert(nvarchar,tblWarrantyDetails.WarrantyEndDate,101) As WarrantyEndDate,
tblWarrantyDetails.ServiceType,
Convert(nvarchar,tblWarranty.ShipDate,101) As ShipDate,
tblWarranty.PurchaseCountry,
tblDiskdrives.Caption As [Disk],
Ceiling(tblDiskdrives.Freespace / 1024 / 1024) As FreeMB,
Ceiling(tblDiskdrives.Size / 1024 / 1024) As TotalMB
From tblAssets
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblWarranty On tblAssets.AssetID = tblWarranty.AssetId
Inner Join tblWarrantyDetails On tblWarranty.WarrantyId =
tblWarrantyDetails.WarrantyId
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssetCustom.State = 1 And tblDiskdrives.DriveType = 3
Order By tblAssets.Domain,
tblAssets.AssetName,
[Disk]
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now