On Tue, May 12, 2015 at 4:23 PM, George Stanley Kozak <g...@cornell.edu>
wrote:
> Is there a PostGreSQL query that can be run (DSpace 5.1) to find which
> items and/or bitstreams are controlled by which groups?
>
>
It's all in the resourcepolicy table.
So for bitstreams:
SELECT * FROM resourcepolicy WHERE resource_type_id = '0'
and for items (with item handle added):
SELECT handle.handle, resourcepolicy.*FROM resourcepolicy, handleWHERE
resourcepolicy.resource_type_id = '2'AND resourcepolicy.resource_id =
handle.resource_id
Regards,
~~helix84
Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
