Windows Copilot+ Requirements Audit

Select Top 1000000
A.AssetID,
A.AssetName,
A.Domain,
a.Version,
A.Username,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
A.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
p.Name As CPU,
A.Memory,
MAX(Coalesce(Cast(D.Size / 1024 / 1024 / 1024 As bigint),0)) as [Drive Size GB],
       Case 
         When MAX(Case When try_Cast(ParseName(tsysOS.OScode, 1) As int) >= 26100 Then 1 Else 0 End) = 1
         Then 'Pass' Else 'Fail'
       End As [OS Version],
       Case 
         When MAX(Case 
                    When (P.Manufacturer Like '%AMD%' Or P.Manufacturer Like '%Advanced Micro Devices%')
                         And P.Name Like '%Ryzen%AI%' 
                    Then 1
                    When (P.Manufacturer Like '%Intel%')
                         And P.Name Like '%Core%Ultra%'
                         And P.Name Like '%[579]%'
                         And P.Name Like '%2[0-9][0-9]V%'
                    Then 1
                    When (P.Manufacturer Like '%Qualcomm%')
                         And (P.Name Like '%X1E%' Or P.Name Like '%X1P%' Or P.Name Like '%X2E%' Or P.Name Like '%X1-%')
                    Then 1

                    Else 0
                  End) = 1
         Then 'Pass' Else 'Fail'
       End As [CPU AI Family],
       Case 
         When MAX(Case When Coalesce(Cast(A.Memory As bigint),0) >= 16384 Then 1 Else 0 End) = 1
         Then 'Pass' Else 'Fail'
       End As [Memory >= 16GB],
       Case 
         When MAX(Case When Coalesce(Cast(D.Size As bigint),0) >= 274877906944 Then 1 Else 0 End) = 1
         Then 'Pass' Else 'Fail'
       End As [Disk >= 256GB],
       Case 
         When
              MAX(Case 
                    When (P.Manufacturer Like '%AMD%' Or P.Manufacturer Like '%Advanced Micro Devices%') And P.Name Like '%Ryzen%AI%' Then 1
                    When (P.Manufacturer Like '%Intel%') And P.Name Like '%Core%Ultra%' And P.Name Like '%[579]%' And P.Name Like '%2[0-9][0-9]V%' Then 1
                    When (P.Manufacturer Like '%Qualcomm%') And (P.Name Like '%X1E%' Or P.Name Like '%X1P%' Or P.Name Like '%X2E%' Or P.Name Like '%X1-%') Then 1
                    Else 0
                  End) = 1
         And MAX(Case When Coalesce(Cast(A.Memory As bigint),0) >= 16384 Then 1 Else 0 End) = 1
         And MAX(Case When Coalesce(Cast(D.Size As bigint),0) >= 274877906944 Then 1 Else 0 End) = 1
		 And MAX(Case When try_Cast(ParseName(tsysOS.OScode, 1) As int) >= 26100 Then 1 Else 0 End) = 1
         Then 'Yes' Else 'No'
       End As [Copilot+ Capable]
From tblAssets A
Inner Join tblAssetCustom On A.AssetID = tblAssetCustom.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tblProcessor  P On P.AssetID = A.AssetID
Left Join tblDiskdrives D On D.AssetID = A.AssetID
Left Join tsysOS On tsysOS.OScode = a.OScode
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
a.LocationID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = a.Assettype
Where a.Assettype = -1 and tblState.Statename = 'Active' and tsysOS.OSname = 'Win 11'
Group By A.AssetID, A.AssetName, A.Domain, tsysOS.OScode, a.Username, tblAssetCustom.Manufacturer, tblAssetCustom.Model, tsysIPLocations.IPLocation, p.Name, tsysOS.Image, tsysAssetTypes.AssetTypeIcon10, a.IPAddress, a.Version, A.Memory
Order By A.Domain, A.AssetName