From time to time admins have to run an inventory of what is running in the AD environment. This is a good practice for audits, inventory, removing decommissioned servers, or any other good reason. The details that are required are like when was computer/ server created, when was it last logged into, what is the OS, Service Pack, and OU details if any organization was done in structuring the OU.
Luckily PowerShell can provide all of that information in a nice .csv file which can be later edited in Excel to do filtering as needed.
Open up PowerShell in Admin mode on the DC or create a session if doing this remotely.
Get-ADComputer -Filter * -SearchBase "OU=Servers,DC=mowasay,DC=com" -Properties Name,LastLogonDate,OperatingSystem,OperatingSystemServicePack,OperatingSystemVersion,CanonicalName,whenCreated | Select-Object Name,LastLogonDate,OperatingSystem,OperatingSystemServicePack,OperatingSystemVersion,CanonicalName,whenCreated | Export-Csv c:\temp\Servers.csv -NoTypeInformation