How can I get a count from a PS command

Question

I have a powershell command:

Get-ADGroupMember -identity "CCVGHCFinReadOnly" -Recursive | foreach{ get-aduser -properties employeeid $_} | select SamAccountName,objectclass,name,employeeid | Export-Csv "C:\Temp\AD Membership\GovReadOnly.csv

This script works great to return members of AD groups. I also want to add the count for auditing purposes. So the script should list all ad users and then a count at the bottom.

Right now if I use | Measure it gives me a count but that is all I get. So I can either get the actual users in the AD group OR the count. How can I get both with this one command?

Ansgar Wiechers · Accepted Answer · 2016-10-19 13:42:06Z

1

$members = Get-ADGroupMember ... | select SamAccountName,objectclass,name,employeeid

$members | Export-Csv "C:\Temp\AD Membership\GovReadOnly.csv"
@($members).Count | Add-Content "C:\Temp\AD Membership\GovReadOnly.csv"

answered Oct 19, 2016 at 13:42

Ansgar Wiechers

202k27 gold badges286 silver badges363 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

VinnyGuitara Over a year ago

Never thought of pumping the output to a variable then reading the var into the file and then counting the members. This is simple and brilliant. Thanks.

Jason Boyd · Accepted Answer · 2016-10-19 13:42:15Z

1

Off the top of my head side effects come to mind. In this example I am incrementing a variable outside of the pipeline from within the pipeline. I admit it feels kind of gross. Maybe somebody else can suggest a solution that does not rely on this sort of side effect.

$count = 0
Get-ADGroupMember -identity "CCVGHCFinReadOnly" -Recursive `
| foreach { 
    $count++
    get-aduser -properties employeeid $_} `
| select SamAccountName,objectclass,name,employeeid `
| Export-Csv "C:\Temp\AD Membership\GovReadOnly.csv

Now you can do whatever you want with $count.

answered Oct 19, 2016 at 13:42

Jason Boyd

7,0495 gold badges33 silver badges53 bronze badges

1 Comment

VinnyGuitara Over a year ago

This works but I agree it just doesn't feel good. I was doing something similar before I jumped over. Thanks though!

Collectives™ on Stack Overflow

How can I get a count from a PS command

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related