How to export Powershell Script to .CSV

jimmyjohnson4 · 2018-04-19T12:01:48.000Z

Hi guys,

I’m trying to create an org chart for my company’s SP Site. However, I need to export my staff’s name and their manager from AD.
Here’s the script I’ve got so far, but I need to make this possible to be exported.

$Male = 
Get-ADGroupMember "All 
Male Staff"

$Female = 
Get-ADGroupMember "All 
Female Staff"

$Staff = 
$Male + 
$Female

$Staff = 
$Staff | 
Get-ADUser -Properties 
Name, 
Manager

 

ForEach($Anything 
in $Staff) 
{

 

Write-Host $Anything.Name

 

$Manager = 
$Anything.Manager 
-split(",") 

 $Manager = $Manager[0] -replace("CN=","Manager = 
")

 $Manager

 

Write-Host "---------"

}

Any help on this would be greatly appreciated

Thanks,
Jimmy

gregory-for-microsoft · 2018-04-19T12:10:03.000Z

$Male = 
Get-ADGroupMember "All 
Male Staff"

$Female = 
Get-ADGroupMember "All 
Female Staff"

$Staff = 
$Male + 
$Female

$Staff = 
$Staff | 
Get-ADUser -Properties 
Name, 
Manager

 

ForEach($Anything 
in $Staff) 
{

 

Write-Host $Anything.Name

 

$Manager = 
$Anything.Manager 
-split(",") 

 $Manager = $Manager[0] -replace("CN=","Manager = 
")

 $Manager

 

Write-Host "---------"

} | Export-Csv c:\csv\filexport.csv

jimmyjohnson4 · 2018-04-19T12:24:05.000Z

At line:16 char:5

Name,
~
Missing argument in parameter list.
CategoryInfo : ParserError: ( , ParentContainsErrorRecordException
FullyQualifiedErrorId : MissingArgument

Returned back this

Neally · 2018-04-19T13:50:05.000Z

Welcome Jimmy,

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don't say "Need help" or "PowerShell Help", actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…

Neally · 2018-04-19T14:14:34.000Z

If you already repost it, it would have been nice if you would have fixed it :¬P

OP, try like so

$Male   = Get-ADGroupMember "All Male Staff"
$Female = Get-ADGroupMember "All Female Staff"
$Staff  = $Male + $Female
$Staff  = $Staff |  Get-ADUser -Properties Name, Manager

ForEach ($Anything in $Staff) {
    Write-output $Anything.Name
    $Manager =  ($anything | select @{n='Manager';e={(get-aduser $_.manager).surname}}).manager
    write-output "Manager = $manager"
    Write-Host "---------"
}

@gregory-for-microsoft