How to get Folder stats to a csv file for a specific year (like 2022)

Question

This script runs fine but I don't know how to add something like to get just 2022 last edited files only like {where LastWriteTime -eq 2022}

$arr = @()
gci 'C:\Users\myusername\Documents\' -recurse  | ? {$_.PSIsContainer -eq $False} | % {
  $obj = New-Object PSObject
  $obj | Add-Member NoteProperty Directory $_.DirectoryName
  $obj | Add-Member NoteProperty Name $_.Name
  $obj | Add-Member NoteProperty Length $_.Length
  $obj | Add-Member NoteProperty CreationTime $_.CreationTime
  $obj | Add-Member NoteProperty Access $_.LastAccessTime
  $obj | Add-Member NoteProperty Owner ((Get-ACL $_.FullName).Owner)
  $arr += $obj
  }
  $arr | Export-CSV -notypeinformation "C:\Users\myusername\Downloads\report.csv"

I assume you meant "how to get the files stats" instead of folders because of `? {$_.PSIsContainer -eq $False}` ? — Santiago Squarzon, Oct 15 '22 at 02:08

Santiago Squarzon · Accepted Answer · 2022-10-15T02:01:04.707

LastWriteTime is a DateTime instance, hence you can simply check the Year property and compare against it. As for your code, 3 recommendations:

Use -File or -Directory when needing to filter by any of them.
Use PSCustomObject to instantiate your objects. It's easier and faster.
Avoid adding elements += to a fixed collection @(). You can take full advantage of the pipeline in this case, get the files one by one, process each object and output them to a file.

Get-ChildItem 'C:\Users\myusername\Documents\' -Recurse -File | ForEach-Object {
    if($_.LastWriteTime.Year -eq 2022) {
        [pscustomobject]@{
            Directory    = $_.DirectoryName
            Name         = $_.Name
            Length       = $_.Length
            CreationTime = $_.CreationTime
            Access       = $_.LastAccessTime
            Owner        = (Get-ACL $_.FullName).Owner
        }
    }
} | Export-CSV "C:\Users\myusername\Downloads\report.csv" -NoTypeInformation

How do I get the original document Author( not the owner) into this script? i .e. Not Owner = (Get-ACL $_.FullName).Owner something like: Author = (Get-ACL $_.FullName).Authors — KD_Raj, Oct 15 '22 at 14:49
@KD_Raj there is no reference of the older owner of the in the ACL, if it was changed I dont think you can recover that information — Santiago Squarzon, Oct 15 '22 at 15:00

mklement0 · Answer 2 · 2022-10-15T02:24:17.350

Santiago's helpful answer contains an effective solution and explains the problems with your approach well.

Let me complement it with an alternative solution that uses the Where-Object cmdlet to perform the desired filtering first, and the Select-Object cmdlet with calculated properties to get the desired property names and values to pass to Export-Csv:

Get-ChildItem -File C:\Users\myusername\Documents -recurse  | 
  Where-Object { $_.LastWriteTime.Year -eq 2022 } |
  Select-Object @{ Name='Directory'; Expression = { $_.DirectoryName } },
                Name,
                Length,
                CreationTime,
                @{ Name='Access'; Expression = { $_.LastAccessTime } },
                @{ Name='Owner'; Expression = { (Get-ACL $_.FullName).Owner } } |
  Export-CSV -notypeinformation "C:\Users\myusername\Downloads\report.csv"

Thanks despite syntactical differences it seems to avoid using any object instantiation I think. Interesting. — KD_Raj, Oct 16 '22 at 15:01
@KD_Raj, in this case it is `Select-Object` that creates the `[pscustomobject]` output objects. That is, the specified properties become the properties of a newly constructed `[pscustomobject]`. — mklement0, Oct 16 '22 at 15:05

How to get Folder stats to a csv file for a specific year (like 2022)

2 Answers2