Search Knowledge Base by Keyword

Windows 11 Readiness (Dynamic)

< Back

The Windows 11 Readiness (Dynamic) report shows Windows 10 Computers and their overall Migration Readiness status (dynamically).

Asset Types Required Fields
Computer Name, Migration Status, Description, Location, Region, Domain, Computer Type, Operating System, Os Build, Os Version, Disk Size GB, Serial, Business Unit, Department, WaaS Ready For Scheduling, Computer Model, Bios Version, Memory Gb, Free Disk Space Gb, Site Ready, In Etl, Waves,
Application Supported Os Version
User Name, Ad Login, Id, Title, Telephone, Email, Manager, Location, Domain, Business Unit, Department, Vip, Legal Hold, In Ad

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 22H2 Readiness (Dynamic)
    2. Status – Enabled
    3. Published – No
    4. Data Source – Asset Type: Computer
    5. Description – Report showing Computers and their Windows 11 22H2 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: WaaS Ready For Scheduling (Alias)
      16. Computer: Computer Model
      17. Computer: Bios Version
      18. Computer: Memory Gb
      19. Computer: Free Disk Space Gb
      20. Computer: Site Ready
      21. Computer: In Etl
      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: Site Ready
        1. Column Label – Site Status
        2. Value/Status
          1. No – Not Ready
          2. Yes – Ready
      2. 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
        (SELECT COUNT(*) FROM `at_os_version_lookup` WHERE l_atid = (SELECT `atype_id` FROM `asset_types` WHERE `atype_name` = ‘Application’) AND l_aid = `a`.`id` AND l_item_id = (SELECT `id` FROM `at_os_version` WHERE `name` = ’22H2′))
        )
        )
        )
        THEN ‘Ready’
        ELSE ‘Not Ready’
        END
        ) AS app_status
      2. Model Status
        (
        CASE WHEN (
        (SELECT l_item_id FROM `at_os_version_lookup` WHERE l_item_id = (SELECT `id` FROM `at_os_version` WHERE `name` = ’22H2′) AND l_atid = (SELECT `atype_id` FROM `asset_types` WHERE `atype_name` = ‘Computer Model’) AND l_aid = (SELECT l_item_id FROM `at_computer_model_lookup` WHERE l_atid = (SELECT `atype_id` FROM `asset_types` WHERE `atype_name` = ‘Computer’) AND l_aid = `at_computer`.id))
        )
        THEN ‘Supported’
        WHEN ((SELECT lu__computer_model FROM `at_computer` cpu where `at_computer`.id = cpu.id) IS NULL) THEN ‘No Value’
        ELSE ‘Not Supported’
        END
        ) AS model_status
      3. Bios Status
        (
        CASE WHEN (
        (SELECT l_item_id FROM `at_os_version_lookup` WHERE l_item_id = (SELECT `id` FROM `at_os_version` WHERE `name` = ’22H2′) AND l_atid = (SELECT `atype_id` FROM `asset_types` WHERE `atype_name` = ‘BIOS Version’) AND l_aid = (SELECT l_item_id FROM `at_bios_version_lookup` WHERE l_atid = (SELECT `atype_id` FROM `asset_types` WHERE `atype_name` = ‘Computer’) AND l_aid = `at_computer`.id))
        )
        THEN ‘Supported’
        WHEN ((SELECT lu__bios_version FROM `at_computer` cpu where `at_computer`.id = cpu.id) IS NULL) THEN ‘No Value’
        ELSE ‘Not Supported’
        END
        ) AS bios_status
      4. 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
      5. 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. Model Status
          1. Value/Status
            1. No Value – Not Ready
            2. Not Supported – Not Ready
            3. Supported – Ready
        3. Bios Status
          1. Value/Status
            1. No Value – Not Ready
            2. Not Supported – Not Ready
            3. Supported – Ready
        4. Memory Status
          1. Value/Status
            1. No Value – Not Ready
            2. Not Supported – Not Ready
            3. Supported – Ready
        5. Disk Space Status
          1. Value/Status
            1. No Value – Not Ready
            2. Not Supported – Not Ready
            3. 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: WaaS Ready For Scheduling (Alias)
        1. Column Label – WaaS Ready For Scheduling
        2. Custom Filter – 22H2 – PreReadiness (name of SCCM pre-readiness collection)
      16. Computer: Computer Model
        1. Visible – No
      17. Computer: Bios Version
        1. Visible – No
      18. Computer: Memory Gb
        1. Visible – No
      19. Computer: Free Disk Space Gb
        1. Visible – No
      20. Computer: Site Ready
        1. Visible – No
        2. Custom Label Color
          1. Value/Color
            1. No – Red
            2. Yes – Green
      21. Computer: In Etl
        1. Column Label – In ETL
        2. Visible – No
        3. Custom Label Color
          1. Value/Color
            1. No – Red
            2. Yes – Green
      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 – Computer: Os Version != 22H2
  10. Click the Preview Report button to preview the report before saving
  11. 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.
Tags: