Dump AD Information

I needed to grab all information about our current asset lists and our KACE tool was not to be believed in terms of inventory (HR said we have 500 employees, O365 said we have 615, and Kace said 322 devices).

Load up powershell on a domain controller Get-ADComputer -Filter * -Property * | Select-Object Name,OperatingSystem,OperatingSystemServicePack,OperatingSystemVersion,LastLogonDate | Export-CSV c:\logs\AllWindowsDump.csv -NoTypeInformation -Encoding UTF8

From there I could use Excel to massage the data and sort accordingly.

Leave a Reply

Your email address will not be published. Required fields are marked *