Query for harvested items

[euler]

Hi Everyone,

I am working on a repository (DSpace 6.3) that harvests from 2 different dspace repositories. I would like to ask if how can I query using either solr or sql the number of harvested items for each oai provider. It would also be nice if I can set the date range eg the number of items harvested monthly from oai server1 from January 1, 2019 to August 31, 2019. By the way, the harvesting server is only harvesting metadata and references to bitstreams.

Thanks in advance!

euler

[euler]

Need help anyone? I'm pretty sure I'm not the only who would like to know this kind of statistics and I'm also sure that a lot of repositories out there that have some of their contents harvested from other OAI content providers.

Thanks in advance.

[José Geraldo]

Hi,

You can use the tables harvested_collection and harvested_item, group by the column last_harvested.

https://wiki.duraspace.org/display/DSDOC6x/Storage+Layer?preview=/68069687/78157937/dspace6.png  

--
All messages to this mailing list should adhere to the DuraSpace Code of Conduct: https://duraspace.org/about/policies/code-of-conduct/
---
You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/e4f2cfc2-f82e-42cc-b227-74ce8c9d4334%40googlegroups.com.

--

At.te,

José Geraldo