how can I find the most frequently changed files

[Dave Zygadlo]

I'm trying to find the files in my svn repo that have been have the most amount of change to them. I would like to find out most frequently changed as well as the most amount of lines of code changed.

[Dave Zygadlo · Accepted solution]

I found that I could run the following EyeQL

select revisions
from dir "/"
where ( path like "*.cs" and date in [2011-09-24T04:00:00.00Z, 2011-10-25T03:59:59.00Z])
order by date desc
group by file
return path, count(revisions),sum(linesAdded), sum(linesRemoved)