Notification

Icon
Error

Windows 10 readiness report

Posted: Wednesday, April 24, 2019 11:01:07 AM(UTC)
Esben.D

Esben.D

Member Administration Original PosterPosts: 1,765
2
Like
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.

Code:
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
aplechaty
#1aplechaty Member Posts: 5  
posted: 5/10/2019 1:55:30 PM(UTC)
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?
warlock1663
#2warlock1663 Member Posts: 15  
posted: 5/16/2019 2:49:43 PM(UTC)
How do you use this to run as a report?

Active Discussions

Lansweeper Modify "....less than 1GB free HD..." Report
by  Cripple.Zero   Go to last post Go to first unread
Last post: 8/15/2019 7:11:10 PM(UTC)
Lansweeper Individual asset compliance
by  ToeCutter  
Go to last post Go to first unread
Last post: 8/15/2019 11:40:57 AM(UTC)
Lansweeper Nvidia August Security Bulletin
by  Esben.D   Go to last post Go to first unread
Last post: 8/14/2019 9:00:17 AM(UTC)
Lansweeper Patch Tuesday report, last 3 months
by  Esben.D  
Go to last post Go to first unread
Last post: 8/14/2019 8:40:45 AM(UTC)
Lansweeper Help Desk report charted by Fiscal Year
by  Tom Londe   Go to last post Go to first unread
Last post: 8/12/2019 11:39:05 PM(UTC)
Lansweeper Windows: Unauthorized Administrators (Built-in)
by  bnishan  
Go to last post Go to first unread
Last post: 8/12/2019 9:02:30 PM(UTC)
Report Center Top 5 Average RAM Usage
by  AlbertD   Go to last post Go to first unread
Last post: 8/12/2019 5:36:20 PM(UTC)
Lansweeper SWAPGS Report
by  Bginchereau  
Go to last post Go to first unread
Last post: 8/12/2019 2:25:22 PM(UTC)