→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎09-25-2020 04:23 PM
Solved! Go to Solution.
‎09-25-2020 09:38 PM
Where (tsysOS.OSname In ('Win 2008 R2', 'Win 2012', 'Win 2012 R2', 'Win 2016',
'Win 2019') Or (tsysOS.OScode Like '10.0.18362' Or
tsysOS.OScode Like '10.0.18363' Or tsysOS.OScode Like '10.0.19041')) And
tblAssetCustom.State = 1 And tsysAssetTypes.AssetTypename Like 'Windows%' And
tblComputersystem.Domainrole In (4, 5)
‎10-23-2020 09:50 AM
‎10-01-2020 10:42 AM
‎09-29-2020 10:06 PM
‎09-28-2020 02:21 PM
‎09-25-2020 09:38 PM
Where (tsysOS.OSname In ('Win 2008 R2', 'Win 2012', 'Win 2012 R2', 'Win 2016',
'Win 2019') Or (tsysOS.OScode Like '10.0.18362' Or
tsysOS.OScode Like '10.0.18363' Or tsysOS.OScode Like '10.0.19041')) And
tblAssetCustom.State = 1 And tsysAssetTypes.AssetTypename Like 'Windows%' And
tblComputersystem.Domainrole In (4, 5)
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now