Trying to get AD Email Address for a File Owner

spiceuser-marty61 · 2020-10-26T17:47:11.000Z

I am a novice to PowerShell

Here is my script

$Path = “C:\Users”
$LogPath = “C:\Downloads\reports”
Get-ChildItem $Path -force -Recurse | Select Name,Directory,@{Name=“Owner”;Expression={(Get-ACL $_.Fullname).Owner}},CreationTime,LastAccessTime | Export-Csv $LogPath\FileFolderOwner.csv -NoTypeInformation

How would I get the email address of the File Owner. We want to email the file back to the owner.

I am new to the group and think this is a great site!!

Neally · 2020-10-26T17:55:19.000Z

Do you use active directory, or where would the email address for the user be stored?

Are you using always the same format for a user?

e.g.

Jon Doe → email is jdoe@domain.com

You could build it like that, but a source, like AD might be better.

Neally · 2020-10-26T17:55:47.000Z

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…

spiceuser-marty61 · 2020-10-26T18:02:00.000Z

$Path = "C:\Users"
$LogPath = "C:\Downloads\reports"
Get-ChildItem $Path -force -Recurse | Select Name,Directory,@{Name="Owner";Expression={(Get-ACL $_.Fullname).Owner}},CreationTime,LastAccessTime | Export-Csv $LogPath\FileFolderOwner.csv -NoTypeInformation

Thanks for the code insert Tip.

We do use you Active Directory. I can get the file owner, but I was hoping to get the email address as well.

Neally · 2020-10-26T18:07:44.000Z

spiceuser-Marty61:

$Path = "C:\Users"
$LogPath = "C:\Downloads\reports"
Get-ChildItem $Path -force -Recurse | Select Name,Directory,@{Name="Owner";Expression={(Get-ACL $_.Fullname).Owner}},CreationTime,LastAccessTime | Export-Csv $LogPath\FileFolderOwner.csv -NoTypeInformation
Thanks for the code insert Tip.

We do use you Active Directory. I can get the file owner, but I was hoping to get the email address as well.

not from the ‘get-acl’ cmdlet, you have to query AD.

e.g. (this assumes you have the AD module installed)

$Path = "C:\Users"
$LogPath = "C:\Downloads\reports"
Get-ChildItem $Path -force -Recurse | 
Select Name,Directory,
@{Name="Owner";Expression={(Get-ACL $_.Fullname).Owner}},
@{Name="OwnerEmail";Expression={(get-aduser (Get-ACL $_.Fullname).Owner -pr emailaddress).emailaddress}},
CreationTime,LastAccessTime | 
Export-Csv $LogPath\FileFolderOwner.csv -NoTypeInformation

Neally · 2020-10-26T18:13:12.000Z

also look into splatting / pscustomobjects, much better to read.

$Path = "C:\Users"
$LogPath = "C:\Downloads\reports"
$data = Get-ChildItem $Path -force -Recurse

$report = 
foreach ($file in $data) {
    $owner = (Get-ACL $file.Fullname).Owner
    $email = $null
    $email = (Get-aduser $owner -properties emailaddress).emailaddress

    [pscustomobject]@{
        Name           = $file.name
        Directory      = $file.directory
        CreationTime   = $file.CreationTime
        LastAccessTime = $file.LastAccessTime
        Owner          = $owner
        OwnerEmail     = if ($email) { $email }else { '' }
    }
}

$report =
Export-Csv "$LogPath\FileFolderOwner.csv" -NoTypeInformation

spiceuser-marty61 · 2020-10-26T18:20:45.000Z

Thank you . Would I need to strip the Domain off of the username to get the email? The email field came back blank. There were no errors at execution.

Neally · 2020-10-26T18:31:12.000Z

spiceuser-Marty61:

Thank you . Would I need to strip the Domain off of the username to get the email? The email field came back blank. There were no errors at execution.

possibly, I’m just giving you the concept you still have to put some effort in yourself ;¬)

spiceuser-marty61 · 2020-10-26T18:34:59.000Z

Thank You. I appreciate the help!

Neally · 2020-10-26T18:36:29.000Z

spiceuser-Marty61:

Thank You. I appreciate the help!

give it a shot, if you get stuck feel free to post what you have tried and we’ll help more.

spiceuser-marty61 · 2020-10-26T18:38:00.000Z

Will Do! I truly appreciate the help yo have given me.

spiceuser-marty61 · 2020-10-29T16:12:30.000Z

