Prerequisites
Minimum Version: Requires SysTrack 10.1 or later.
Notes
If you select groups with a large amount of systems, it may impact dashboard performance. Consider working with smaller groups of systems to asses.
After this DEX Pack is installed, it may take up to 24 hours for data to appear.
If you update or reinstall this DEX Pack, you must reassign any Views created below to the SF_Windows 11 Migration Role and reapprove the Win11HardwareReadiness Action. You need to also overwrite the old view SQL with the new SQL.
This DEX Pack relies on a Collection Extension to collect readiness data. If you find missing data for systems, verify the Collection Extension can be successfully run on the system.
This pack makes use of a Collection Extension which contains a PowerShell script. When the agent is run it will attempt to bypass execution policies; if this is not possible, the data required will not be collected.
Installation Steps
To install this DEX Pack, complete the following steps:
Assign the Windows 11 Migration View to the Windows 11 Migration Role.
Assign the Windows 11 Migration Role to Relevant Configurations.
Import the Kit
There are two ways to import the DEX Pack to SysTrack:
Import the pack directly from the Kits page in SysTrack. See the Import Online Kits guide for more information.
Import a local file downloaded from the DEX and Kit Downloads page. Click the Download Kit link for the pack and follow the Import Local Kits guide to finish the import.
Enable the Win11HardwareReadiness Action
Verify you have unlocked the tenant next to your username.
In Configure, click Automations and Collection Extensions on the left.
Select Action Governance, then click the Pending Approval tab.
Find the Win11HardwareReadiness Action and select the checkbox next to it.
Click Approve, then confirm. The action moves to the Actions tab and is enabled automatically.
NOTE: In SysTrack Cloud, the user who imported the Kit may not be allowed to approve its actions. If the checkbox is unavailable, ask another user with Action Governance – Management permission to approve the action.
Create the Windows 11 Migration View
NOTE: This step is only required for versions prior to 11.2.
The Windows 11 Migration DEX Pack requires you to make a View for the SF_Windows 11 Migration Role.
To create the new View:
Navigate to Configure > Views.
Click the padlock icon in the upper-right to enable editing.
Click the plus icon to add a new View.
Fill in the Settings as follows:
View Name: SF_WIN11
Expires in: 30 days
When Expired: Overwrite Data
Do not check When overdue by 1 day(s).
Set the Refresh drop-downs to Daily, Inside, 24x7, and Every Day.
Copy the SF_WIN11 SQL Query, and paste it into the box under SQL Selection > Generic.
Click Test SQL. A Success message should appear at the top of the screen. If the test is not successful, the query may have been copied incorrectly.
Click Create View at the top-right.
SF_WIN11 SQL Query
SELECT
T0.WGUID,
GETUTCDATE() AS VWTIME,
T1.CHANGETIME AS WIN11MIGRATEDATE,
T1.OLDOS,
T1.OLDBUILD,
T3.processor,
T3.secureBoot,
T3.TPM
FROM SASCFG AS T0
INNER JOIN SASTR AS S0 ON T0.OSNAME = S0.STRINGID
LEFT JOIN (
SELECT
T0.WGUID,
MAX(T0.CHANGETIME) AS CHANGETIME,
MAX(CASE WHEN S1.STRVALUE = 'OSNAME' THEN T0.OLDVALUE ELSE NULL END) AS OLDOS,
MAX(CASE WHEN S1.STRVALUE = 'OSBUILDNUM' THEN T0.OLDVALUE ELSE NULL END) AS OLDBUILD
FROM (SACHANGES AS T0
INNER JOIN SASTR AS S0 ON T0.TABLENAME = S0.STRINGID)
INNER JOIN SASTR AS S1 ON T0.FIELDNAME = S1.STRINGID
WHERE
S0.STRVALUE = 'SASCFG'
AND S1.STRVALUE IN ('OSNAME','OSBUILDNUM')
AND T0.CHANGETYPE = 2
GROUP BY T0.WGUID
HAVING MAX(CASE WHEN S1.STRVALUE = 'OSNAME' THEN T0.NEWVALUE ELSE NULL END) LIKE 'Microsoft Windows 11%'
) AS T1 ON T0.WGUID = T1.WGUID
LEFT JOIN DYNI_Win11HardwareReadiness AS T3 ON T0.WGUID = T3.WGUID
WHERE
S0.STRVALUE LIKE 'Microsoft Windows%'
AND S0.STRVALUE NOT LIKE 'Microsoft Windows Server%'Assign the Windows 11 Migration View to the Windows 11 Migration Role
To assign the new View:
Navigate to Configure > Roles.
Use the drop-down at the top to select the SF_Windows 11 Migration.
Click Views, then check the box next to SF_WIN11.
Click Save Changes at the top-right.
After this View is assigned, Screen Time data will be collected each day. It will take 30 days before the data in this Dashboard is fully populated.
Assign the Windows 11 Migration Role to Relevant Configurations
This DEX Pack requires you to assign the SF_Windows 11 Migration Role to the relevant Configurations:
Navigate to Configure > Configurations.
Click the padlock icon in the upper-right to enable editing.
Use the drop-down at the top to select a relevant Configuration, or create a new Configuration.
Assign SF_Windows 11 Migration Role to the Configuration by dragging it from Available Roles to Assigned Roles.
Click Save Changes at the top-right.
It may take up to 24 hours for systems to check in and update their configuration.