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. …

move computer

PowerShell Tip of the Week: Move computer objects to OU

Find out how to move computer objects to different OU. In this example, you need to have the Active Directory module installed and distingushednames of the target organizational unit and the source. Move computers PowerShell script is based on Move-ADObject command. This cmdlet moves an object or a container of objects from one container to another or from one domain to another. To move a single computer you can use …

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 …