{"id":15,"date":"2006-12-15T04:00:00","date_gmt":"2006-12-15T12:00:00","guid":{"rendered":"http:\/\/testblog.sapien.com\/index.php\/2006\/12\/15\/more-fun-with-file-aging\/"},"modified":"2006-12-15T04:00:00","modified_gmt":"2006-12-15T12:00:00","slug":"more-fun-with-file-aging","status":"publish","type":"post","link":"https:\/\/dev.sapien.com\/blog\/2006\/12\/15\/more-fun-with-file-aging\/","title":{"rendered":"More Fun with File Aging"},"content":{"rendered":"

A few days ago, I posted an entry <\/a>on how to run a file aging report using PowerShell. The script as written was pretty and all, but a little limiting. You really can’t do anything with the results. In many regards it is a VBScript rewritten for PowerShell (not that there’s anything wrong with that). But PowerShell can do so much more, especially when you think about piping objects between cmdlets. The original script just produces string output so you can’t do much else with it. What the script needs is a way to produce an object that can then be used by other PowerShell cmdlets. Thus was born FileAging2.ps1.  I’ve attached the file as a text file so you don’t have to copy and paste from the blog entry.<\/p>\n

The script is essentially the same as before. (I did update my formatting expressions per Jeffrey Snover’s suggestion about using 1MB instead of 1048576)<\/p>\n

# FileAging2.ps1<\/span>
# Jeffery Hicks SAPIEN Technologies, Inc.<\/span>
# jhicks@sapien.com<\/span>
# http:\/\/www.SAPIEN.com  http:\/\/www.ScriptingAnswers.com<\/span>
# http:\/\/sapien.eponym.com\/blog<\/span>

# This script developed and tested with PowerShell RTM<\/span>

# !! TEST IN A NON-PRODUCTION ENVIRONMENT !!<\/span>

Param($dir)<\/span>
if ($dir -isnot [string]) {<\/span>
Write-Host “ERROR: You must specify a directory path!” `<\/span>
-foregroundcolor “RED” -backgroundcolor “Black”;`<\/span>
return<\/span>
}<\/span>

$now=Get-Date<\/span>
$files=Get-ChildItem -path $dir -recurse | `<\/span>
where {($_.GetType()).name -eq “FileInfo”}<\/span>

clear-host<\/span>

#initialize<\/span>
$Total2yr=0<\/span>
$Total90=0 <\/span>
$Total1yr=0<\/span>
$Total30=0<\/span>
$Total7=0<\/span>
$TotalCurrent=0<\/span>
$2yrs=0<\/span>
$1yr=0<\/span>
$3mo=0<\/span>
$1mo=0<\/span>
$1wk=0<\/span>
$current=0<\/span>
$count=0<\/span>

#enumerate files and get information<\/span>
foreach ($file in $files) {<\/span>
  $age=($now.subtract(($file.LastWriteTime))).days<\/span>
  $count=$count+1<\/span>
  Write-Progress -Activity “File Aging Report” `<\/span>
  -status $file.DirectoryName -currentoperation $file.name <\/span>
  switch ($age) {<\/span>
    {$age -ge 730} {$2yrs=$2yrs+1;$Total2yr=$Total2Yr+$file.length;break}<\/span>
    {$age -ge 365} {$1yr=$1yr+1;$Total1yr=$Total1Yr+$file.length;break}<\/span>
    {$age -ge 90} {$3Mo=$3Mo+1;$Total90=$Total90+$file.length;break} <\/span>
    {$age -ge 30} {$1Mo=$1Mo+1;$Total30=$Total30+$file.length;break}<\/span>
    {$age -ge 7} {$1wk=$1wk+1;$Total7=$Total7+$file.length;break}<\/span>
    {$age -lt 7}  {$current=$current+1;$TotalCurrent=$TotalCurrent+`<\/span>
    $file.Length;break}<\/span>
  }<\/span>
}<\/span>

#format file size totals to MB<\/span>
$Total2yr=”{0:N2}” -f ($Total2yr\/1MB)<\/span>
$Total90=”{0:N2}” -f ($Total90\/1MB) <\/span>
$Total1yr=”{0:N2}” -f ($Total1yr\/1MB)<\/span>
$Total30=”{0:N2}” -f ($Total30\/1MB)<\/span>
$Total7=”{0:N2}” -f ($Total7\/1MB)<\/span>
$TotalCurrent=”{0:N2}” -f ($TotalCurrent\/1MB)<\/span>

#create new object to hold values<\/span>
$obj = New-Object System.Object<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name Age -value “2Yrs”<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name Count -value $2yrs<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name MB -value $Total2yr<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name DirPath -value $dir.ToString() <\/span>

Write-Output $obj<\/span>

$obj = New-Object System.Object<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name Age -value “1Yr”<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name Count -value $1yr<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name MB -value $Total1yr<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name DirPath -value $dir.ToString()<\/span>

Write-Output $obj<\/span>

$obj = New-Object System.Object<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name Age -value “3Mo”<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name Count -value $3mo<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name MB -value $Total90<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name DirPath -value $dir.ToString()<\/span>

Write-Output $obj<\/span>

$obj = New-Object System.Object<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name Age -value “1Mo”<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name Count -value $1mo<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name MB -value $Total30<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name DirPath -value $dir.ToString()<\/span>

Write-Output $obj<\/span>

$obj = New-Object System.Object<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name Age -value “1Wk”<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name Count -value $1wk<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name MB -value $Total7<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name DirPath -value $dir.ToString()<\/span>

Write-Output $obj<\/span>

$obj = New-Object System.Object<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name Age -value “Curr”<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name Count -value $current<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name MB -value $TotalCurrent<\/span>
Add-Member -inputobject $obj -membertype NoteProperty -Name DirPath -value $dir.ToString()<\/span>

Write-Output $obj<\/span>
#EOF<\/span><\/p>\n

The primary improvement to the script is using New-Object to create a generic .NET object and then calling Add-Member to populate the object with data. Write-Object sends the object data to PowerShell so it can present it. But that also means I have an object I can pipe to other cmdlets.<\/p>\n

Here’s a screen shot of what I get when I run a the command:<\/p>\n

.\\fileaging2.ps1 s:\\ | format-table -autosize<\/span><\/p>\n

<\/p>\n

Or I could do something like:
.\\fileaging2.ps1 s:\\ | export-csv “c:\\reports\\S-age.csv”<\/span><\/p>\n

and save the information to a csv file.<\/p>\n

I can even take this a step further and use PowerGadget<\/a>‘s out-chart cmdlet. I can run an expression like this:
.\\fileaging2.ps1 s:\\ | out-chart -values Count,MB -label Age -Title “File Aging Report: S:\\” -floating -AllSeries_PointLabels_Visible True<\/span>
 
and get something like this:
<\/p>\n

Or suppose I wanted a break down of files by age as a percentage of the total:
.\\fileaging2.ps1 s:\\out-chart -values Count -label Age -gallery pie -AllSeries_PointLabels_Visible True -galleryAttributes_LabelsInside -title “File Aging Report: S:\\ (by count)” -floating<\/span>
<\/p>\n

Once my script starts acting like an object, so many other possibilities present themselves. I’ve given up the string color coding that the original script had, but I believe “objectifying” the script more than covers the “loss.”<\/p>\n

[Thanks to the folks at PowerGadgets for helping me get on the right track]<\/p>\n","protected":false},"excerpt":{"rendered":"

A few days ago, I posted an entry on how to run a file aging report using PowerShell. The script as written was pretty and all, but a little limiting. You really can’t do anything with the results. In many regards it is a VBScript rewritten for PowerShell (not that there’s anything wrong with that). But PowerShell can do so much more, especially when you think about piping objects between cmdlets. The original script just produces string output so you can’t do much else with it. What the script needs is a way to produce an object that can then be used by other PowerShell cmdlets.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2,25],"tags":[],"class_list":["post-15","post","type-post","status-publish","format-standard","hentry","category-general","category-windows-powershell"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/15","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/comments?post=15"}],"version-history":[{"count":0,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/15\/revisions"}],"wp:attachment":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/media?parent=15"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/categories?post=15"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/tags?post=15"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}