Hi everyone, For what it's worth, I opened a ticket awhile back about having access to editorial provenance. Feel free to comment or vote if you think it would be helpful in your situation. https://archivesspace.atlassian.net/browse/ANW-1386
Thanks, Bri McLaughlin, she/her/hers Visiting Metadata Services Librarian Indiana University 812-856-3321 From: archivesspace_users_group-boun...@lyralists.lyrasis.org <archivesspace_users_group-boun...@lyralists.lyrasis.org> On Behalf Of Corey Schmidt Sent: Monday, May 16, 2022 4:24 PM To: Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org> Subject: [External] Re: [Archivesspace_Users_Group] collection editing reports? This message was sent from a non-IU address. Please exercise caution when clicking links or opening attachments from external sources. Karen, If you're running ArchivesSpace 3.2.0, you may be able to use the custom reports feature<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchivesspace.atlassian.net%2Fwiki%2Fspaces%2FArchivesSpaceUserManual%2Fpages%2F2914877469%2FCreating%2BManaging%2Band%2BRunning%2BCustom%2BReports&data=05%7C01%7Cbrijmcla%40iu.edu%7Ce6b39469f6974b4ba86d08da377a161d%7C1113be34aed14d00ab4bcdd02510be91%7C0%7C0%7C637883295449247555%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=wcq8ZkzS3jSiC9KFHVyVwXo94xXTEnvdVz7ZnPcUGdA%3D&reserved=0> to get this info from the archival objects table<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchivesspace.atlassian.net%2Fwiki%2Fspaces%2FArchivesSpaceUserManual%2Fpages%2F2919464961%2FChoosing%2Ba%2BCustom%2BReport%2Bas%2Bof%2BArchivesSpace%2Bv3.2%23ChoosingaCustomReport(asofArchivesSpacev3.2)-CustomArchivalObjectsReport&data=05%7C01%7Cbrijmcla%40iu.edu%7Ce6b39469f6974b4ba86d08da377a161d%7C1113be34aed14d00ab4bcdd02510be91%7C0%7C0%7C637883295449247555%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=BbcB3UIL4rKbdSA3vXse2zWFPTRmTzKVr%2BKV4qreZpw%3D&reserved=0>, but someone else here might be able to confirm this as I haven't use it much myself. Attached links go to the Help Center. If you're not on 3.2.0, you could get that info by querying the SQL database, searching specifically in the archival_object table looking at the fields: last_modified_by and system_mtime, sorting those by system_mtime to see the most recent changes. The tricky bit is capturing ALL the archival objects (series, items, files, etc.) for that specific collection. Since you want to capture not just the top-level children (series), but all the items within those series recursively down, that means you have to build your query to look for archival objects whose parents and grandparents and up and up eventually link to that specific collection. In this case, you would be looking at the parent_id (the ASpace ID of the parent of the item you're looking at) and the root_record_id (the ID of the collection that ArchivesSpace assigned it, aka the end # of the URI repositories/2/resources/{root_record_id} fields. I know I've come across this issue before, but I can't remember if I've built a query that can do this. Let me know if this is something you want to pursue and I can dig around to see if I have something. Corey Corey Schmidt Special Collections Libraries | Project Management Librarian/Archivist corey.schm...@uga.edu<mailto:corey.schm...@uga.edu> ________________________________ From: archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org> <archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>> on behalf of Karen Urbec <karen.ur...@whoi.edu<mailto:karen.ur...@whoi.edu>> Sent: Monday, May 16, 2022 10:34 AM To: archivesspace_users_group@lyralists.lyrasis.org<mailto:archivesspace_users_group@lyralists.lyrasis.org> <archivesspace_users_group@lyralists.lyrasis.org<mailto:archivesspace_users_group@lyralists.lyrasis.org>> Subject: [Archivesspace_Users_Group] collection editing reports? [EXTERNAL SENDER - PROCEED CAUTIOUSLY] Hi Everyone, I have a question about running edit reports in ArchivesSpace. What I mean is, when looking at a large collection (with many series and items), is there a report I can run to see which items were last edited, and when, and by whom? thanks! Karen Karen Urbec (she/her) Institution Archivist, MBLWHOI Library Woods Hole Oceanographic Institution MS#8, phone:508-289-2269 https://orcid.org/0000-0001-6673-4478
_______________________________________________ Archivesspace_Users_Group mailing list Archivesspace_Users_Group@lyralists.lyrasis.org http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
