→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎05-16-2014 09:14 PM
Solved! Go to Solution.
‎05-17-2014 12:45 AM
Where Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) <
1024 And Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) <>
0 And tblComputersystem.Domainrole < 2 And
tblDiskdrives.DriveType = 3 And tblAssetCustom.State = 1 And
tblAssets.AssetUnique + '~' + tblDiskdrives.Caption Not Like '%sunflower\1IP-01\1~E:%' And tblAssets.AssetUnique + '~' + tblDiskdrives.Caption Not Like '%sunflower\1IP-03\1~E:%' And
tblAssets.AssetUnique + '~' + tblDiskdrives.Caption Not Like '%sunflower\1IP-08\1~E:%' And tblAssets.AssetUnique + '~' + tblDiskdrives.Caption Not Like '%sunflower\1IP-12\1~E:%' And
tblAssets.AssetUnique + '~' + tblDiskdrives.Caption Not Like '%sunflower\1IP-13\1~E:%' And tblAssets.AssetUnique + '~' + tblDiskdrives.Caption Not Like '%sunflower\1IP-14\1~E:%' And
tblAssets.AssetUnique + '~' + tblDiskdrives.Caption Not Like '%sunflower\1IP-16\1~E:%' And tblAssets.AssetUnique + '~' + tblDiskdrives.Caption Not Like '%SUNFLOWER\TOPEK-TEMP\1~E:%' And
tblAssets.AssetUnique + '~' + tblDiskdrives.Caption Not Like '%SUNFLOWER\JC-CLD01\1~E:%' And tblAssets.AssetUnique + '~' + tblDiskdrives.Caption Not Like '%sunflower\1TRUST-THIN\1~E:%' And
tblAssets.AssetUnique + '~' + tblDiskdrives.Caption Not Like '%SUNFLOWER\1IS-NETADMIN6\1~D:%'
‎05-20-2014 11:05 PM
‎05-17-2014 02:49 AM
-- IF drive is E:
-- AND computer name matches (list)
-- THEN ignore it
NOT ( (tblDiskdrives.Caption LIKE '%E%')
AND ( tblAssets.AssetUnique LIKE '%1IP-01%'
OR tblAssets.AssetUnique LIKE '%1IP-03%'
OR tblAssets.AssetUnique LIKE '%1IP-08%'
OR tblAssets.AssetUnique LIKE '%1IP-12%'
OR tblAssets.AssetUnique LIKE '%1IP-13%'
OR tblAssets.AssetUnique LIKE '%1IP-14%'
OR tblAssets.AssetUnique LIKE '%1IP-16%'
OR tblAssets.AssetUnique LIKE '%TOPEK-TEMP%'
OR tblAssets.AssetUnique LIKE '%JC-CLD01%'
OR tblAssets.AssetUnique LIKE '%1TRUST-THIN%'
)
)
-- IF drive is 😧
-- AND computer name contains 1IS-NETADMIN6
-- THEN ignore it
AND NOT (tblAssets.AssetUnique LIKE '%1IS-NETADMIN6%' AND tblDiskdrives.Caption LIKE '%D%')
‎05-17-2014 12:45 AM
Where Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) <
1024 And Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) <>
0 And tblComputersystem.Domainrole < 2 And
tblDiskdrives.DriveType = 3 And tblAssetCustom.State = 1 And
tblAssets.AssetUnique + '~' + tblDiskdrives.Caption Not Like '%sunflower\1IP-01\1~E:%' And tblAssets.AssetUnique + '~' + tblDiskdrives.Caption Not Like '%sunflower\1IP-03\1~E:%' And
tblAssets.AssetUnique + '~' + tblDiskdrives.Caption Not Like '%sunflower\1IP-08\1~E:%' And tblAssets.AssetUnique + '~' + tblDiskdrives.Caption Not Like '%sunflower\1IP-12\1~E:%' And
tblAssets.AssetUnique + '~' + tblDiskdrives.Caption Not Like '%sunflower\1IP-13\1~E:%' And tblAssets.AssetUnique + '~' + tblDiskdrives.Caption Not Like '%sunflower\1IP-14\1~E:%' And
tblAssets.AssetUnique + '~' + tblDiskdrives.Caption Not Like '%sunflower\1IP-16\1~E:%' And tblAssets.AssetUnique + '~' + tblDiskdrives.Caption Not Like '%SUNFLOWER\TOPEK-TEMP\1~E:%' And
tblAssets.AssetUnique + '~' + tblDiskdrives.Caption Not Like '%SUNFLOWER\JC-CLD01\1~E:%' And tblAssets.AssetUnique + '~' + tblDiskdrives.Caption Not Like '%sunflower\1TRUST-THIN\1~E:%' And
tblAssets.AssetUnique + '~' + tblDiskdrives.Caption Not Like '%SUNFLOWER\1IS-NETADMIN6\1~D:%'
‎05-16-2014 11:39 PM
WHERE
(tblAssets.AssetUnique NOT LIKE '%1ip-08%' AND tblDiskdrives.Caption NOT LIKE '%E%')
AND Cast(Cast(tblDiskdrives.Freespace AS bigint) / 1024 / 1024 AS numeric) < 1024
AND Cast(Cast(tblDiskdrives.Size AS bigint) / 1024 / 1024 AS numeric) <> 0
AND tblComputersystem.Domainrole < 2
AND tblDiskdrives.DriveType = 3
AND tblAssetCustom.State = 1
WHERE
NOT (tblAssets.AssetUnique LIKE '%1ip-08%' AND tblDiskdrives.Caption LIKE '%E%')
AND Cast(Cast(tblDiskdrives.Freespace AS bigint) / 1024 / 1024 AS numeric) < 1024
AND Cast(Cast(tblDiskdrives.Size AS bigint) / 1024 / 1024 AS numeric) <> 0
AND tblComputersystem.Domainrole < 2
AND tblDiskdrives.DriveType = 3
AND tblAssetCustom.State = 1
‎05-16-2014 10:50 PM
‎05-16-2014 09:35 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now