Jul 21 2022 11:56 AM - edited Jul 21 2022 11:57 AM
I have been searching for info, I am not even sure if what I am doing is feasible. All I want to do is export AD all computers. I have the command "Get-ADComputer -Filter "*" | Export-CSV -Path c:\Users\USERNAME\documents\Computers.csv" and this works fine, BUT... I want to be able to add a pull of serial numbers 1) either through the attribute editor in AD or 2) by using Get-WmiObject Win32_BIOS | Select SerialNumber and having it the serial number displayed in the .csv file.
I have tried so many combinations of commands, but nothing works. I even tried to add in the "ForEach" option.
I have used Get-WmiObject Win32_ComputerSystem | Select Manufacturer,Model to get get the info from my own computer, but if I am able to get it exported into the .csv as well - not required, but would be a bonus for my reports.
If I can get a command that combines basic AD computer properties & at least serial number, I would greatly appreciate it. And if the command can also include what to add in the get the make/model of the computer, I would appreciate it more! Thank you for your time and assistance!
Jul 21 2022 12:33 PM
HI
Try this code
$allPC=Get-ADComputer -Filter *
$Fullresult=@()
Foreach ($singlePC in $allPC){
$Result=[PSCustomObject]@{
Name=$singlePC.Name
Enabled=$singlePC.Enabled
BIOS=(Get-WmiObject Win32_BIOS -ComputerName $singlePC.name).SerialNumber
}
$Fullresult+=$Result
}
$Fullresult | export-csv -path C:\Myresult.csv
Jul 21 2022 12:55 PM
Jul 21 2022 08:55 PM
Use this
$allPC=Get-ADComputer -Filter *
$Fullresult=@()
$UserNamePassword=Get-Credential
Foreach ($singlePC in $allPC){
$Result=[PSCustomObject]@{
Name=$singlePC.Name
Enabled=$singlePC.Enabled
BIOS=(Get-WmiObject Win32_BIOS -ComputerName $singlePC.name -Credential $UserNamePassword -Authentication Default ).SerialNumber
}
$Fullresult+=$Result
}
$Fullresult | export-csv -path C:\Myresult.csv
In line 8, you can replace the authentication with anything that fits your env.
The script asks for a username and password on line 3, just make sure to type it correct.
Jul 24 2022 09:11 AM