<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=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
        {font-family:Helvetica;
        panose-1:2 11 6 4 2 2 2 2 2 4;}
@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:Verdana;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:HelveticaNeue;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
span.EmailStyle17
        {mso-style-type:personal-reply;
        font-family:"Verdana",sans-serif;
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:72.0pt 72.0pt 72.0pt 72.0pt;}
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-AU" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">Hi All, I didn’t realize this didn’t get onto the list, but if anyone was interested, (and to make it searchable in the tech list archives….),
 this is the way I have done it over the years… as a starting point…<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#1F497D;mso-fareast-language:EN-US">select userid, actor, action, count(*)<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#1F497D;mso-fareast-language:EN-US">&nbsp; from history
<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#1F497D;mso-fareast-language:EN-US">&nbsp;where datasetid = 'eprint'<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#1F497D;mso-fareast-language:EN-US">&nbsp;&nbsp; and timestamp_year = 2017<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#1F497D;mso-fareast-language:EN-US">&nbsp;&nbsp; group by 1,2,3<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#1F497D;mso-fareast-language:EN-US">;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">Cheers<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">Matt.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif"> eprints-tech-bounces@ecs.soton.ac.uk [mailto:eprints-tech-bounces@ecs.soton.ac.uk]
<b>On Behalf Of </b>Karl Goetz via Eprints-tech<br>
<b>Sent:</b> Wednesday, 16 January 2019 9:22 AM<br>
<b>To:</b> eprints-tech@ecs.soton.ac.uk; Karl Goetz &lt;karl.goetz@utas.edu.au&gt;<br>
<b>Subject:</b> Re: [EP-tech] DB search for users who changed an eprint<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
<p class="MsoNormal">Hi again, <o:p></o:p></p>
<div>
<p class="MsoNormal">A quick email to thank Matt Brady for his help pointing me in the right direction; all reports were provided successfully.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<p class="MsoNormal">Karl.<o:p></o:p></p>
<div>
<p class="MsoNormal"><br>
<br>
<o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">On 15 Jan 2019, at 3:40 pm, Karl Goetz via Eprints-tech &lt;<a href="mailto:eprints-tech@ecs.soton.ac.uk">eprints-tech@ecs.soton.ac.uk</a>&gt; wrote:<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
<div>
<div>
<p class="MsoNormal">Hi, <o:p></o:p></p>
<div>
<p class="MsoNormal">I have been asked to find out the staff who deposited (and or edited) a number of eprints last year. So far I haven’t been able to find a query to ask<span style="font-family:HelveticaNeue">&nbsp;'user who deposited a file?’. I don't see a user
 specified in 'history', 'file' or 'documents' tables. 'history' has an 'actor' text field but it doesn't include the information i need. 'eprint' only includes the current revision.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:HelveticaNeue">Will I be able to query the information I need from within eprints DB or will I have to script up a query over the objects.xml files?</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:HelveticaNeue">Thanks,</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:HelveticaNeue">Karl.</span><o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif">--&nbsp;<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif">Karl Goetz, &nbsp;Senior Library Officer (Library Systems)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif">University of Tasmania,&nbsp;Private Bag&nbsp;25,&nbsp;Hobart 7001<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif">Available Tuesday, Wednesday, Thursday<o:p></o:p></span></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:10.0pt">
<span style="font-size:10.0pt;font-family:&quot;Calibri&quot;,sans-serif"><br>
<br>
University of Tasmania Electronic Communications Policy (December, 2014). <br>
This email is confidential, and is for the intended recipient only. Access, disclosure, copying, distribution, or reliance on any of it by anyone outside the intended recipient organisation is prohibited and may be a criminal offence. Please delete if obtained
 in error and email confirmation to the sender. The views expressed in this email are not necessarily the views of the University of Tasmania, unless clearly intended otherwise.
<o:p></o:p></span></p>
</div>
<p class="MsoNormal">*** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">
https://protect-au.mimecast.com/s/z4FiClxwAVHqgx8ZUGG96N?domain=mailman.ecs.soton.ac.uk</a><br>
*** Archive: <a href="https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C817733cdffd84f724be908d67b650661%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=BlQgmPOMkSWZ543r2Sv7CQpPNAl2pJEdpbsP1c1b57Y%3D&amp;reserved=0" originalSrc="http://www.eprints.org/tech.php/" shash="K2vQ7oEr32da+Ne+JMxU4X4oc1GmdxvZwhpFZOVYQdVIlgz4hPGl5JG/kDuwk+YT9lJDJq0/FbSjDjZ64RY8gyP53elM+zP87+HT22Lt87sAQaI0g5WA3cfXCdM6EUmn/S3UPTyxRXMtv+5Un14m4gmV3wt85AN8sW6+8oI3brc=">
https://protect-au.mimecast.com/s/YSXUCmOxBVhLEz3niOt6BX?domain=eprints.org</a><br>
*** EPrints community wiki: <a href="https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C817733cdffd84f724be908d67b650661%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=YEmV6Pbc6xKyokbnt2ta6ljv%2BKLUPw%2BsZSn9MYLjLMU%3D&amp;reserved=0" originalSrc="http://wiki.eprints.org/" shash="Qs0MckryaMK0Xg6DWFjuK3wfTxPIGwyjK3M+uq+lyxIo04f7fDy5cDP8Ma5znnmxnR5vRlITXaRPAF1dieALKwSrSHDNn3rds/plE9Q4l9qGRgQLiTl7Owpu3Hif66zyRQo6DwHCPSP5gqZnHidceMsYoM77EtIy/O8oBjz7ev4=">
https://protect-au.mimecast.com/s/fjqXCnxyDVHpMv2oiNg-2o?domain=wiki.eprints.org</a><br>
*** EPrints developers Forum: <a href="https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fforum.eprints.org%2F&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C817733cdffd84f724be908d67b650661%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=gQ66oXgpZ1NJkrcfsnAkn%2FgcVpSdcam5ZOJ9eKlUcls%3D&amp;reserved=0" originalSrc="http://forum.eprints.org/" shash="mrxBUZoQvtD+6bZD9Cv581vWy5ZfCAaBP7/R7aKIavx5I1igRFm10xAVm4ZNPUWz8jR1pPrOktRrfkop+/8ncvCZTJdUOT+6oEWa08Y+HTjCTY3YqKLDLeLFaZW5k+PX5us5fgk2Xn+XKsqXkgVeXSiSdb0z3DgfDSUzL/7yuu4=">
https://protect-au.mimecast.com/s/nmh5CoVzE9HpxERzi6YDJB?domain=forum.eprints.org</a><o:p></o:p></p>
</div>
</blockquote>
</div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif;color:black">--&nbsp;<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif;color:black">Karl Goetz, &nbsp;Senior Library Officer (Library Systems)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif;color:black">University of Tasmania,&nbsp;Private Bag&nbsp;25,&nbsp;Hobart 7001<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:&quot;Helvetica&quot;,sans-serif;color:black">Available Tuesday, Wednesday, Thursday<o:p></o:p></span></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
</div>
<PRE>
_____________________________________________________________
This email (including any attached files) is confidential and is for the intended recipient(s) only. If you received this email by mistake, please, as a courtesy, tell the sender, then delete this email.

The views and opinions are the originator's and do not necessarily reflect those of the University of Southern Queensland. Although all reasonable precautions were taken to ensure that this email contained no viruses at the time it was sent we accept no liability for any losses arising from its receipt.

The University of Southern Queensland is a registered provider of education with the Australian Government.
(CRICOS Institution Code QLD 00244B / NSW 02225M, TEQSA PRV12081 )
</PRE></body>
</html>