Excellent point, Graham. How did you accomplish that using log parser?

It depends what you call duplicate -- I use the MD5 hashing algorithm to determine a value for the contents for each file then compare the hash and filesize (its always possible to have 2 very different files with the same hash value). Graham

How can I use log parser to find duplicate files?

Thanks for the help Danial. heres what I came up with to perform the task needed: ===AgedFileFinder.bat=== echo off for /F %%d in (AFFserverlist.txt) do aff %%d ======================== ==AFF.bat== echo now parsing %1 net use %1 dir /a:d /b %1 > dirlist.txt for /F %%d in (dirlist.txt) do logparser file...

That's a pretty good start! The older than thing can easily be done with the following WHERE clause: AND LastAcc That constructs a timestamp using only the year which defaults all the other fields to the earliest point so the timestamp would be 2000-01-01 00:00:00. Your FROM clause needs a little more...

Hi, Been trolling through the boards and KB for about 2 days now. Just getting an understanding on how to get LP to do what i need it to. I'm trying to run it so it looks at a remote computers, scans all directories on that server and reports files of a given type older then year 2000. Here is what I...

G'Day, Here is a sample of my SQL for looking for files based on a date. logparser "SELECT Path, Name, Size, attributes, lastwritetime FROM 'C:\*.*' WHERE Attributes NOT LIKE 'DA-------' AND (lastwritetime = SYSTEM_DATE()) ORDER BY SIZE DESC" -i:FS -o:TPL -tpl:mytemplate.tpl -e:10 Came up blank...

G'Day, The query looks good to have all the file types listed . The real thing I would like from the situtation mentioned is to examine how big the backups have occurred over time in an appended log file. Sorting by file types is a good start but how do I search files based on a given date/time?? Also...

As to your specific question, there isn't a way to collectively parse all shares on a machine with Log Parser, whether hidden or visible. The best you could hope to do is make a list of paths to search, e.g. FROM \\myserver\c$, \\myserver\d$, \\myserver\e$

G'Day, What I found out with LogParser that it is easier to use the "map to drive" command assuming you have proper authority to do so. @ECHO OFF net use Z: \\server\directory <insert LogParser command here> net use Z: /DELETE then use LogParser to access to the drive letter. As in a batch file...