Will this query return ALL files modified today?

Question

I'm running SharePoint 2010 and SQL Server 2008 R2.

It's hugely important that I create a list of every file within a given content database that has been modified today, 10/31. Will this query do it or will it leave anything -anything at all- out?

SELECT [DirName], 
       [LeafeName], 
       [TimeLastModified] 
FROM   [WSS_Content_TARGETDB].[dbo].[AllDocs] 
WHERE  [TimeLastModified] BETWEEN '20121031' AND '20121101';

I'm crossing my fingers that this will list everything without any gaps.

Answer 1

NEVER READ DIRECTLY FROM THE DATABASES
(unless there is no other option)

This will probably work with the current patches it might, but it's not documented or guaranteed and even thought it might work now it might stop working if a patch is applied.

Have you consider using the change log which is meant exactly for getting things like this?
See Using the Change Log