Forum Discussion

Kerslock's avatar
Kerslock
Copper Contributor
Jul 21, 2022

Powershell Command for AD export

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:\Us...
powershell
PowerShell - AD
farismalaeb's avatar
farismalaeb
Iron Contributor
Jul 21, 2022

Kerslock 

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
Kerslock's avatar
Kerslock
Copper Contributor
Jul 21, 2022

farismalaeb 

 

My network is blocking it - UnauthorizedAccessException

  • farismalaeb's avatar
    farismalaeb
    Iron Contributor
    Jul 24, 2022

    Kerslock 

    Any update on this one

    If the answer helped you, please mark it as Best Response.

    Thanks

     

  • farismalaeb's avatar
    farismalaeb
    Iron Contributor
    Jul 22, 2022

    Kerslock 

    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.

Resources