I have a text file with a simple single column list of AD User accounts (e.g. fde54326 ges11035). I want to create a CSV based on that list.
I want the output to include the user's manager's Last name, First name, Phone and Email.
I have basic powershell skills and I'm one of those people who gets writer's block when I try to code almost anything. I can usually piece and part things to get what I need, but I've tried a BUNCH of different things and need help. I know pieces
of my code work as part of other scripts I have pieced together.
Here's my code:
$UserList = Get-Content C:\scripts\LicenseCounts\hodUsers_short.txt
ForEach ($user in $UserList)
{
Get-AdUser $user -Properties * | Select SAMAccountName,DisplayName,GivenName,SN,TelephoneNumber,Department,Mail,Manager
$managerDetails = Get-ADUser (Get-ADUser $User -properties manager).manager -properties sn,givenName,telephoneNumber,mail
### $managerDetails = Get-ADUser (Get-ADUser $User -properties manager | Select manager | ? {$_.manager -ne $null} ).manager -properties sn,givenName,telephoneNumber,mail | Select sn,givenName,telephoneNumber,mail | ? {$_.sn -ne $null} | ? {$_.givenName -ne $null} | ? {$_.telephoneNumber -ne $null} | ? {$_.mail -ne $null}
$MGR_Last=$managerDetails.sn
$MGR_First=$managerDetails.givenName
$MGR_Phone=$managerDetails.telephoneNumber
$MGR_email=$managerDetails.mail
}
$UserList |
Select SamAccountName,DisplayName,GivenName,sn,TelephoneNumber,Department,Mail,$MGR_Last, $MGR_First,$MGR_Phone,$MGR_email
### | Export-CSV -Path C:\scripts\LicenseCounts\HODUsers_output.csv -NoTypeInformationcls
I have an alternate "ManagersDetails" and the export commented out so I can see the result on screen. My issue appears to be when I'm trying to "nest" the "managersdetail" part and the ouput from that.
Thank you all for any help!
