Get File Owner/Author

Question

I have the below script retrieving specific file types from the C: drive and outputting specific file properties to a delimited CSV file. I would like to be able to also retrieve the file owner and authors. Any help is very much appreciated.

# PowerShell script to list the .xlsx  files under the C Drive
$Dir = get-childitem "C:" -recurse -force
$List = $Dir | where {$_.extension -eq ".xlsx"}
$List |Select-Object fullname, LastAccessTime, LastWriteTime, CreationTime |Export-Csv -path C:\Scripts\xlsx.csv -NoTypeInformation

Answer 1

As soon as I posted this I was able to find a solution. I added @{N='Owner';E={$_.GetAccessControl().Owner}} to the select-object string. It now looks like this:

$List | Select-Object fullname, LastAccessTime, LastWriteTime, CreationTime, @{N='Owner';E={$_.GetAccessControl().Owner}} | Export-Csv -path C:\Scripts\xlsx.csv -NoTypeInformation