Jetzt Ausprobieren

Windows 10 Readiness Audit

Operating System Security

Getting ready for Windows 10 audit

Windows version are not supported forever. Running an unsupported version of Windows can be a significant security risk for your organization since those computers will no longer get critical security patches. Additionally, you won’t be able to rely on Microsoft for any issues regarding the operating system either. Once Windows 7 reaches end of life on 14 January 2020, it is important that you have finished moving all your computers to Windows 10 or another supported operating systems version. So don’t forget to run the audit and make sure to be getting your computers windows 10 ready. To check whether your current machines are ready for a Windows 10 upgrade, the audit below checks your computers for the Windows 10 minimum requirements and indicates whether an in-place upgrade is possible. With the help of the audit you can more effectively start planning how you will complete your Windows 10 migration. Win 10 Readiness audit

Windows 10 Readiness Query

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

Show

Hide