<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Constantia;
panose-1:2 3 6 2 5 3 6 3 3 3;}
@font-face
{font-family:Georgia;
panose-1:2 4 5 2 5 4 5 2 3 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Hi everyone,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal"><a href="https://archivesspace.atlassian.net/browse/ANW-1386">https://archivesspace.atlassian.net/browse/ANW-1386</a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Bri McLaughlin, she/her/hers<o:p></o:p></p>
<p class="MsoNormal">Visiting Metadata Services Librarian<o:p></o:p></p>
<p class="MsoNormal">Indiana University <o:p></o:p></p>
<p class="MsoNormal">812-856-3321<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org>
<b>On Behalf Of </b>Corey Schmidt<br>
<b>Sent:</b> Monday, May 16, 2022 4:24 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> [External] Re: [Archivesspace_Users_Group] collection editing reports?<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="background:#FFECE5"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#82270D">This message was sent from a non-IU address. Please exercise caution when clicking links or opening attachments from external sources.<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black">Karen,<br>
<br>
If you're running ArchivesSpace 3.2.0, you may be able to use the <a href="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" 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://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" 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<o:p></o:p></span></p>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div id="Signature">
<div>
<div>
<p style="background:white"><b><span style="font-size:9.0pt;font-family:"Georgia",serif;color:black">Corey Schmidt</span></b><span style="font-size:9.0pt;font-family:"Georgia",serif;color:black">
<br>
Special Collections Libraries | <i>Project Management Librarian/Archivist</i><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:9.0pt;font-family:"Georgia",serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-size:9.0pt;font-family:"Georgia",serif;color:black"><a href="mailto:Corey.Schmidt@uga.edu">Corey.Schmidt@uga.edu</a><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="98%" align="center">
</div>
<div id="divRplyFwdMsg">
<p class="MsoNormal"><b><span style="color:black">From:</span></b><span style="color:black">
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
on behalf of Karen Urbec <<a href="mailto:karen.urbec@whoi.edu">karen.urbec@whoi.edu</a>><br>
<b>Sent:</b> Monday, May 16, 2022 10:34 AM<br>
<b>To:</b> <a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> [Archivesspace_Users_Group] collection editing reports?</span> <o:p>
</o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="color:#BA0C2F">[EXTERNAL SENDER - PROCEED CAUTIOUSLY]</span><o:p></o:p></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Hi Everyone,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">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? <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">thanks!<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Karen<o:p></o:p></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div id="x_Signature">
<div>
<div>
<p><span style="font-size:10.0pt;font-family:"Constantia",serif;color:black">Karen Urbec (she/her)</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Constantia",serif;color:black">Institution Archivist</span><span style="color:black">,
</span><span style="font-size:10.0pt;font-family:"Constantia",serif;color:black">MBLWHOI Library</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Constantia",serif;color:black">Woods Hole Oceanographic Institution</span><span style="font-size:10.0pt;font-family:"Constantia",serif;color:black"> </span><span style="color:black"><o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Constantia",serif;color:black">MS#8, phone:508-289-2269</span><span style="font-size:10.0pt;font-family:"Constantia",serif;color:black">
</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Constantia",serif;color:black"><a href="https://orcid.org/0000-0001-6673-4478">https://orcid.org/0000-0001-6673-4478</a>
</span><span style="color:black"><o:p></o:p></span></p>
<p><span style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>