Custom Query Intermittent Results

We have created a custom query to allow us to find specific file names and path on any system within our tenant.

SELECT file, path FROM sophos_file_journal WHERE file LIKE '$$Filename$$';

This is very temperamental, as it will sometimes return a result after a search and then another time not. The file still exists on the system in the same path.

Has anyone ever experienced something like this with Live Discover?

Thanks!