Dell (http://www.dell.com/support/article/us/en/4/SLN297954/computers-tested-for-upgrade-to-windows-10-anniversary-update?lang=EN) and HP (http://support.hp.com/us-en/document/c05195282) both have blogs on the Models that have been tested and support Windows 10. Win10 can install to many devices. These devices can take full advantage of Win10 (Secure boot, UEFI, Certified Drivers).
These SQL queries can be used to make pivot tables and other nice looking reports for SCCM depending on your need. I did my best to add in all the Models. Please check your models against these reports and the blogs and include or exclude them for your query as needed.
Note: HP Manufacturer is either HP or Hewlett-Packard
HP Models supporting Win10
SELECT CompSys.Manufacturer0 as 'OEM', CompSys.model0 as 'Model', COUNT(Sys.Resourceid) AS 'TotalSystems'
FROM V_R_System as Sys
LEFT JOIN V_GS_PC_BIOS as BIOS on Sys.resourceid = BIOS.resourceid
LEFT JOIN V_GS_COMPUTER_SYSTEM as CompSys on Sys.resourceid = CompSys.resourceid
WHERE
(CompSys.model0 like '%EliteBook 850 G2%' or
CompSys.model0 like '%EliteBook 750 G2%' or
CompSys.model0 like '%EE 10 G1%' or
CompSys.model0 like '%Elite x2 1011 G1%' Or
CompSys.model0 like '%Elite x2 1012 G1 %' Or
CompSys.model0 like '%EliteBook 1040 G2%' Or
CompSys.model0 like '%EliteBook 1040 G4%' Or
CompSys.model0 like '%EliteBook 725 G2%' Or
CompSys.model0 like '%EliteBook 725 G3%' Or
CompSys.model0 like '%EliteBook 725 G4%' Or
CompSys.model0 like '%EliteBook 740 G1%' Or
CompSys.model0 like '%EliteBook 740 G2%' Or
CompSys.model0 like '%EliteBook 745 G2%' Or
CompSys.model0 like '%EliteBook 745 G3%' Or
CompSys.model0 like '%EliteBook 745 G4%' Or
CompSys.model0 like '%EliteBook 750 G1 %' Or
CompSys.model0 like '%EliteBook 755 G2%' Or
CompSys.model0 like '%EliteBook 755 G3%' Or
CompSys.model0 like '%EliteBook 755 G4%' Or
CompSys.model0 like '%EliteBook 820 G3%' Or
CompSys.model0 like '%EliteBook 820 G1%' Or
CompSys.model0 like '%EliteBook 820 G4%' Or
CompSys.model0 like '%EliteBook 720 G2%' Or
CompSys.model0 like '%EliteBook 720 G1%' Or
CompSys.model0 like '%EliteBook 820 G2%' Or
CompSys.model0 like '%EliteBook 830 G1%' Or
CompSys.model0 like '%EliteBook 840 G1%' Or
CompSys.model0 like '%EliteBook 840 G2%' Or
CompSys.model0 like '%EliteBook 840 G3%' Or
CompSys.model0 like '%EliteBook 840 G4%' Or
CompSys.model0 like '%EliteBook 850 G1%' Or
CompSys.model0 like '%EliteBook 850 G3%' Or
CompSys.model0 like '%EliteBook 850 G4%' Or
CompSys.model0 like '%EliteBook Folio G1%' Or
CompSys.model0 like '%EliteBook Folio 1030 G1%' Or
CompSys.model0 like '%EliteBook Folio 1040 G3%' Or
CompSys.model0 like '%EliteDesk 700 G1%' Or
CompSys.model0 like '%EliteDesk 705 G1%' Or
CompSys.model0 like '%EliteDesk 705 G2%' Or
CompSys.model0 like '%EliteDesk 705 G3%' Or
CompSys.model0 like '%EliteDesk 800 G1%' Or
CompSys.model0 like '%EliteDesk 800 G2%' Or
CompSys.model0 like '%EliteDesk 800 G3%' Or
CompSys.model0 like '%EliteOne 705 G1%' Or
CompSys.model0 like '%EliteOne 705 G2%' Or
CompSys.model0 like '%EliteOne 800 G1%' Or
CompSys.model0 like '%EliteOne 800 G2%' Or
CompSys.model0 like '%ElitePad 1000 G2 %' Or
CompSys.model0 like '%Folio 1020 G1%' Or
CompSys.model0 like '%Folio 1040 G1%' Or
CompSys.model0 like '%Folio 9480m%' Or
CompSys.model0 like '%HP 200 G1%' Or
CompSys.model0 like '%HP 202 G2%' Or
CompSys.model0 like '%HP 205 G3%' Or
CompSys.model0 like '%HP 240 G4%' Or
CompSys.model0 like '%HP 240 G5%' Or
CompSys.model0 like '%HP 245 G4%' Or
CompSys.model0 like '%HP 245 G5%' Or
CompSys.model0 like '%HP 248 G1%' Or
CompSys.model0 like '%HP 250 G4%' Or
CompSys.model0 like '%HP 250 G5%' Or
CompSys.model0 like '%HP 255 G4%' Or
CompSys.model0 like '%HP 255 G5%' Or
CompSys.model0 like '%HP 260 G1%' Or
CompSys.model0 like '%HP 260 G2%' Or
CompSys.model0 like '%HP 280 G1%' Or
CompSys.model0 like '%HP 280 G2%' Or
CompSys.model0 like '%HP 285 G1%' Or
CompSys.model0 like '%HP 285 G2%' Or
CompSys.model0 like '%HP 340 G1%' Or
CompSys.model0 like '%HP 340 G2%' Or
CompSys.model0 like '%HP 340 G3%' Or
CompSys.model0 like '%HP 340 G4%' Or
CompSys.model0 like '%HP 345 G2%' Or
CompSys.model0 like '%HP 346 G3%' Or
CompSys.model0 like '%HP 348 G3%' Or
CompSys.model0 like '%HP 350 G1%' Or
CompSys.model0 like '%HP 350 G2%' Or
CompSys.model0 like '%HP 355 G2%' Or
CompSys.model0 like '%HP 402 G1%' Or
CompSys.model0 like '%HP 406%' Or
CompSys.model0 like '%Elite x2 1012 G2 %' Or
CompSys.model0 like '%HP ENVY Pro Curve%' Or
CompSys.model0 like '%Omen Pro Mobile%' Or
CompSys.model0 like '%x2 210 G1%' Or
CompSys.model0 like '%x2 210 G2%' Or
CompSys.model0 like '%Z1 G2 Workstation%' Or
CompSys.model0 like '%Z230 Workstation%' Or
CompSys.model0 like '%Z240 Workstation%' Or
CompSys.model0 like '%Z440 Workstation%' Or
CompSys.model0 like '%Z640 Workstation%' Or
CompSys.model0 like '%Z840 Workstation%' Or
CompSys.model0 like '%MP9 G2 Retail%' Or
CompSys.model0 like '%Pro Tablet 608 G1%' Or
CompSys.model0 like '%Pro Tablet 612 G1%' Or
CompSys.model0 like '%Pro Tablet Retail%' Or
CompSys.model0 like '%Pro x2 612 G2%' Or
CompSys.model0 like '%ProBook 11 G1%' Or
CompSys.model0 like '%ProBook 11 G2%' Or
CompSys.model0 like '%ProBook 430 G1%' Or
CompSys.model0 like '%ProBook 430 G2%' Or
CompSys.model0 like '%ProBook 430 G3%' Or
CompSys.model0 like '%ProBook 430 G4%' Or
CompSys.model0 like '%ProBook 440%' Or
CompSys.model0 like '%ProBook 445%' Or
CompSys.model0 like '%ProBook 450%' Or
CompSys.model0 like '%ProBook 455%' Or
CompSys.model0 like '%ProBook 470%' Or
CompSys.model0 like '%ProBook 640 G1%' Or
CompSys.model0 like '%ProBook 640 G2%' Or
CompSys.model0 like '%ProBook 640 G3%' Or
CompSys.model0 like '%ProBook 645 G1 %' Or
CompSys.model0 like '%ProBook 645 G2%' Or
CompSys.model0 like '%ProBook 645 G3%' Or
CompSys.model0 like '%ProBook 650 G1%' Or
CompSys.model0 like '%ProBook 650 G2%' Or
CompSys.model0 like '%ProBook 650 G3%' Or
CompSys.model0 like '%ProBook 655 G1%' Or
CompSys.model0 like '%ProBook 655 G2%' Or
CompSys.model0 like '%ProBook 655 G3%' Or
CompSys.model0 like '%ProBook x360 11%' Or
CompSys.model0 like '%ProDesk 400 G1%' Or
CompSys.model0 like '%ProDesk 400 G2%' Or
CompSys.model0 like '%ProDesk 400 G3%' Or
CompSys.model0 like '%ProDesk 400 G4%' Or
CompSys.model0 like '%ProDesk 405 G1%' Or
CompSys.model0 like '%ProDesk 405 G2%' Or
CompSys.model0 like '%ProDesk 480 G1%' Or
CompSys.model0 like '%ProDesk 480 G2%' Or
CompSys.model0 like '%ProDesk 480 G3%' Or
CompSys.model0 like '%ProDesk 490 G1%' Or
CompSys.model0 like '%ProDesk 490 G2%' Or
CompSys.model0 like '%ProDesk 490 G3%' Or
CompSys.model0 like '%ProDesk 600 G1 %' Or
CompSys.model0 like '%ProDesk 600 G2%' Or
CompSys.model0 like '%ProDesk 600 G3%' Or
CompSys.model0 like '%ProOne 400 G1%' Or
CompSys.model0 like '%ProOne 400 G2%' Or
CompSys.model0 like '%ProOne 600 G1%' Or
CompSys.model0 like '%ProOne 600 G2%' Or
CompSys.model0 like '%ProOne 600 G3%' Or
CompSys.model0 like '%Revolve 810 G2%' Or
CompSys.model0 like '%Revolve 810 G3%' Or
CompSys.model0 like '%RP2, Model 2000%' Or
CompSys.model0 like '%RP2, Model 2030%' Or
CompSys.model0 like '%RP5, Model 5810%' Or
CompSys.model0 like '%RP9, Model 9015 G1%' Or
CompSys.model0 like '%RP9, Model 9018 G1%' Or
CompSys.model0 like '%Spectre 13%' Or
CompSys.model0 like '%Spectre Pro 13 G1%' Or
CompSys.model0 like '%Spectre x2 13%' Or
CompSys.model0 like '%Spectre x360 G1%' Or
CompSys.model0 like '%Stream 11 G3%' Or
CompSys.model0 like '%Tablet 408 G1%' Or
CompSys.model0 like '%TX1 POS 200%' Or
CompSys.model0 like '%Ultrabook 210 G1%' Or
CompSys.model0 like '%Ultrabook 215 G1%' Or
CompSys.model0 like '%x360 310 G2%' Or
CompSys.model0 like '%ZBook 14 G1%' Or
CompSys.model0 like '%ZBook 14 G2%' Or
CompSys.model0 like '%ZBook 14 G3%' Or
CompSys.model0 like '%ZBook 15 G1%' Or
CompSys.model0 like '%ZBook 15 G2%' Or
CompSys.model0 like '%ZBook 15 G3%' Or
CompSys.model0 like '%ZBook 15u G2%' Or
CompSys.model0 like '%ZBook 15u G3%' Or
CompSys.model0 like '%ZBook 17 G1%' Or
CompSys.model0 like '%ZBook 17 G2%' Or
CompSys.model0 like '%ZBook 17 G3%' )and
( CompSys.Manufacturer0 LIKE '%HP%'OR
CompSys.Manufacturer0 LIKE '%Hewlett-Packard%')
GROUP BY CompSys.Manufacturer0,CompSys.model0
ORDER BY CompSys.Model0
HP Models NOT supporting Win10
SELECT CompSys.Manufacturer0 as 'OEM', CompSys.model0 as 'Model', COUNT(Sys.Resourceid) AS 'TotalSystems'
FROM V_R_System as Sys
LEFT JOIN V_GS_PC_BIOS as BIOS on Sys.resourceid = BIOS.resourceid
LEFT JOIN V_GS_COMPUTER_SYSTEM as CompSys on Sys.resourceid = CompSys.resourceid
WHERE (CompSys.Manufacturer0 LIKE '%HP%'OR
CompSys.Manufacturer0 LIKE '%Hewlett-Packard%') AND CompSys.model0 not like '%ProLiant%' and Sys.ResourceID Not in
(SELECT Sys.ResourceID
FROM V_R_System as Sys
LEFT JOIN V_GS_PC_BIOS as BIOS on Sys.resourceid = BIOS.resourceid
LEFT JOIN V_GS_COMPUTER_SYSTEM as CompSys on Sys.resourceid = CompSys.resourceid
WHERE
(CompSys.model0 like '%EliteBook 850 G2%' or
CompSys.model0 like '%EliteBook 750 G2%' or
CompSys.model0 like '%EE 10 G1%' or
CompSys.model0 like '%Elite x2 1011 G1%' Or
CompSys.model0 like '%Elite x2 1012 G1 %' Or
CompSys.model0 like '%EliteBook 1040 G2%' Or
CompSys.model0 like '%EliteBook 1040 G4%' Or
CompSys.model0 like '%EliteBook 725 G2%' Or
CompSys.model0 like '%EliteBook 725 G3%' Or
CompSys.model0 like '%EliteBook 725 G4%' Or
CompSys.model0 like '%EliteBook 740 G1%' Or
CompSys.model0 like '%EliteBook 740 G2%' Or
CompSys.model0 like '%EliteBook 745 G2%' Or
CompSys.model0 like '%EliteBook 745 G3%' Or
CompSys.model0 like '%EliteBook 745 G4%' Or
CompSys.model0 like '%EliteBook 750 G1 %' Or
CompSys.model0 like '%EliteBook 755 G2%' Or
CompSys.model0 like '%EliteBook 755 G3%' Or
CompSys.model0 like '%EliteBook 755 G4%' Or
CompSys.model0 like '%EliteBook 820 G3%' Or
CompSys.model0 like '%EliteBook 820 G1%' Or
CompSys.model0 like '%EliteBook 820 G4%' Or
CompSys.model0 like '%EliteBook 720 G2%' Or
CompSys.model0 like '%EliteBook 720 G1%' Or
CompSys.model0 like '%EliteBook 820 G2%' Or
CompSys.model0 like '%EliteBook 830 G1%' Or
CompSys.model0 like '%EliteBook 840 G1%' Or
CompSys.model0 like '%EliteBook 840 G2%' Or
CompSys.model0 like '%EliteBook 840 G3%' Or
CompSys.model0 like '%EliteBook 840 G4%' Or
CompSys.model0 like '%EliteBook 850 G1%' Or
CompSys.model0 like '%EliteBook 850 G3%' Or
CompSys.model0 like '%EliteBook 850 G4%' Or
CompSys.model0 like '%EliteBook Folio G1%' Or
CompSys.model0 like '%EliteBook Folio 1030 G1%' Or
CompSys.model0 like '%EliteBook Folio 1040 G3%' Or
CompSys.model0 like '%EliteDesk 700 G1%' Or
CompSys.model0 like '%EliteDesk 705 G1%' Or
CompSys.model0 like '%EliteDesk 705 G2%' Or
CompSys.model0 like '%EliteDesk 705 G3%' Or
CompSys.model0 like '%EliteDesk 800 G1%' Or
CompSys.model0 like '%EliteDesk 800 G2%' Or
CompSys.model0 like '%EliteDesk 800 G3%' Or
CompSys.model0 like '%EliteOne 705 G1%' Or
CompSys.model0 like '%EliteOne 705 G2%' Or
CompSys.model0 like '%EliteOne 800 G1%' Or
CompSys.model0 like '%EliteOne 800 G2%' Or
CompSys.model0 like '%ElitePad 1000 G2 %' Or
CompSys.model0 like '%Folio 1020 G1%' Or
CompSys.model0 like '%Folio 1040 G1%' Or
CompSys.model0 like '%Folio 9480m%' Or
CompSys.model0 like '%HP 200 G1%' Or
CompSys.model0 like '%HP 202 G2%' Or
CompSys.model0 like '%HP 205 G3%' Or
CompSys.model0 like '%HP 240 G4%' Or
CompSys.model0 like '%HP 240 G5%' Or
CompSys.model0 like '%HP 245 G4%' Or
CompSys.model0 like '%HP 245 G5%' Or
CompSys.model0 like '%HP 248 G1%' Or
CompSys.model0 like '%HP 250 G4%' Or
CompSys.model0 like '%HP 250 G5%' Or
CompSys.model0 like '%HP 255 G4%' Or
CompSys.model0 like '%HP 255 G5%' Or
CompSys.model0 like '%HP 260 G1%' Or
CompSys.model0 like '%HP 260 G2%' Or
CompSys.model0 like '%HP 280 G1%' Or
CompSys.model0 like '%HP 280 G2%' Or
CompSys.model0 like '%HP 285 G1%' Or
CompSys.model0 like '%HP 285 G2%' Or
CompSys.model0 like '%HP 340 G1%' Or
CompSys.model0 like '%HP 340 G2%' Or
CompSys.model0 like '%HP 340 G3%' Or
CompSys.model0 like '%HP 340 G4%' Or
CompSys.model0 like '%HP 345 G2%' Or
CompSys.model0 like '%HP 346 G3%' Or
CompSys.model0 like '%HP 348 G3%' Or
CompSys.model0 like '%HP 350 G1%' Or
CompSys.model0 like '%HP 350 G2%' Or
CompSys.model0 like '%HP 355 G2%' Or
CompSys.model0 like '%HP 402 G1%' Or
CompSys.model0 like '%HP 406%' Or
CompSys.model0 like '%Elite x2 1012 G2 %' Or
CompSys.model0 like '%HP ENVY Pro Curve%' Or
CompSys.model0 like '%Omen Pro Mobile%' Or
CompSys.model0 like '%x2 210 G1%' Or
CompSys.model0 like '%x2 210 G2%' Or
CompSys.model0 like '%Z1 G2 Workstation %' Or
CompSys.model0 like '%Z230 Workstation%' Or
CompSys.model0 like '%Z240 Workstation%' Or
CompSys.model0 like '%Z440 Workstation%' Or
CompSys.model0 like '%Z640 Workstation%' Or
CompSys.model0 like '%Z840 Workstation%' Or
CompSys.model0 like '%MP9 G2 Retail%' Or
CompSys.model0 like '%Pro Tablet 608 G1%' Or
CompSys.model0 like '%Pro Tablet 612 G1%' Or
CompSys.model0 like '%Pro Tablet Retail%' Or
CompSys.model0 like '%Pro x2 612 G2%' Or
CompSys.model0 like '%ProBook 11 G1%' Or
CompSys.model0 like '%ProBook 11 G2%' Or
CompSys.model0 like '%ProBook 430 G1%' Or
CompSys.model0 like '%ProBook 430 G2%' Or
CompSys.model0 like '%ProBook 430 G3%' Or
CompSys.model0 like '%ProBook 430 G4%' Or
CompSys.model0 like '%ProBook 440%' Or
CompSys.model0 like '%ProBook 445%' Or
CompSys.model0 like '%ProBook 450%' Or
CompSys.model0 like '%ProBook 455%' Or
CompSys.model0 like '%ProBook 470%' Or
CompSys.model0 like '%ProBook 640 G1%' Or
CompSys.model0 like '%ProBook 640 G2%' Or
CompSys.model0 like '%ProBook 640 G3%' Or
CompSys.model0 like '%ProBook 645 G1 %' Or
CompSys.model0 like '%ProBook 645 G2%' Or
CompSys.model0 like '%ProBook 645 G3%' Or
CompSys.model0 like '%ProBook 650 G1%' Or
CompSys.model0 like '%ProBook 650 G2%' Or
CompSys.model0 like '%ProBook 650 G3%' Or
CompSys.model0 like '%ProBook 655 G1%' Or
CompSys.model0 like '%ProBook 655 G2%' Or
CompSys.model0 like '%ProBook 655 G3%' Or
CompSys.model0 like '%ProBook x360 11%' Or
CompSys.model0 like '%ProDesk 400 G1%' Or
CompSys.model0 like '%ProDesk 400 G2%' Or
CompSys.model0 like '%ProDesk 400 G3%' Or
CompSys.model0 like '%ProDesk 400 G4%' Or
CompSys.model0 like '%ProDesk 405 G1%' Or
CompSys.model0 like '%ProDesk 405 G2%' Or
CompSys.model0 like '%ProDesk 480 G1%' Or
CompSys.model0 like '%ProDesk 480 G2%' Or
CompSys.model0 like '%ProDesk 480 G3%' Or
CompSys.model0 like '%ProDesk 490 G1%' Or
CompSys.model0 like '%ProDesk 490 G2%' Or
CompSys.model0 like '%ProDesk 490 G3%' Or
CompSys.model0 like '%ProDesk 600 G1 %' Or
CompSys.model0 like '%ProDesk 600 G2%' Or
CompSys.model0 like '%ProDesk 600 G3%' Or
CompSys.model0 like '%ProOne 400 G1%' Or
CompSys.model0 like '%ProOne 400 G2%' Or
CompSys.model0 like '%ProOne 600 G1%' Or
CompSys.model0 like '%ProOne 600 G2%' Or
CompSys.model0 like '%ProOne 600 G3%' Or
CompSys.model0 like '%Revolve 810 G2%' Or
CompSys.model0 like '%Revolve 810 G3%' Or
CompSys.model0 like '%RP2, Model 2000%' Or
CompSys.model0 like '%RP2, Model 2030%' Or
CompSys.model0 like '%RP5, Model 5810%' Or
CompSys.model0 like '%RP9, Model 9015 G1%' Or
CompSys.model0 like '%RP9, Model 9018 G1%' Or
CompSys.model0 like '%Spectre 13%' Or
CompSys.model0 like '%Spectre Pro 13 G1%' Or
CompSys.model0 like '%Spectre x2 13%' Or
CompSys.model0 like '%Spectre x360 G1%' Or
CompSys.model0 like '%Stream 11 G3%' Or
CompSys.model0 like '%Tablet 408 G1%' Or
CompSys.model0 like '%TX1 POS 200%' Or
CompSys.model0 like '%Ultrabook 210 G1%' Or
CompSys.model0 like '%Ultrabook 215 G1%' Or
CompSys.model0 like '%x360 310 G2%' Or
CompSys.model0 like '%ZBook 14 G1%' Or
CompSys.model0 like '%ZBook 14 G2%' Or
CompSys.model0 like '%ZBook 14 G3%' Or
CompSys.model0 like '%ZBook 15 G1%' Or
CompSys.model0 like '%ZBook 15 G2%' Or
CompSys.model0 like '%ZBook 15 G3%' Or
CompSys.model0 like '%ZBook 15u G2%' Or
CompSys.model0 like '%ZBook 15u G3%' Or
CompSys.model0 like '%ZBook 17 G1%' Or
CompSys.model0 like '%ZBook 17 G2%' Or
CompSys.model0 like '%ZBook 17 G3%' )
And
(CompSys.Manufacturer0 like '%HP%' or CompSys.Manufacturer0 like '%Hewlett-Packard%')
)
GROUP BY CompSys.Manufacturer0,CompSys.model0
ORDER BY CompSys.Model0
Dell machines supporting Windows 10
SELECT CompSys.Manufacturer0 as 'OEM', CompSys.model0 as 'Model', COUNT(Sys.Resourceid) AS 'TotalSystems'
FROM V_R_System as Sys
LEFT JOIN V_GS_PC_BIOS as BIOS on Sys.resourceid = BIOS.resourceid
LEFT JOIN V_GS_COMPUTER_SYSTEM as CompSys on Sys.resourceid = CompSys.resourceid
WHERE
(CompSys.model0 like '%3150%' or
CompSys.model0 like '%3160%' or
CompSys.model0 like '%3330%' or
CompSys.model0 like '%3340%' Or
CompSys.model0 like '%3350%' Or
CompSys.model0 like '%3379%' Or
CompSys.model0 like '%3450%' Or
CompSys.model0 like '%3460%' Or
CompSys.model0 like '%3470%' Or
CompSys.model0 like '%3540%' Or
CompSys.model0 like '%3550%' Or
CompSys.model0 like '%3560%' Or
CompSys.model0 like '%3570%' Or
CompSys.model0 like '%5175%' Or
CompSys.model0 like '%5179%' Or
CompSys.model0 like '%E5250%' Or
CompSys.model0 like '%E5270%' Or
CompSys.model0 like '%5404%' Or
CompSys.model0 like '%5414%' Or
CompSys.model0 like '%E5430%' Or
CompSys.model0 like '%E5440%' Or
CompSys.model0 like '%E5450%' Or
CompSys.model0 like '%E5450%' Or
CompSys.model0 like '%E5470%' Or
CompSys.model0 like '%E5530%' Or
CompSys.model0 like '%E5530%' Or
CompSys.model0 like '%E5540%' Or
CompSys.model0 like '%E5550%' Or
CompSys.model0 like '%E5570%' Or
CompSys.model0 like '%E6230%' Or
CompSys.model0 like '%E6330%' Or
CompSys.model0 like '%E6430%' Or
CompSys.model0 like '%E6430%' Or
CompSys.model0 like '%E6440%' Or
CompSys.model0 like '%E6530%' Or
CompSys.model0 like '%E6540%' Or
CompSys.model0 like '%7202%' Or
CompSys.model0 like '%7204%' Or
CompSys.model0 like '%7214%' Or
CompSys.model0 like '%E7240%' Or
CompSys.model0 like '%E7250%' Or
CompSys.model0 like '%E7270%' Or
CompSys.model0 like '%7275%' Or
CompSys.model0 like '%E7350%' Or
CompSys.model0 like '%E7370%' Or
CompSys.model0 like '%7404%' Or
CompSys.model0 like '%7414%' Or
CompSys.model0 like '%E7440%' Or
CompSys.model0 like '%E7450%' Or
CompSys.model0 like '%E7470%' Or
CompSys.model0 like '%3010%' Or
CompSys.model0 like '%3020%' Or
CompSys.model0 like '%3030%' Or
CompSys.model0 like '%3040%' Or
CompSys.model0 like '%3046%' Or
CompSys.model0 like '%3240%' Or
CompSys.model0 like '%5040%' Or
CompSys.model0 like '%7010%' Or
CompSys.model0 like '%7020%' Or
CompSys.model0 like '%7040%' Or
CompSys.model0 like '%9010%' Or
CompSys.model0 like '%9020%' Or
CompSys.model0 like '%9030%' Or
CompSys.model0 like '%3420%' Or
CompSys.model0 like '%3620%' Or
CompSys.model0 like '%5810%' Or
CompSys.model0 like '%7810%' Or
CompSys.model0 like '%7910%' Or
CompSys.model0 like '%7910%' Or
CompSys.model0 like '%3510%' Or
CompSys.model0 like '%M3800%' Or
CompSys.model0 like '%M4800%' Or
CompSys.model0 like '%5510%' Or
CompSys.model0 like '%M6800%' Or
CompSys.model0 like '%M7510%' Or
CompSys.model0 like '%M7710%' Or
CompSys.model0 like '%5055%' Or
CompSys.model0 like '%5056%' Or
CompSys.model0 like '%5855%' Or
CompSys.model0 like '%7140%' )and
CompSys.Manufacturer0 like '%Dell%'
GROUP BY CompSys.Manufacturer0,CompSys.model0
ORDER BY CompSys.Model0
Dell machines NOT supporting Windows 10
SELECT CompSys.Manufacturer0 as 'OEM', CompSys.model0 as 'Model', COUNT(Sys.Resourceid) AS 'TotalSystems'
FROM V_R_System as Sys
LEFT JOIN V_GS_PC_BIOS as BIOS on Sys.resourceid = BIOS.resourceid
LEFT JOIN V_GS_COMPUTER_SYSTEM as CompSys on Sys.resourceid = CompSys.resourceid
WHERE CompSys.Manufacturer0 like '%Dell%' and CompSys.model0 not like '%PowerEdge%' and Sys.ResourceID Not in
(SELECT Sys.ResourceID
FROM V_R_System as Sys
LEFT JOIN V_GS_PC_BIOS as BIOS on Sys.resourceid = BIOS.resourceid
LEFT JOIN V_GS_COMPUTER_SYSTEM as CompSys on Sys.resourceid = CompSys.resourceid
WHERE
(CompSys.model0 like '%3150%' or
CompSys.model0 like '%3160%' or
CompSys.model0 like '%3330%' or
CompSys.model0 like '%3340%' Or
CompSys.model0 like '%3350%' Or
CompSys.model0 like '%3379%' Or
CompSys.model0 like '%3450%' Or
CompSys.model0 like '%3460%' Or
CompSys.model0 like '%3470%' Or
CompSys.model0 like '%3540%' Or
CompSys.model0 like '%3550%' Or
CompSys.model0 like '%3560%' Or
CompSys.model0 like '%3570%' Or
CompSys.model0 like '%5175%' Or
CompSys.model0 like '%5179%' Or
CompSys.model0 like '%E5250%' Or
CompSys.model0 like '%E5270%' Or
CompSys.model0 like '%5404%' Or
CompSys.model0 like '%5414%' Or
CompSys.model0 like '%E5430%' Or
CompSys.model0 like '%E5440%' Or
CompSys.model0 like '%E5450%' Or
CompSys.model0 like '%E5450%' Or
CompSys.model0 like '%E5470%' Or
CompSys.model0 like '%E5530%' Or
CompSys.model0 like '%E5530%' Or
CompSys.model0 like '%E5540%' Or
CompSys.model0 like '%E5550%' Or
CompSys.model0 like '%E5570%' Or
CompSys.model0 like '%E6230%' Or
CompSys.model0 like '%E6330%' Or
CompSys.model0 like '%E6430%' Or
CompSys.model0 like '%E6430%' Or
CompSys.model0 like '%E6440%' Or
CompSys.model0 like '%E6530%' Or
CompSys.model0 like '%E6540%' Or
CompSys.model0 like '%7202%' Or
CompSys.model0 like '%7204%' Or
CompSys.model0 like '%7214%' Or
CompSys.model0 like '%E7240%' Or
CompSys.model0 like '%E7250%' Or
CompSys.model0 like '%E7270%' Or
CompSys.model0 like '%7275%' Or
CompSys.model0 like '%E7350%' Or
CompSys.model0 like '%E7370%' Or
CompSys.model0 like '%7404%' Or
CompSys.model0 like '%7414%' Or
CompSys.model0 like '%E7440%' Or
CompSys.model0 like '%E7450%' Or
CompSys.model0 like '%E7470%' Or
CompSys.model0 like '%3010%' Or
CompSys.model0 like '%3020%' Or
CompSys.model0 like '%3030%' Or
CompSys.model0 like '%3040%' Or
CompSys.model0 like '%3046%' Or
CompSys.model0 like '%3240%' Or
CompSys.model0 like '%5040%' Or
CompSys.model0 like '%7010%' Or
CompSys.model0 like '%7020%' Or
CompSys.model0 like '%7040%' Or
CompSys.model0 like '%9010%' Or
CompSys.model0 like '%9020%' Or
CompSys.model0 like '%9030%' Or
CompSys.model0 like '%3420%' Or
CompSys.model0 like '%3620%' Or
CompSys.model0 like '%5810%' Or
CompSys.model0 like '%7810%' Or
CompSys.model0 like '%7910%' Or
CompSys.model0 like '%7910%' Or
CompSys.model0 like '%3510%' Or
CompSys.model0 like '%M3800%' Or
CompSys.model0 like '%M4800%' Or
CompSys.model0 like '%5510%' Or
CompSys.model0 like '%M6800%' Or
CompSys.model0 like '%M7510%' Or
CompSys.model0 like '%M7710%' Or
CompSys.model0 like '%5055%' Or
CompSys.model0 like '%5056%' Or
CompSys.model0 like '%5855%' Or
CompSys.model0 like '%7140%' )and
CompSys.Manufacturer0 like '%Dell%'
)
GROUP BY CompSys.Manufacturer0,CompSys.model0
ORDER BY CompSys.Model0
