DosTips.com

Code: Select all

@ECHO OFF
@ECHO OFF
SETLOCAL
SET "sourcedir=\\FS01.winmain.local\main\InternalAudit\3. SOX\SOX 2021\2021 ITGC SOX\2. Final Fieldwork\Year-End Testing\YE.ITGC.04 - New Hires\Evidence\Application Userlists\Application Userlists - Year End"
rem Source directory of application files
SET "destdir=C:\Users\tpiccirillo\Desktop\Termination Scanner Output files"
rem Destination directory where report will go
for /f "delims=" %%a in ('dir /s /b "%sourcedir%\*.*"') do (
  echo(===== file %%~nxa ===== FINDSTR /N /g:"C:\Users\tpiccirillo\Documents\Senior IT Auditor\2022 Goals\Termination Scanner Process\Batch Script Version\searchlist.txt" "%%~fa") >> "%destdir%\results.csv"
  rem pnxa = path name and extension 
GOTO :EOF

Code: Select all

@echo off &setlocal

set "sourcedir=\\FS01.winmain.local\main\InternalAudit\3. SOX\SOX 2021\2021 ITGC SOX\2. Final Fieldwork\Year-End Testing\YE.ITGC.04 - New Hires\Evidence\Application Userlists\Application Userlists - Year End"
set "destdir=%userprofile%\Desktop\Termination Scanner Output files"
set "listfile=%userprofile%\Documents\Senior IT Auditor\2022 Goals\Termination Scanner Process\Batch Script Version\searchlist.txt"

:: make sure they are all absolute paths
for %%i in ("%sourcedir%\.") do set "sourcedir=%%~fi"
for %%i in ("%destdir%\.") do set "destdir=%%~fi"
for %%i in ("%listfile%") do set "listfile=%%~fi"

:: get the list separator for CSV data from your registry
for /f "tokens=3" %%i in ('reg query "HKCU\Control Panel\International" /v "sList"') do set "listSeparator=%%i"

:: update the current directory (this makes FINDSTR return relative paths to ensure they don't contain a colon)
pushd "%sourcedir%"

REM redirect the stdout to the CSV file
>"%destdir%\results.csv" (
  REM read name by name in the list (NOTE: lines in the list must not contain trailing spaces!)
  for /f "usebackq tokens=*" %%i in ("%listfile%") do (
    REM recursively (/s) search the whole name incl. space (/c) in all files ("*.*"),
    REM use regex (/r) where "\<" and "\>" are for "word boundary" to ensure we
    REM  don't match something like "John Doeskin" while looking for "John Doe"
    for /f "delims=" %%j in ('findstr /src:"\<%%i\>" "*.*"') do (
      REM we get something like "[file name]:[whole line containing the name]" and thus, we have to cut off the colon and the rest of the output
      for /f "delims=:" %%k in ("%%~j") do echo "%sourcedir%\%%k"%listSeparator%"%%i"
    )
  )
)

popd

pause