Practice List Finance team accounts

List Finance team accounts

Exercise 1 min read Windows PowerShell 5.1 and PowerShell 7

Written and tested by Dhrub Bharali · Updated 02 October 2026

Return every account in the Finance department.

The task

Finance is rolling out a new expense tool. List every Finance account so nobody is missed during onboarding.

Return every account in the Finance department.

One Where-Object on Department narrows the whole directory to a single team before you pick the columns for the report.

Run the source by itself and inspect the sample objects. Add each filter separately, then check the final properties and order.

The browser uses a small fictional dataset. Real results depend on the host, module, account and target environment.

Choose an answer, then check your reasoning.

Worked solution

Reveal one approach

1PS> Get-ADUser -Filter * | Where-Object Department -eq 'Finance' | Select-Object Name, SamAccountName

Write your pipeline below and run it against the fictional sample data, then check your result against the expected answer.

Your pipeline

Interactive simulation · fictional data