Today one of my collegue came to me and asked he knows the file name (content file name) and what to know where it resides in the site.
Here is the quick SQL query to find:
SELECT distinct [DirName] as FileOrContentLocation
,[LeafName] as FileOrContentName
where [LeafName] like ‘%abc%xyz%.xlsx’