get computer

Get AD Computer examples

In this post, I want to share a few examples of Get-ADComputer command. If ever you wondered how to get computer objects from Active Directory by some specific property, by password last set property or range, last logon date, or some other search criteria this article if for you. Below you can find few scripts that I was using recently 🙂 Get all computers To get all computers from Active …

pivot table

Create a Pivot Table in Excel using PowerShell script

Find out how to create a Pivot Table in Excel using a PowerShell script. In one of the previous articles, I described how to get computer objects from OUs. In this case, I wanted to show you how to export the same results to Excel and create Pivot Table. Pivot Table in Excel To create something in Excel using PowerShell we need to have ImportExcel module installed on our PC. …

OU

Get computer objects from OUs

In this short article, I would like to share the PowerShell script for getting computer objects from parent Organizational Units (OUs). Organizational Unit (OU) is a container in the Active Directory domain that can contain different objects from the same AD domain: other containers, groups, user and computer accounts. Get computer objects Recently I was asked to prepare a report in Excel and count objects in each OU. To do …