→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Esben_D
Lansweeper Employee
Lansweeper Employee
In light of the closing Windows 7 EOL date, you can use the report below to check whether your workstation are ready for a Windows 10 upgrade.

The report checks the hardware requirements and if an in-place upgrade is possible or not. The specifications were taken form the Microsoft website.



Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
CPU.[CPU speed],
RAM.RAM,
Case
When tblAssets.AssetID = freespace.AssetID Then 'OK'
Else 'Not OK'
End As [Disk space],
tsysOS.OSname As OS,
tblAssets.SP,
tblComputersystem.SystemType As Architecture,
Case
When tsysOS.OSname = 'Win 7' And tblAssets.SP = 1 And RAM.RAM = 'OK' And
CPU.[CPU speed] = 'OK' And tblAssets.AssetID = freespace.AssetID
Then 'Yes'
When tsysOS.OSname Like '%8.1%' And RAM.RAM = 'OK' And CPU.[CPU speed] =
'OK' And tblAssets.AssetID = freespace.AssetID Then 'Yes'
Else 'No'
End As [In-place upgrade ready],
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysIPLocations.IPLocation,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join (Select Top 1000000 tblAssets.AssetID,
Case
When tblProcessor.MaxClockSpeed > 1000 Then 'OK'
Else 'Not OK'
End As [CPU speed]
From tblAssets
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID) As
CPU On CPU.AssetID = tblAssets.AssetID
Left Join (Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblComputersystem.SystemType,
Sum(Cast(Cast(tblPhysicalMemory.Capacity As bigint) / 1024 /
1024 As numeric)) As Memory,
Case
When tblComputersystem.SystemType Like '%64%' And
Sum(Cast(Cast(tblPhysicalMemory.Capacity As bigint) / 1024 /
1024 As numeric)) >= 2048 Then 'OK'
When tblComputersystem.SystemType Like '%86%' And
Sum(Cast(Cast(tblPhysicalMemory.Capacity As bigint) / 1024 /
1024 As numeric)) >= 1024 Then 'OK'
Else 'Not OK'
End As RAM
From tblAssets
Inner Join tblComputersystem On
tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblPhysicalMemory On
tblAssets.AssetID = tblPhysicalMemory.AssetID
Group By tblAssets.AssetID,
tblAssets.AssetName,
tblComputersystem.SystemType,
tblAssets.Memory) As RAM On RAM.AssetID = tblAssets.AssetID
Left Join (Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric)
As free,
tblComputersystem.SystemType
From tblAssets
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblComputersystem On
tblAssets.AssetID = tblComputersystem.AssetID
Where (Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 /
1024 As numeric) > 32000 And tblComputersystem.SystemType Like '%64%')
Or
(Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As
numeric) > 16000 And tblComputersystem.SystemType Like '%86%')) As
freespace On freespace.AssetID = tblAssets.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tsysOS.OSname <> 'Win 10' And tblState.Statename = 'Active' And
tblComputersystem.Domainrole < 2
Order By tblAssets.Domain,
tblAssets.AssetName
2 REPLIES 2
warlock1663
Engaged Sweeper
How do you use this to run as a report?
aplechaty
Engaged Sweeper II
I ran this report and compared it to a system check i did in February based on processors. This report only found like 5 systems not able to be upgraded. The report I ran in February gave me almost 20 systems and none of those matched the ones I found with this report. I am not sure which is right. Are the processor requirements part of this report?