Windows7 command prompt show number of objects as list from dir command

Question

I'm using Windows7, and I want to know the number of files (or objects) for comparison to objects in Amazon S3 buckets. I'm not interested in size, as the size can differ between file types.

I want to do this as a list from the command prompt (starting with dir) so that I can output this from several different computers to a spreadsheet so I can verify vs s3. This output out be dir>.txt where the info from dir would not only be date | time | type (directory or file) | filename | plus number of objects.

I have hundreds of folders on dozens of computers to access, so I'm looking for something 1) simple and 2) that doesn't require typing in the name of each folder individually 3) that will search recursively inside each folder and subfolder 4) that generates a list output. The dir command alone is 90% of the way there, it just lacks the number of files inside folders, which hopefully is an easy output to generate.

Please no linux or Powershell recommendations as they can't be applied.

Answer 1

You can use this command:

@echo off & cd "Filepath" & for /f "tokens=* delims=*" %a in ('dir /s /b') do (set "name=%~fa" & set "date=%~za" & set "type=%~xa" & echo %date% %type% %name% >>"Output.txt")

Here replace "Filepath" with the folder path and output.txt with the output text file. If you need to add more properties, ping me in comment. Run this from Cmd.

Answer 2

@echo off & title <nul & title ...\%~nx0

cd/d "%~dp0" && setlocal EnableDelayedExpansion
>nul del/q /f "%temp%\_output_.csv" .\output.csv 2>&1 

for /d /r %%I in (*)do for /f %%i in ('dir/b "%%~I"^|find/c /v ""
')do >>"%temp%\_output_.csv" echo\%%~tI,^<DIR^>,%%~nxI,%%~i,files 

<con: >nul move "%temp%\_output_.csv" .\output.csv 2>&1 & endlocal

---

Getting a listing of items folders, files, object totals, dates without a predefined layout... is not something that can be easy to achieve, especially when we don't know what is simple for those who ask.

You can try:

• For command-line:

---

@for /d /r %I in (*)do @for /f %i in ('dir/b "%~I\"^|find/c /v ""')do @echo\%~tI ^<DIR^> %~nxI %~i files

---

• For file bat/cmd

---

@echo off 

rem :: go to your destination folder
cd /d "%~dp0"&& setlocal EnableDelayedExpansion

rem :: remove any files from previous runs (if exist)
>nul del/q /f "%temp%\_output_.csv" .\output.csv 2>&1 

rem :: use a `for` loop to recursively folder and a second loop to
rem :: count your files in the current folder in the first `for` loop
for /d /r %%I in (*)do for /f %%i in ('dir/b "%%~I"^|find/c /v ""
')do >>"%temp%\_output_.csv" echo\%%~tI,^<DIR^>,%%~nxI,%%~i,files 


rem :: save the results to the temporary folder, then move to the current 
<con: >nul move "%temp%\_output_.csv" .\output.csv 2>&1 & endlocal

---

• Some options using substitution of for variable:

    %%~i   - expands %%i removing any surrounding quotes (")
    %%~fi  - expands %%i to a fully qualified path name only
    %%~ti  - expands %%i to date/time of file only
    %%~ni  - expands %%i to a file name only
    %%~xi  - expands %%i to a file extension only
    
    %%~nxi => expands %%~i to a file name and extension

---

• The option /d /r is undocumented, but can be a useful combination, while it will recurse through all subfolders the wildcard will only match against Folder/Directory names (not filenames).
  • Sources ss64.com | For /D

---

• Some further reading:

  [√] Cd

  [√] Echo

  [√] Move

  [√] Find

  [√] For

  [√] For /F

  [√] For /D /R

  [√] Redirection

  [√] Conditional Execution || && | ...

  [√] Enable/DisableDelayedExpansion | Enable/DisableExtensions