Powershell find old files and insert them on excel

Try..

GCI '\\Server\Share' -Recurse | 
	?{$_.LastAccessTime -le (Get-date).AddMonths(-1)} | 
  Select FullName,CreationTime,LastAccessTime,LastWriteTime |
Export-Csv \\Server\Share\report.csv -NTI

Select allOpen in new window

Hi K
Output to CSV file and then CSV file can be opened in Excel

$pathtocheck = "\\share\folder"


$files = get-childitem $pathtocheck -Recurse

Foreach ($f in $files)

{

$access = $f | % {(get-date) – $_.LastAccessTime } 
if ($access.days -le 30) 
{ 

	$outputfilename = ( "c:\30dayReport.csv") 
	#$outputfilename 
	$f |format-table -property Fullname |out-file $outputfilename -append 

} 

Select allOpen in new window

will this report include the file names?

Hi Bcunney,

i tested the script and it failed

Subsun - your script works well, what does the GCI and -Nti mean?

Is gci same as dir?

Hi Subsun,

Below is my script so far

$pathname = Read-Host "Please Enter Path Name: "
GCI $pathname -Recurse | 
	?{$_.LastAccessTime -le (Get-date).AddMonths(-1)} | 
  Select FullName,CreationTime,LastAccessTime,LastWriteTime |
Export-Csv c:\TrainingDivisionReport.csv -NTI 

Select allOpen in new window

Now i need the last bit of the name to be last bit of the share. e.g \\fileandprint01\Shared\Information_Technology\IT Service 2007

so the csv name to c:\itservice2007.csv

how can i do this, thank your help :)

$pathname = Read-Host "Please Enter Path Name: "
GCI $pathname -Recurse | 
	?{$_.LastAccessTime -le (Get-date).AddMonths(-1)} | 
  Select FullName,CreationTime,LastAccessTime,LastWriteTime |
Export-Csv c:\TrainingDivisionReport.csv -NTI 

Select allOpen in new window

thank you very much!! this is fantastic!

what does the [-1] mean?

how do i know give the option to delete those files?

Thanks for the explanation.

I mean deleting the files