import-csv C:\Users\Downloads\FileFolderOwner.csv | 
ForEach-Object {
Get-ADUser -Filter "samaccountname -eq '$($_.owner)'" -Properties EmailAddress  
} | select SamAccountName,$($_.Name),EmailAddress | export-csv C:\Users\Downloads\file-out.csv

I am reading an Import file.

The first column has a header called Name, the second column has a header of Owner.

I am using the owner to get the active directory email address for all the rows in the csv. This is working and I am seeing it in my export file.

I would like to include the date from the name column of my import file into my export file it won’t work.

I get the following error

select : The value of a parameter was null; one of the following types was expected: {System.String,
System.Management.Automation.ScriptBlock}.
At line:4 char:5

} | select SamAccountName,$($_.Name),EmailAddress | export-csv C:\Users\mspeare\ …
CategoryInfo : InvalidArgument: ( [Select-Object], NotSupportedException
FullyQualifiedErrorId : DictionaryKeyUnknownType,Microsoft.PowerShell.Commands.SelectObjectCommand

If I remove $($_.Name) the script runs with no error.

spiceuser-lhb9l · 2020-10-29T16:17:06.000Z

its because you dont need the $() you only need that in the filter

mport-csv C:\Users\Downloads\FileFolderOwner.csv | 
ForEach-Object {
Get-ADUser -Filter "samaccountname -eq '$($_.owner)'" -Properties EmailAddress  
} | select SamAccountName,$_.Name,EmailAddress | export-csv C:\Users\Downloads\file-out.csv

spiceuser-lhb9l · 2020-10-29T16:21:54.000Z

if you are using samaccountname you also dont need the filter

import-csv C:\Users\Downloads\FileFolderOwner.csv | 
ForEach-Object {
Get-ADUser $_.owner -Properties EmailAddress  
} | select SamAccountName,$_.Name,EmailAddress | export-csv C:\Users\Downloads\file-out.csv

pauljones9002 · 2020-10-29T16:23:10.000Z

This has been commented to me many a times and On my iPhone 11 using the Spiceworks app you don’t have the option in the editor to insert code.
All you have is quote, tag, insert picture, and hyperlink.
Any ideas how you can insert code,
TIA

spiceuser-marty61 · 2020-10-29T16:47:55.000Z

import-csv C:\Users\Downloads\FileFolderOwner.csv | 
ForEach-Object {
Get-ADUser $_.owner -Properties EmailAddress 
} | select SamAccountName,$_.Name,EmailAddress | export-csv C:\Users\Downloads\file-out.csv

I am still getting the same error.

Neally · 2020-10-29T16:51:22.000Z

spiceuser-Marty61:

I am reading an Import file.

The first column has a header called Name, the second column has a header of Owner.

can you provide a sample of what it actually looks like (sanitized)?

Neally · 2020-10-29T16:52:55.000Z

Paul6790:

This has been commented to me many a times and On my iPhone 11 using the Spiceworks app you don’t have the option in the editor to insert code.
All you have is quote, tag, insert picture, and hyperlink.
Any ideas how you can insert code,
TIA

Open it in the browser on the phone and make it load the desktop version, rather than using the app.

@pauljones9002

spiceuser-marty61 · 2020-10-29T17:02:46.000Z

Here is a sample (sanitized) of my csv

FileFolderOwner.txt (369 Bytes)

Neally · 2020-10-29T17:19:01.000Z

e.g.

$csv = import-csv C:\Users\Downloads\FileFolderOwner.csv
$report=
foreach($row in $csv){
    $adinfo = $null
    $adinfo = try{get-aduser $row.owner -Properties emailaddress -ErrorAction Stop}catch{}
    
    if($adinfo){
        [pscustomobject]@{
            SamAccountName    = $adinfo.samaccountname
            FileName          = $row.name
            Owner             = $row.Owner
            OwnerEmailAddress = $adinfo.emailaddress
        }
    }
    else{
        [pscustomobject]@{
            SamAccountName    = 'Owner not found in AD'
            FileName          = $row.name
            Owner             = $row.Owner
            OwnerEmailAddress = ''
        }
    }
}
$Report | export-csv "report.csv" -notypeinformation

SamAccountName        FileName      Owner  OwnerEmailAddress
--------------        --------      -----  -----------------
DDD123                2-12-2020.pdf DDD123 DDD123@domain.com
Owner not found in AD 2-18-2020.pdf DDD124                  
Owner not found in AD 2-25-2020.pdf DDD125                  
DDD126                3-11-2020.pdf DDD126 DDD126@domain.com
Owner not found in AD 3-4-2020.pdf  DDD127