Get hash from files/folders and subfolders into one csv file

Question

Get hash from files/folders and subfolders into one csv file

Ed7 96

Hello,

I know that with powershell we can get the hash (MD5, etc) from files/folders and subfolders. I was able to do it with to get one single folder and its content.

I would like to know/get a script or having help how to write a script that gets the hash from several files/folders finto only one csv file instead of having multiple csv files from each folders.

I am struggling with this and any support would be much appreciatted.

Thank you

Accepted answer

2 additional answers

Your answer

Answer 1

Clément BETACORNE 2,496

Hello,

This should do the job :

Get-Childitem -path "<folder1>","<folder2>","<folder3>" -recurse | Get-FileHash | Export-csv -path "<myfile>" -Delimiter ";" -NoTypeInformation

Be careful with where you will put <myfile> because it will throw you an error if the file is located in folder1, folder2 or folder3.
I didn't include error handling

Regards,

Answer 2

Jose Antonio Silva 11

@Ed7 - another option for your relative path challenge:

param (  
     $folders = @("C:\temp_fotos\", "C:\fotos_temp\") #case sensitive  
 )  
   
 $allFiles = foreach($folder in $folders) {  
     Get-Childitem -path $folder -recurse |  
        select FullName,Name,Length |   
        foreach {  
            $hash = Get-FileHash $_.FullName   
            add-member -InputObject $_ -NotePropertyName Hash -NotePropertyValue $hash.Hash  
            add-member -InputObject $_ -NotePropertyName RelativePath -NotePropertyValue $_.FullName.Replace($folder, '') -PassThru        
        }  
 }  
  
 $allFiles | select -First 10 | ft RelativePath, Hash

Ashutosh Kumar 1 Reputation point

2022-07-21T07:52:26.407+00:00

@Clément BETACORNE :Thanks its worked for me as well.....!! Could you also provide the commad to get hash value output to csv file with date & time stamp
Jose Antonio Silva 11 Reputation points

2022-07-21T15:44:51.39+00:00
In line 7 above, just add any other System.IO.DirectoryInfo property. e.g.

select FullName,Name,Length,CreationTime,LastWriteTime |

Answer 3

Ed7 96

Hello,

Thank you for this.

It seems working as expected, however, all the information is whithin the same column and I need to split in diferent collums.

Also I need to have a relative path so when comparing files copied from one server tro another to avoid any error with paths and focus on the files/folders.

How can I do that?

Apologises as I am new on this.

Thank you

Clément BETACORNE 2,496 Reputation points

2021-11-30T13:00:06.953+00:00

You can change the delimiter if you want by default I'm always using ";" but you can use ",".
Regarding the relative path you want to have only the parent of the file or the root folder ?

Regards,
Ed7 96 Reputation points

2021-11-30T16:44:30.08+00:00

I am going to check for several folders and its contents how can use the variable?
Such as this: $variabel1 = "<folder1>","<folder2>","<folder3>"
How can I have multiple folders to extract the content in one variable or do I have to have multiple variables?

I need to construct a relative path from the directory at the top of the tree...
For example, if the file in question lives at absolute path C:\Users\MyUsername\Desktop\test.txt, and I decide that the root directory is C:\Users\MyUsername, the relative path would be Desktop\test.txt, which is what should be stored in the CSV.

But I do not know how to write the script for that or what is missing

Share via

Get hash from files/folders and subfolders into one csv file

2 additional answers

Your answer