Select Distinct Manufacturer0,
Model0 >From v_GS_COMPUTER_SYSTEM Manufacturer0 Model0 Acer Veriton X490G ADVANCE AA-7932 BANGHO BES1300 BANGHO MOV Bangho W130HU Bangho ZERO CLEVO CO. W130HU Dell Computer Corporation OptiPlex GX270 Dell Inc OptiPlex 740 Dell Inc. Dell System Vostro 3450 Dell Inc. Dell System XPS L321X Dell Inc. Inspiron N4050 Dell Inc. Latitude D430 Dell Inc. Latitude D520 Dell Inc. Latitude D530 Dell Inc. Latitude D610 Dell Inc. Latitude D620 Dell Inc. Latitude D630 Dell Inc. Latitude D830 Dell Inc. Latitude E4300 Dell Inc. Latitude E4310 Dell Inc. Latitude E5400 Dell Inc. Latitude E5410 Dell Inc. Latitude E5420 Dell Inc. Latitude E5420m Dell Inc. Latitude E5500 Dell Inc. Latitude E5510 Dell Inc. Latitude E5520 Dell Inc. Latitude E6220 Dell Inc. Latitude E6320 Dell Inc. Latitude E6400 Dell Inc. Latitude E6410 Dell Inc. Latitude E6420 Dell Inc. Latitude E6430 Dell Inc. Latitude E6520 Dell Inc. OptiPlex 210L Dell Inc. OptiPlex 3010 Dell Inc. OptiPlex 330 Dell Inc. OptiPlex 380 Dell Inc. OptiPlex 390 Dell Inc. OptiPlex 7010 Dell Inc. OptiPlex 745 Dell Inc. OptiPlex 755 Dell Inc. OptiPlex 760 Dell Inc. OptiPlex 780 Dell Inc. OptiPlex 790 Dell Inc. OptiPlex 990 Dell Inc. OptiPlex GX520 Dell Inc. OptiPlex GX620 Dell Inc. PowerEdge 2950 Dell Inc. PowerEdge R710 Dell Inc. Precision M6300 Dell Inc. Precision WorkStation 380 Dell Inc. Precision WorkStation 390 Dell Inc. Precision WorkStation 490 Dell Inc. Precision WorkStation T3400 Dell Inc. Precision WorkStation T3500 Dell Inc. Precision WorkStation T5400 Dell Inc. Precision WorkStation T5500 Dell Inc. Precision WorkStation T7400 Dell Inc. Precision WorkStation T7500 Dell Inc. Vostro 200 Dell Inc. Vostro 220 Series Dell Inc. Vostro 260s GETAC V200-G2 Getac Corporation V200-X Gigabyte Technology Co., Ltd. EG45M-DS2H Gigabyte Technology Co., Ltd. H61M-S2V-B3 Hewlett-Packard 1423____ Hewlett-Packard 30DD____ Hewlett-Packard 310-1205la Hewlett-Packard DSDT_PRJ Hewlett-Packard HP 2230s Hewlett-Packard HP 500B Microtower Hewlett-Packard HP Compaq 6000 Pro SFF Brazil PC Hewlett-Packard HP Compaq 6530b Hewlett-Packard HP Compaq 6530b (WA485LA#AC4) Hewlett-Packard HP Compaq 8000 Elite SFF PC Hewlett-Packard HP Compaq 8100 Elite SFF Brazil PC Hewlett-Packard HP Compaq 8100 Elite SFF PC Hewlett-Packard HP Compaq 8200 Elite CMT PC Hewlett-Packard HP Compaq 8200 Elite SFF PC Hewlett-Packard HP Compaq dc5700 Microtower Hewlett-Packard HP Compaq dc7900 Small Form Factor Hewlett-Packard HP Compaq dx2390 Microtower Hewlett-Packard HP Compaq Elite 8300 SFF Hewlett-Packard HP Compaq Elite SFF Hewlett-Packard HP Compaq Pro 6300 SFF Hewlett-Packard HP EliteBook 2530p Hewlett-Packard HP EliteBook 2540p Hewlett-Packard HP EliteBook 2540p (WH283UT) Hewlett-Packard HP EliteBook 2540p (WT965PA) Hewlett-Packard HP EliteBook 2540p (XD123PA#AB4) Hewlett-Packard HP EliteBook 2540p (XV055LA#AC4) Hewlett-Packard HP EliteBook 2560p Hewlett-Packard HP EliteBook 2570p Hewlett-Packard HP EliteBook 2760p Hewlett-Packard HP EliteBook 6930p Hewlett-Packard HP EliteBook 6930p (FM899UA) Hewlett-Packard HP EliteBook 820 G1 Hewlett-Packard HP EliteBook 840 G1 Hewlett-Packard HP EliteBook 8440p Hewlett-Packard HP EliteBook 8440p (WH256U) Hewlett-Packard HP EliteBook 8440p (WH256UT) Hewlett-Packard HP EliteBook 8440p (XT917UT) Hewlett-Packard HP EliteBook 8440p (XT918UT) Hewlett-Packard HP EliteBook 8440w Hewlett-Packard HP EliteBook 8460p Hewlett-Packard HP EliteBook 8460p (LQ168AW#ABA) Hewlett-Packard HP EliteBook 8460p (LQ168AW) Hewlett-Packard HP EliteBook 8460w Hewlett-Packard HP EliteBook 8470p Hewlett-Packard HP EliteBook 850 G1 Hewlett-Packard HP EliteBook 8530p Hewlett-Packard HP EliteBook 8540p Hewlett-Packard HP EliteBook 8540w Hewlett-Packard HP EliteBook 8560p Hewlett-Packard HP EliteBook 8560w Hewlett-Packard HP EliteBook 8560w (XU085UT) Hewlett-Packard HP EliteBook 8570p Hewlett-Packard HP EliteBook 8570w Hewlett-Packard HP EliteBook 8740w Hewlett-Packard HP EliteBook 8740w (WH275UT) Hewlett-Packard HP EliteBook 8760w Hewlett-Packard HP EliteBook 8770w Hewlett-Packard HP EliteBook Folio 9470m Hewlett-Packard HP EliteBook Revolve 810 G1 Hewlett-Packard HP Folio 13 - 2000 Notebook PC Hewlett-Packard HP Folio 13 Notebook PC Hewlett-Packard HP G42 Notebook PC Hewlett-Packard HP Pavilion dv4 Notebook PC Hewlett-Packard HP Pavilion g4 Notebook PC Hewlett-Packard HP Pro 3130 Microtower PC Hewlett-Packard HP Pro 3500 Series Hewlett-Packard HP ProBook 4320s Hewlett-Packard HP ProBook 4440s Hewlett-Packard HP ProBook 640 G1 Hewlett-Packard HP ProBook 6450b Hewlett-Packard HP ProBook 6450b (XG558LA#AC4) Hewlett-Packard HP ProBook 6460b Hewlett-Packard HP ProBook 650 G1 Hewlett-Packard HP ProBook 6560b Hewlett-Packard HP ProDesk 600 G1 SFF Hewlett-Packard HP rp5700 Business System Hewlett-Packard HP xw4600 Workstation Hewlett-Packard HP xw6600 Workstation Hewlett-Packard HP Z200 Workstation Hewlett-Packard HP Z400 BASE MODEL WORKSTATION Hewlett-Packard HP Z400 Workstation Hewlett-Packard HP Z420 Workstation Hewlett-Packard HP ZBook 14 Hewlett-Packard HP ZBook 15 Hewlett-Packard HP ZBook 17 Hewlett-Packard MXL1192B6J Hewlett-Packard ProLiant BL460c G6 HP ProLiant BL460c G1 HP ProLiant BL460c G6 HP ProLiant BL460c G7 HP ProLiant BL460c Gen8 HP ProLiant DL160 G5 HP ProLiant DL160 G6 HP ProLiant DL320 G6 HP ProLiant DL360 G6 HP ProLiant DL360 G7 HP ProLiant DL360p Gen8 HP ProLiant DL380 G5 HP ProLiant DL380 G7 HP ProLiant DL580 G5 HP ProLiant DL580 G7 HP ProLiant MicroServer HPQOEM 161E____ HPQOEM 1631____ INTEL_ D865GBF_ LENOVO 4382 LENOVO INVALID Microsoft Corporation Surface Pro 2 Microsoft Corporation Surface with Windows 8 Pro Microsoft Corporation Virtual Machine VMware, Inc. VMware Virtual Platform On Wed, Aug 6, 2014 at 2:31 PM, Keith Garner (Hotmail) < [email protected]> wrote: > Can I persuade a Config Mgr Admin for a list of Computer Makes/Models as > queried from the BIOS/Firmware? Hopefully a broad unique list of Makes and > Models for current machines. Lenovo’s, HP’s, Dell’s, more? > > > > I’ve been working on some Driver management solutions for an OS Deployment > system(LTI & ZTI), but my hardware lab is quite limited right now, so it’s > hard to create a structured driver system without the correct make/models. > > > > (and of course because Lenovo… ComputerSystemProduct) > > *gwmi -query "select Manufacturer,Model FROM Win32_ComputerSystem"* > > *gwmi -query "select Version FROM Win32_ComputerSystemProduct"* > > > > Thanks in advance, > > [email protected] > > > > >
