I have tried to query my DB to find nodes that are unencrypted that are not in alf_content_url_encryption. Due to the large volume of data (in the millions) it has returned an error. I am looking to create a Java Backend to do this but am unsure on the approach.
Any Ideas?