‎02-05-2019 02:10 PM
‎02-11-2019 10:03 PM
aplechaty wrote:
Good Morning,
I was wondering if anyone has created a report that will go through and determine which systems can run Windows 10. I have several hundred windows 7 systems and i need to know if they will run Windows 10. Any assistance is greatly appreciated as I am trying to find an easier way of determining which are compatible and so on. I know the processor needs to support PAE, NX, and SSE2.
Select Top 1000000 tblAssetCustom.Model As [Computer Model],
Count(tblAssetCustom.Model) As Total
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tsysOS.OSname Like '%Win 7%' And tblComputersystem.Domainrole < 2 And
tblAssetCustom.State = 1
Group By tblAssetCustom.Model
Order By Total Desc,
[Computer Model]
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now