<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
Karen,<br>
<br>
If you're running ArchivesSpace 3.2.0, you may be able to use the <a href="https://archivesspace.atlassian.net/wiki/spaces/ArchivesSpaceUserManual/pages/2914877469/Creating+Managing+and+Running+Custom+Reports" title="https://archivesspace.atlassian.net/wiki/spaces/ArchivesSpaceUserManual/pages/2914877469/Creating+Managing+and+Running+Custom+Reports">
custom reports feature</a> to get this info from the <a href="https://archivesspace.atlassian.net/wiki/spaces/ArchivesSpaceUserManual/pages/2919464961/Choosing+a+Custom+Report+as+of+ArchivesSpace+v3.2#ChoosingaCustomReport(asofArchivesSpacev3.2)-CustomArchivalObjectsReport" title="https://archivesspace.atlassian.net/wiki/spaces/ArchivesSpaceUserManual/pages/2919464961/Choosing+a+Custom+Report+as+of+ArchivesSpace+v3.2#ChoosingaCustomReport(asofArchivesSpacev3.2)-CustomArchivalObjectsReport">
archival objects table</a>, 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.<br>
<br>
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.<br>
<br>
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.
<br>
<br>
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.<br>
<br>
Corey<br>
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
</div>
<div></div>
<div>
<p style="font:12px 'Georgia','Times','sans-serif'"><span style="font-weight:900">Corey Schmidt</span>
<br>
<span>Special Collections Libraries | <span style="font-style:italic">Project Management Librarian/Archivist</span></span></p>
<p style="font:12px 'Georgia','Times','sans-serif'"><span><span style="font-style:italic"><br>
</span></span></p>
<p style="font:12px 'Georgia','Times','sans-serif'"><span><a href="mailto:Corey.Schmidt@uga.edu">Corey.Schmidt@uga.edu</a><br>
</span></p>
</div>
</div>
</div>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Karen Urbec
<karen.urbec@whoi.edu><br>
<b>Sent:</b> Monday, May 16, 2022 10:34 AM<br>
<b>To:</b> archivesspace_users_group@lyralists.lyrasis.org <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> [Archivesspace_Users_Group] collection editing reports?</font>
<div> </div>
</div>
<style type="text/css" style="display:none">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
<div dir="ltr"><font color="BA0C2F">[EXTERNAL SENDER - PROCEED CAUTIOUSLY]</font><br>
<br>
<div>
<div class="x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Hi Everyone,</div>
<div class="x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
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?
<br>
</div>
<div class="x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
thanks!</div>
<div class="x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Karen<br>
</div>
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div id="x_Signature">
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
<span style="font-size:10pt; font-family:Constantia,"Hoefler Text",serif; color:black">Karen Urbec (she/her)</span><span style="font-size:10.0pt; font-family:"Courier New"; color:black"><span style="font-family:Constantia,"Hoefler Text",serif"></span></span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
<span style="font-size:10pt; font-family:Constantia,"Hoefler Text",serif; color:black">Institution Archivist</span>,
<span style="font-size:10pt; font-family:Constantia,"Hoefler Text",serif; color:black">
MBLWHOI Library</span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
<span style="font-size:10pt; font-family:Constantia,"Hoefler Text",serif; color:black">Woods Hole Oceanographic Institution</span><span style="font-size:10.0pt; font-family:"Courier New"; color:black"><span style="font-family:Constantia,"Hoefler Text",serif"> </span></span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
<span style="font-size:10pt; font-family:Constantia,"Hoefler Text",serif; color:black">MS#8, phone:508-289-2269</span><span style="font-size:10.0pt; font-family:"Courier New"; color:black"><span style="font-family:Constantia,"Hoefler Text",serif">
<br>
</span></span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
<span style="font-size:10.0pt; font-family:"Courier New"; color:black"><span style="font-family:Constantia,"Hoefler Text",serif"><span dir="ltr">https://orcid.org/</span>0000-0001-6673-4478
<br>
</span></span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
</p>
<br>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>