Did you know that you can search for files in CMPivot?
Did you also know that you can perform wildcard file searches with CMPivot?
An interesting post on the /r/SCCM subreddit sent me down the path of testing it out. I tested this in my lab running SCCM 1906.
It works great, just use an asterisk * to perform the wildcard.
Fast moving software is great!