Windows 11 Readiness

The Windows 11 Readiness report shows Windows Computers and their overall Migration Readiness status.

From the Reports tab, you can build the Windows 11 Readiness report. To build the report:

1. Click the Report Builder button to bring up the Report Builder wizard
2. Enter the properties of the new report
   1. Name – Windows 11 Readiness
   2. Status – Enabled
   3. Published – No
   4. Data Source – Data Type: Computer
   5. Description – Report showing Computers and their Windows 11 Readiness status.
3. Add data columns to the report
   1. From the Add Column drop down, select Data Column to bring up the Data Column dialog
      
   2. Select the data columns of the new report from the Data Columns drop down and then click the Add button. Click the Close button to cancel the operation.
      1. Computer: Name
      2. Computer: Migration Status
      3. Computer: Description
      4. Computer: Location
      5. Computer: Region
      6. Computer: Domain
      7. Computer: Computer Type
      8. Computer: Operating System
      9. Computer: Os Build
      10. Computer: Os Version
      11. Computer: Disk Size Gb
      12. Computer: Serial
      13. Computer: Business Unit
      14. Computer: Department
      15. Computer: Computer Model
      16. Computer: Bios Version
      17. Computer: Memory Gb
      18. Computer: Free Disk Space Gb
      19. Computer: Site Ready
      20. Computer: In Etl
      21. Computer: WaaS Ready For Scheduling (Alias)
      22. Computer: Waves
      23. User: Name
      24. User: Ad Login Id
      25. User: Title
      26. User: Telephone
      27. User: Email
      28. User: Manager (Alias)
      29. User: Location
      30. User: Domain
      31. User: Business Unit
      32. User: Department
      33. User: Vip
      34. User: Legal Hold
      35. User: In Ad
4. Add custom status columns to the report
   1. From the Add Column drop down, select Custom Status Column to bring up the New Custom Status dialog
   2. Select the data column of the new custom status from the Data Column drop down
      1. Computer: Computer Model
      2. Computer: Bios Version
      3. Computer: Site Ready
      4. Computer: In Etl
   3. Enter the properties of the custom status column and then click the Create button. Click the Close button to cancel the operation.
      1. Computer: Computer Model
         1. Column Label – Model Status
         2. Value/Status
            1. For each Computer Model – Ready or Not Ready
      2. Computer: Bios Version
         1. Column Label – Bios Status
         2. Value/Status
            1. For each Bios Version – Ready or Not Ready
      3. Computer: Site Ready
         1. Column Label – Site Status
         2. Value/Status
            1. No – Not Ready
            2. Yes – Ready
      4. Computer: In Etl
         1. Column Label – ETL Status
         2. Value/Status
            1. No – Not Ready
            2. Yes – Ready
5. Add custom SQL columns to the report
   1. From the Add Column drop down, select Custom SQL Column to bring up the New SQL Column dialog
   2. Enter the SQL query of the custom SQL column and then click the Create button. Click the Close button to cancel the operation.
      1. App Status
         (
         CASE
         WHEN ((SELECT COUNT(0) FROM `view_computer_application_links` WHERE (`view_computer_application_links`.`computer_id` = `at_computer`.`id`)) = 0) THEN ‘No Apps’
         WHEN (( SELECT COUNT(0) FROM `view_computer_application_links` WHERE (`view_computer_application_links`.`computer_id` = `at_computer`.`id`)) =
         (SELECT COUNT(0) FROM (`view_computer_application_links` LEFT JOIN `at_application` `a` ON((`a`.`id` = `view_computer_application_links`.`app_id`)))
         WHERE ((`view_computer_application_links`.`computer_id` = `at_computer`.`id`) AND
         (`a`.`lu__app_status` LIKE ‘7 – Application Ready’)
         )
         )
         )
         THEN ‘Ready’
         ELSE ‘Not Ready’
         END
         ) AS app_status
      2. Memory Status
         (
         CASE
         WHEN ((SELECT lu__memory_gb FROM `at_computer` cpu where `at_computer`.id = cpu.id) BETWEEN 0 AND 4.0) THEN ‘Not Supported’
         ELSE ‘Supported’
         END
         ) AS memory_status
      3. Disk Space Status
         (
         CASE
         WHEN ((SELECT free_disk_space_gb FROM `at_computer` cpu where `at_computer`.id = cpu.id) BETWEEN 0 AND 25) THEN ‘Not Supported’
         ELSE ‘Supported’
         END
         ) AS disk_space_status
   3. To configure custom status, select Custom Status from the  menu to bring up the Edit Custom Status dialog
      1. Edit the properties of the custom status and then click the Update button. Click the Close button to cancel the operation.
         1. App Status
            1. Value/Status
               1. No Apps – Ready
               2. Not Ready – Not Ready
               3. Ready – Ready
         2. Memory Status
            1. Value/Status
               1. Not Supported – Not Ready
               2. Supported – Ready
         3. Disk Space Status
            1. Value/Status
               1. Not Supported – Not Ready
               2. Supported – Ready
