Having just gone through this exercise myself, this puppetdb sql query was extremely helpful in tracking down where the binary data was for me: https://github.com/puppetlabs/puppet/issues/9255#issuecomment-2854478183