BassTech Posted August 18, 2016 Posted August 18, 2016 Does anyone know of a tool that can scan the network and can list/export all of the computer model numbers? I'm trying to make sure I have all of the drivers for our different computer models, so they can all build ok onto our new 2012 R2 platform
DalekSec Posted August 18, 2016 Posted August 18, 2016 Do you use SCCM? Various reports in there come back with make and model Edit: Report i use is "Hardware 01A - Summary of computers in a specific collection" and then point it to all computers.
BassTech Posted August 18, 2016 Author Posted August 18, 2016 Do you use SCCM? Various reports in there come back with make and model Edit: Report i use is "Hardware 01A - Summary of computers in a specific collection" and then point it to all computers. No, we're currently on Server 2003, in the process of migrating over to 2012 R2 which will have SCCM but it's not up & running yet & I need to get the models this week
Steve21 Posted August 18, 2016 Posted August 18, 2016 We use SCCM etc but we still have a logon script that writes back the model numbers/name etc to the AD description for a pc, maybe an option? or did you want something just to run once off? Steve
Norphy Posted August 18, 2016 Posted August 18, 2016 (edited) PowerShell? It's a bit hacky but I think this would work: Import-Module ActiveDirectory $Computers = Get-ADComputer -filter * $Results = @() $Computers | foreach { Clear-Variable ping $Ping = Test-Connection -computername $_.DNSHostName -Count 1 if ($Ping -ne $null) { $ComputerSystem = Get-WmiObject -ComputerName $_.DNSHostName -Class Win32_ComputerSystem $NewObject = New-Object System.Object $NewObject | Add-Member -MemberType NoteProperty -Name "MachineName" -Value $_.Name $NewObject | Add-Member -MemberType NoteProperty -Name "Brand" -Value $ComputerSystem.Manufacturer $NewObject | Add-Member -MemberType NoteProperty -Name "Model" -Value $ComputerSystem.Model $Results += $NewObject } } $Results | ConvertTo-Csv | Out-File $env:userprofile\Documents\results.csv Requires RSAT to be installed on your machine. It'll produce a table like this: MachineName Brand Model ----------- ----- ----- KLM220-12 Hewlett-Packard HP Compaq 6200 Pro SFF PC HPG46-19 Hewlett-Packard HP Compaq 6200 Pro SFF PC HPG38-23 Dell Inc. OptiPlex 3240 AIO HPG37-07 Hewlett-Packard HP Compaq 6200 Pro SFF PC HJD71-01 Hewlett-Packard HP Compaq dc7800 Small Form Factor KLM220-11 Hewlett-Packard HP Compaq 6200 Pro SFF PC HPG38-14 Dell Inc. OptiPlex 3240 AIO HPG46-15 Hewlett-Packard HP Compaq 6200 Pro SFF PC HPG46-14 Hewlett-Packard HP Compaq 6200 Pro SFF PC CIT53-TD Dell Inc. OptiPlex 3020 HJT42-27 Hewlett-Packard HP Compaq 6200 Pro SFF PC KLM216-TD Hewlett-Packard HP Compaq 6200 Pro SFF PC KLM3-LCM Hewlett-Packard HP Compaq dc7800 Small Form Factor HJT42-11 Hewlett-Packard HP Compaq 6200 Pro SFF PC KLM215-TD Hewlett-Packard HP Compaq 6200 Pro SFF PC HPG46-20 Hewlett-Packard HP Compaq 6200 Pro SFF PC HPG38-15 Dell Inc. OptiPlex 3240 AIO KLM130-01 Hewlett-Packard HP Compaq dc7900 Small Form Factor KLM318-TD Hewlett-Packard HP Compaq 6200 Pro SFF PC HPG38-08 Dell Inc. OptiPlex 3240 AIO HPG46-17 Hewlett-Packard HP Compaq 6200 Pro SFF PC HJT41-05 Hewlett-Packard HP Compaq 6200 Pro SFF PC HJT41-11 Hewlett-Packard HP Compaq 6200 Pro SFF PC KLM223-08 Hewlett-Packard HP Compaq 8200 Elite SFF PC HJT42-07 Hewlett-Packard HP Compaq 6200 Pro SFF PC CIT12-04 Dell Inc. OptiPlex 3020 CIT12-23 Dell Inc. OptiPlex 3020 HPG46-23 Hewlett-Packard HP Compaq 6200 Pro SFF PC CIT52-01 Dell Inc. OptiPlex 3020 Edited August 18, 2016 by Norphy
adhutton Posted August 18, 2016 Posted August 18, 2016 You can do it in Impero if you have that. Andrew
BassTech Posted August 18, 2016 Author Posted August 18, 2016 PowerShell? It's a bit hacky but I think this would work: Import-Module ActiveDirectory $Computers = Get-ADComputer -filter * $Results = @() $Computers | foreach { Clear-Variable ping $Ping = Test-Connection -computername $_.DNSHostName -Count 1 if ($Ping -ne $null) { $ComputerSystem = Get-WmiObject -ComputerName $_.DNSHostName -Class Win32_ComputerSystem $NewObject = New-Object System.Object $NewObject | Add-Member -MemberType NoteProperty -Name "MachineName" -Value $_.Name $NewObject | Add-Member -MemberType NoteProperty -Name "Brand" -Value $ComputerSystem.Manufacturer $NewObject | Add-Member -MemberType NoteProperty -Name "Model" -Value $ComputerSystem.Model $Results += $NewObject } } $Results | ConvertTo-Csv | Out-File $env:userprofile\Documents\results.csv Requires RSAT to be installed on your machine. It'll produce a table like this: MachineName Brand Model ----------- ----- ----- KLM220-12 Hewlett-Packard HP Compaq 6200 Pro SFF PC HPG46-19 Hewlett-Packard HP Compaq 6200 Pro SFF PC HPG38-23 Dell Inc. OptiPlex 3240 AIO HPG37-07 Hewlett-Packard HP Compaq 6200 Pro SFF PC HJD71-01 Hewlett-Packard HP Compaq dc7800 Small Form Factor KLM220-11 Hewlett-Packard HP Compaq 6200 Pro SFF PC HPG38-14 Dell Inc. OptiPlex 3240 AIO HPG46-15 Hewlett-Packard HP Compaq 6200 Pro SFF PC HPG46-14 Hewlett-Packard HP Compaq 6200 Pro SFF PC CIT53-TD Dell Inc. OptiPlex 3020 HJT42-27 Hewlett-Packard HP Compaq 6200 Pro SFF PC KLM216-TD Hewlett-Packard HP Compaq 6200 Pro SFF PC KLM3-LCM Hewlett-Packard HP Compaq dc7800 Small Form Factor HJT42-11 Hewlett-Packard HP Compaq 6200 Pro SFF PC KLM215-TD Hewlett-Packard HP Compaq 6200 Pro SFF PC HPG46-20 Hewlett-Packard HP Compaq 6200 Pro SFF PC HPG38-15 Dell Inc. OptiPlex 3240 AIO KLM130-01 Hewlett-Packard HP Compaq dc7900 Small Form Factor KLM318-TD Hewlett-Packard HP Compaq 6200 Pro SFF PC HPG38-08 Dell Inc. OptiPlex 3240 AIO HPG46-17 Hewlett-Packard HP Compaq 6200 Pro SFF PC HJT41-05 Hewlett-Packard HP Compaq 6200 Pro SFF PC HJT41-11 Hewlett-Packard HP Compaq 6200 Pro SFF PC KLM223-08 Hewlett-Packard HP Compaq 8200 Elite SFF PC HJT42-07 Hewlett-Packard HP Compaq 6200 Pro SFF PC CIT12-04 Dell Inc. OptiPlex 3020 CIT12-23 Dell Inc. OptiPlex 3020 HPG46-23 Hewlett-Packard HP Compaq 6200 Pro SFF PC CIT52-01 Dell Inc. OptiPlex 3020 Will give this a go - thanks! @adhutton - we do have impero but it's only installed in ICT classrooms so wouldn't get them all I don't think
Guest MD5T Posted August 21, 2016 Posted August 21, 2016 Check that there isn't a WMIC command for this. I use one for exporting serial numbers
BassTech Posted August 22, 2016 Author Posted August 22, 2016 Will give this a go - thanks! Didn't work in the end, can't get Active Directory Web Services running on the server Installed spiceworks which has gotten about 60% of the model numbers off, may just have to cross my fingers and hope I've got them all!
tim88 Posted August 22, 2016 Posted August 22, 2016 try pdq inventory. PDQ Inventory . The free version will pull the model numbers for you, aswell as serial numbers etc.
Elison Posted September 5, 2016 Posted September 5, 2016 You can get the table from the script above using 10-strike network inventory explorer (link). Information is gathered via WMI. To create a report use "Summary" (see screenshot). Press "Columns" and choose columns like on the screenshot. You can save report in different formats. Program also allows tracking software and hardware changes, performing detailed SAM processes, etc
Foresthippy Posted September 5, 2016 Posted September 5, 2016 The following run as a script will work: wmic computersystem get model Pipe the result into a text file called %computername%.txt
ReadTheNetwork Posted September 6, 2016 Posted September 6, 2016 wmi computersystem get model Just to update this to something like: wmic /node:@hostname.txt /username:admin /password:thepassword /output:result.csv computersystem get model /format:csv
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now