→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎01-11-2016 03:17 PM
Solved! Go to Solution.
‎01-13-2016 07:22 PM
‎01-22-2016 01:19 PM
Like 'LAP%' or Like 'CPU%'
‎01-20-2016 05:39 PM
‎01-20-2016 05:36 PM
WHERE
( tblAssetCustom.State = 1
AND tblComputersystem.Domainrole < 2
AND tblDiskdrives.DriveType = 3
AND tblDiskdrives.Caption = 'C:'
AND Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) < 10000
AND Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) <> 0
)
OR (tblAssets.AssetName Like 'LAP%')
OR (tblAssets.AssetName Like 'CPU%')
WHERE
tblAssetCustom.State = 1
AND tblComputersystem.Domainrole < 2
AND tblDiskdrives.DriveType = 3
AND tblDiskdrives.Caption = 'C:'
AND Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) < 10000
AND Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) <> 0
AND ( (tblAssets.AssetName Like 'LAP%')
OR (tblAssets.AssetName Like 'CPU%')
)
‎01-20-2016 04:50 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tsysOS.OSname,
tblDiskdrives.Caption,
Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) As
free,
Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) As
[total size],
tsysOS.Image As icon,
tblAssetCustom.Department,
tblAssetCustom.Contact,
tblAssetCustom.Building,
tblAssetCustom.Warrantydate,
tblAssets.AssetName
From tblAssets
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where (tblDiskdrives.Caption = 'C:' And Cast(Cast(tblDiskdrives.Freespace As
bigint) / 1024 / 1024 As numeric) < 10000 And Cast(Cast(tblDiskdrives.Size As
bigint) / 1024 / 1024 As numeric) <> 0 And tblComputersystem.Domainrole < 2
And tblDiskdrives.DriveType = 3 And tblAssetCustom.State = 1) Or
(tblAssets.AssetName Like 'LAP%') Or
(tblAssets.AssetName Like 'CPU%')
‎01-13-2016 07:22 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now