Best method for finding items with more than one PDF

[Gary Browne]

Hi all,

Running DSpace 4.1 on RHEL 7, Tomcat 7, Apache 2.4.

A fairly specific question here, but an answer would give me some insight into how to best approach these sorts of requests generally.

So somebody wants a report, for whatever reason, of any items in DSpace that have more than one PDF file.

Sure it can be done with SQL, but generally I find this quite tedious. I was wondering if REST API or another route (Solr queries?) might be more straightforward. A secondary issue is that I am unable to query items/bitstreams from my REST API, even though I thought that this should be possible without authenticating.

Any advice or pointers much appreciated.

Thanks,
Gary