Quick power shell to run on a Domain Controller to export all Computers with last logged in time to a CSV file located in C:\\Temp\\ExportADComputers
\nSome code was based on a Technet example but improved for my use to get Extended details out.<\/p>\n
Example of CSV output<\/p>\n
name\twhenCreated\tIPv4Address\tOperatingSystem\tOperatingSystemVersion\tLastLogonDate\tEnabled
\nComputer-001\t09\/01\/2017 18:05\t10.x.x.x\tWindows 10 Pro\t10.0 (14393)\t09\/01\/2017 18:08\tTRUE<\/p>\n
\r\n###########################################################\r\n# AUTHOR : Darren Banfi\r\n# CREATED : 11-04-2018 \r\n# UPDATED : \r\n# COMMENT : This script exports Active Directory computers\r\n# to a a csv file.\r\n###########################################################\r\n\r\n#1.0 - First Release\r\n\r\n\r\n# Created Folder automatically\r\nNew-Item -ItemType directory -Path C:\\Temp\\ExportADComputers\r\n\r\n#Define location of my script variable\r\n#the -parent switch returns one directory lower from directory defined. \r\n#below will return up to ImportADUsers folder \r\n#and since my files are located here it will find it.\r\n#It failes withpout appending "*.*" at the end\r\n\r\n$path = Split-Path -parent "c:\\temp\\ExportADComputers\\*.*"\r\n\r\n#Create a variable for the date stamp in the log file\r\n\r\n$LogDate = get-date -f yyyyMMddhhmm\r\n\r\n#Define CSV and log file location variables\r\n#they have to be on the same location as the script\r\n\r\n$csvfile = $path + "\\ALLADComputers_$logDate.csv"\r\n\r\n#import the ActiveDirectory Module\r\n\r\nImport-Module ActiveDirectory\r\n\r\n\r\n#Sets the OU to do the base search for all Computer accounts, change as required.\r\n\r\n$OUpaths = GET-ADDomain | Select-Object -ExpandProperty ComputersContainer\r\n\r\n#Get Admin accountb credential\r\n\r\n$GetAdminact = Get-Credential\r\n\r\n# loop though the array of OUs, adding the computers to a list ('Object' really)\r\nforeach ($iOUpath in $OUpaths)\r\n {\r\n ($objComputers += Get-ADComputer -SearchBase $iOUpath -Properties * -Filter *) #You might need to refine the query witha 'Filter' depending on your AD structure\r\n }\r\n\r\n\r\n#Export CSV report\r\n\r\n$objComputers | Select name, whenCreated, IPv4Address, OperatingSystem, OperatingSystemVersion, LastLogonDate, Enabled | Export-Csv -LiteralPath $csvfile -NoTypeInformation\r\n\r\n#Open the folder on screen\r\nii C:\\Temp\\ExportADComputers\r\n\r\n"Done"\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"Quick power shell to run on a Domain Controller to export all Computers with last logged in time to a CSV file located in C:\\Temp\\ExportADComputers Some code was based on a Technet example but improved for my use to get Extended details out. Example of CSV output name whenCreated IPv4Address OperatingSystem OperatingSystemVersion LastLogonDate Enabled Computer-001 … Continue reading Export Active Directory Computers to CSV<\/span>