Finding a node given the contentURL

[andrepra]

Hi,
I found in the content store on file system some big files. So I would know the name of the file and the author. There's any method using the node browser to find the corresponding node knowing the path on file system. I saw that the property contentUrl contains this path but I have some problem writing the correct lucene query. Can someone help me?
thanks
Andrea

[andrepra]

I find a solution: querying the database. If I query the table alf_node_properties filtering for string_value like '%<filename>%' I find the right node_id. After i can take a look to all the properties of that node_id.

Questions: The query, if the integrity is fine, must return always one record. Right? If the result is empty does it mean that the binary is dangling? I can remove it from filesystem?

Thanks
Andrea