Outputting directory info to a file in csv format

• 2012年6月4日 18:32

   

   
  

  0

  I am working on creating a report on a file structure so it can be opened in excel and analyzed.

  The folder structure is set up like this

  Share
      User
           Machine1
                File1, 2, 3, 4, 5..etc

          Machine 2
                File 1, 2, 3, 4, 5.. etc

      User
          Machine
               File 1,2,3,4,5 etc..

  Under each user folder there will be 1 to many machine folders, and under each machine folder there will be 0 to many files.  I would like to create a csv file that has the following:

  user,machine,filedate,filesize,file, pathtofile

  I have a script that does all of the heavy lifting - walks through the folders and files and gets the information I want - however - I cannot seem to get it to output the way I want it to.  I have tried Out-File, ConvertTo-Csv - but the only thing that seems to get me close is write-host and manually put commas in between each variable.  I am thinking that there has to be a better way to do that than to use write-host and >>

  Thanks

  sb

  # get all of the users folders
  $users = Get-ChildItem -Path $backuppath | Where-Object {$_.psIsContainer -eq $true}
  
  # loop through the users folders
  $users | ForEach-Object {
  	# get the machines
  	$user = $_;
  	$machines = Get-ChildItem -LiteralPath $backuppath\$user;
  	
  	$machines | ForEach-Object {
  		# loop through all of the machines for pst files
  		$machine = $_;
  		$pstfiles = Get-ChildItem -LiteralPath $backuppath\$user\$machine -Filter *.pst -Recurse  | Where-Object {$_.Name.ToUpper() -notlike 'MAILBOX' -and $_.psIsContainer -eq $false}
  	}
  	
  	$pstfiles | ForEach-Object {
  		 Write-Host $user.Name$machine.Name $_.name $_.lastwritetime$_.length$_.DirectoryName 
  	}
  
  }

  
  

  • 返信
  • 引用