Get-ChildItem -Path 'd:\temp' -Recurse -Directory -Depth 3 | Yet, if you say you must, then maybe something like the below, of course change the calculation to whatever you choose for the size thing. (though I've have not needed to use it in years) I agree with Bill_Stuart on the WinDirStat deal. The file count and size for each folder and the sorting into columns is also not correct.Ĭan anyone with the knowledge of command based database creation help me? My question was put on hold because it wasn't detailed enough but i've now put in the maximum effort to explain everything i've tried and with over 2 petabytes of storage backups to spreadsheet from our Nearline storage I need to be able to do this quickly and efficiently. Click on replace and paste the folderpath. Click on Find and Select, scroll down to replace. So double click on one of the cells, select and copy the folder path. I have attempted to use the following code in powershell:Īfter running this, it appears to be bringing me a tad closer to what i'm looking for but i'm still not seeing the information i need as specified in my original excel screenshot at the top of this post:Īs you can see i'm lacking the proper directory path and all i see is instead, i also can't see the second level in the folder structure containing the sub-folders. We are going to remove the folder path using replace function in excel and we’ll have the filenames. cmd file but i don't know where to start.Īll i need is the first two folder levels in the hierarchy to go to csv:Īnd this is the data i need to export from the drive: I'm hoping there's an easy way to do what i need via some sort of. I have a hard drive full of backups that I need to detail on a spreadsheet quickly and in the following specific way.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |