Powershell Compile all matching rows from CSV

Question

I have a CSV file with a list of Users and who they are managed by with these headers:
DisplayName,Alias,CA5,Managedby

I want to import this list in powershell and be able to send one email to each manager with the list of accounts (DisplayName,Alias,CA5) that they are listed as the manager of in the managedby field. I can create the email with out issue I need to know how to compile all the lines of the CSV file that should all go to into the same email. With the sample CSV below I should end up with three emails (one each to ManagedByA, ManagedbyB and ManagedByC). The email to ManagedByA would have three lines containing:

DN1 A1
DN2 A2 DL
DN3 A3

My CSV look like this:

    DisplayName,Alias,CA5,ManagedBy
    DN1,A1,,ManagedByA
    DN2,A2,DL,ManagedByA
    DN3,A3,,ManagedByA
    DN4,A4,,ManagedByB
    DN5,A5,,ManagedByB
    DN6,A6,DL,ManagedByB
    DN7,A7,,ManagedByB
    DN8,A8,,ManagedByC
    DN9,A9,DL,ManagedByC
    DN10,A10,,ManagedByC

My Code (from Mathias R. Jessen):

$Import = Import-CSV "C:\powershell\DL\Reports\DLReportEmail.csv"

### Find unique ManagedBy
$Managers = $Import | Sort-Object -Property ManagedBy -Unique

ForEach ($Manager in $Managers){
   $Employees = $Import | Where-Object {$_.ManagedBy -eq $Manager.ManagedBy}

   $Body = "DearXXXX,  `r`n"
   ForEach($Employee in $Employees){
       $Alias = $Employee.Alias
       $DisplayName = $Employee.DisplayName
       $CA5 = $Employee.CA5
       $Body += "$DisplayName : $Alias : $CA5  `r`n"
       }
   $Body += "`r`n"
   $Body += "Thanks"

Awesome, Can you please post some code? And let us know where you are stuck? — Mitul
– Mitul, Commented Sep 17, 2013 at 20:48
Which of the columns identifies the user? I.e. what is the unique identifier for a particular user? — zdan
– zdan, Commented Sep 17, 2013 at 21:23

Mathias R. Jessen · Accepted Answer · 2013-09-18 01:44:27Z

1

You can import the csv, extract each unique manager name, and then compile a subset of the list by using the ManagedBy values you've already extracted:

$Users = Import-Csv C:\filename.csv
$Managers = $Users | Sort-Object -Property ManagedBy -Unique

for($Manager in $Managers)
{
    $Employees = $Users |Where-Object {$_.ManagedBy -eq $Manager.ManagedBy}
    // send your email here with the contents of $Employees
}

answered Sep 18, 2013 at 1:44

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

Collectives™ on Stack Overflow

Powershell Compile all matching rows from CSV

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related