I am working on a script to get the FilePath, Filename and the created date displayed for any file which is in a Folder whose name is MRV. Let me explain in detail :
I have a Directory which has hundreds of folders and they have subfolders. One subfolder is named MRV in each folder. Now, I need to recursively go into each folder, look for MRV folder and DIR the filenames along with its Create date. I can have the output stored in a text file or in a SQL table. I tried to use the DOS command :
FOR /D %%a IN (C:\Test*) DO Dir /T:C /b /s %%a\MRV*.txt>>C:\List.txt
This gives me the complete paths for e.g as below:
What I am looking for is something like :
C:\Test\ABC\MRV\63399862\mrv-abc-oth.txt 16/02/2010 14:32 PM
Can you suggest any way how the same can be done using SQL ?