Terry: Thank you. Once again, you have been a big help! George Kozak On Wed, Jan 17, 2018 at 6:43 PM Terry Brady <[email protected]> wrote:
> This query will get you started. It will find all items without and > anonymous read policy. > > select * from item > where not exists ( > select 1 > from resourcepolicy rp > where rp.resource_id = item_id > and rp.resource_type_id=2 > and epersongroup_id=0 > and action_id=0 > ) > > You will likely want to refine this query to look at the embargo start/end > dates present in the resourcepolicy table. > > epersongroup_id=0 is anonymous > action_id is READ action > > On Wed, Jan 17, 2018 at 1:35 PM, George Kozak <[email protected]> wrote: > >> Is there an easy way to find and list all of the collections in DSpace >> that have restricted items in them? I thought I could do it in SQL, but >> I'm having a hard time coming up with a query that gives me what I want. >> BTW: I am using DSpace 5.5. >> Thanks! >> -- >> *************************** >> George Kozak >> Digital Library Specialist >> Cornell University Library - IT >> 218 Olin Library >> Cornell University >> Ithaca, NY 14853 >> 607-255-8924 <(607)%20255-8924> >> [email protected] >> >> -- >> 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 [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at https://groups.google.com/group/dspace-tech. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Terry Brady > Applications Programmer Analyst > Georgetown University Library Information Technology > https://github.com/terrywbrady/info > 425-298-5498 (Seattle, WA) > -- *************************** George Kozak Digital Library Specialist Cornell University Library - IT 218 Olin Library Cornell University Ithaca, NY 14853 607-255-8924 [email protected] -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
