Knowing what operating systems the computers in your network are running is important.   Some operating system versions aren’t supported anymore by vendors.  Users running computers with these old operating systems can be at a security risk.

Active Directory Computer Reports Grouped by Operating System in PowerShell

When you run the following script on your server, it will fetch computers and group them by their operating system. With a little bit of effort you could export this to a CSV, HTML file, or send it in an email.

import-module activedirectory
$Computers = @(Get-ADComputer -Properties Name,operatingSystem -Filter {(OperatingSystem -like "*")})
$Computers | Group-Object operatingSystem | Select Count, Name | Sort Name

You might also want to use a service account (“-Credentials” on your PowerShell commands) to keep things more secure.

Web Active Directory’s PeopleAudit

Web Active Directory’s PeopleAudit allows you to run a report like this on demand or delegate it safely for others in your organization to run via their web browser. Users can filter and sort the results on the fly, and with a single button press print the results or export to your clipboard, PDF, Excel, or CSV.

In addition, these reports allow your users to drill into the results to get more details and to view the results graphically via pie or bar charts.

Safely and securely specify the service account to use to perform the reporting tasks.

Customize the report results, drill-down parameter, and filters without scripting or coding.

You can also schedule these reports to be delivered to you or others in your organization via emails that you can configure without scripting or coding.