but if I run the same query via fleet and it comes back with nothing? If I just query the path directly on the file table it finds the file so it's something specific about the
SELECT path FROM mdfind WHERE mdfind.query = "kMDItemFSName == '*.ovpn'"
table, any ideas? FWIW it seems to work on some computers that are using launcher but I am using orbit if that matters?
if I remove the wildcards it works fine on both:
select * from file where path like '/Users/%/Downloads/%.ovpn'
where path like '/Users/rhuddleston/Downloads/foo.ovpn'