6. Add an overall status column to the report
   1. From the Add Column drop down, select Overall Status Column to bring up the Overall Status dialog
      Enter the properties of the overall status column and then click the Update button. Click the Close button to cancel the operation.
      1. Status – Select all available statuses
      2. Column Label – Overall Status
7. Drag and drop to reorder columns
8. To configure column settings, select Settings from the  menu to bring up the Column Settings dialog
   1. Configure the column settings and then click the Save button. Click the Close button to cancel the operation.
      1. Computer: Name
         1. Hyperlink – Checked
      2. Computer: Migration Status
         1. Visible – No
         2. Custom Label Color
            1. Value/Color
               1. Not Migrated – Red
               2. Migrated – Green
      3. Computer: Description
         1. Visible – No
      4. Computer: Location
         1. Visible – No
      5. Computer: Region
         1. Visible – No
      6. Computer: Domain
         1. Visible – No
      7. Computer: Computer Type
         1. Visible – No
      8. Computer: Operating System
         1. Visible – No
      9. Computer: Os Build
         1. Visible – No
      10. Computer: Os Version
          1. Visible – No
      11. Computer: Disk Size Gb
          1. Visible – No
      12. Computer: Serial
          1. Visible – No
      13. Computer: Business Unit
          1. Visible – No
      14. Computer: Department
          1. Visible – No
      15. Computer: Computer Model
          1. Visible – No
      16. Computer: Bios Version
          1. Visible – No
      17. Computer: Memory Gb
          1. Visible – No
      18. Computer: Free Disk Space Gb
          1. Visible – No
      19. Computer: Site Ready
          1. Visible – No
          2. Custom Label Color
             1. Value/Color
                1. No – Red
                2. Yes – Green
      20. Computer: In Etl
          1. Column Label – In ETL
          2. Visible – No
          3. Custom Label Color
             1. Value/Color
                1. No – Red
                2. Yes – Green
      21. Computer: WaaS Ready For Scheduling (Alias)
          1. Column Label – WaaS Ready For Scheduling
          2. Custom Filter – 22H2 – PreReadiness (name of SCCM pre-readiness collection)
      22. Computer: Waves
      23. User: Name
          1. Visible – No
          2. Hyperlink – Checked
      24. User: Ad Login Id
          1. Visible – No
      25. User: Title
          1. Visible – No
      26. User: Telephone
          1. Visible – No
      27. User: Email
          1. Visible – No
      28. User: Manager (Alias)
          1. Column Label – Manager
          2. Visible – No
      29. User: Location
          1. Visible – No
      30. User: Domain
          1. Visible – No
      31. User: Business Unit
          1. Visible – No
      32. User: Department
          1. Visible – No
      33. User: Vip
          1. Column Label – VIP
          2. Visible – No
          3. Custom Label Color
             1. Value/Color
                1. No – Grey
                2. Yes – Orange
      34. User: Legal Hold
          1. Visible – No
          2. Custom Label Color
             1. Value/Color
                1. No – Grey
                2. Yes – Red
      35. User: In Ad
          1. Column Label – In AD
          2. Visible – No
          3. Custom Label Color
             1. Value/Color
                1. No – Red
                2. Yes – Green
9. Configure the settings of the report
   1. Click the Report Settings button to bring up the Report Settings dialog
   2. Configure the settings of the report and then click the Save button. Click the Close button to cancel the operation.
      1. Pin Left Columns – 1
      2. Apply Global Where Clause
         1. Computer: Operating System In Windows 7, Windows 10, Windows 11
         2. Computer: Os Version Not In 22H2
10. Assign action buttons to the report
    1. Click the  button to bring up the Assign Buttons to Report dialog
    2. To assign a button, select a type from the Type drop down, select an action or form button from the Button drop down, and then click the Assign button. Click the Close button to cancel the operation.
       1. Select All
       2. Assign Computers to Wave
11. Click the Preview Report button to preview the report before saving
    
12. Click the Create Report button when finished to create the report. You will be redirected back to the Reports tab. Click the Cancel button to cancel the operation.