Oh that's great, I will do the necessary modification then I will posted back for the benifit of everyone, or you can added in the sql report<div>Will be back to you soon</div><div>Thanks again<span></span><br><br>On Thursday, 21 July 2016, Michael Hafen <<a href="mailto:michael.hafen@washk12.org">michael.hafen@washk12.org</a>> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div>Ok, for the Guided Reports the SQL will be something like:<br><br>SELECT al.timestamp AS DateAndTime,b.surname,b.firstname,module,action FROM action_logs AS al LEFT JOIN borrowers AS b ON user = b.borrowernumber WHERE user <> 0 AND al.timestamp BETWEEN <span></span><span></span><span><<</span>Between <span>(</span>yyyy<span>-</span>mmd<span>-</span>dd<span>)</span><span>|</span>date<span>>></span> AND <<And (yyyy-nn-dd)|date>> ORDER BY b.surname,b.firstname,al.timestamp<br><br></div>You may want to adjust the order by with asc or desc qualifiers on the timestamp.<br><br></div>But this only works for periods where you have the logging enabled, and only for those modules that are enabled.  For example I don't see circulation when I run that SQL because I don't have logging enabled for that module.<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Jul 21, 2016 at 4:46 AM, rania azad mohammed <span dir="ltr"><<a href="javascript:_e(%7B%7D,'cvml','rania.azad@auis.edu.krd');" target="_blank">rania.azad@auis.edu.krd</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Oh I see,<div>Can you help me on building the SQL query since I don't have a lot of knowledge with SQL? simple report on librarian activities circulation,items and cataloguing with date and time will be perfect</div><div><br></div><div><br></div></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Jul 20, 2016 at 7:48 PM, Michael Hafen <span dir="ltr"><<a href="javascript:_e(%7B%7D,'cvml','michael.hafen@washk12.org');" target="_blank">michael.hafen@washk12.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">The action_logs table in the database could hold that information if you have turned on logging in the system preferences (<a href="http://translate.koha-community.org/manual/3.22/en/html-desktop/#logs" target="_blank">http://translate.koha-community.org/manual/3.22/en/html-desktop/#logs</a>).  There is a Log Viewer in Tools that may be useful for getting information from this table, or you can try building an SQL Report by hand.<br></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div>On Tue, Jul 19, 2016 at 11:45 PM, rania azad mohammed <span dir="ltr"><<a href="javascript:_e(%7B%7D,'cvml','rania.azad@auis.edu.krd');" target="_blank">rania.azad@auis.edu.krd</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div dir="ltr">Dear <div><br></div><div>We are 3 admins in the library working on shifts in the library, each of us log-in during her time. I want a report or log file to see all the activities of each admin during a specific day. is there such report or file? I tried to find it using the wiki but hopeless<span><font color="#888888"><br clear="all"><div><br></div>-- <br><div data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><p style="font-size:12.8px"><span style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(127,127,127)"><b>Regards,</b></span></p><p style="font-size:12.8px"><span style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(127,127,127)"><b><img height="29" width="420"><br></b></span></p><p style="font-size:12.8px"><span style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(127,127,127)"></span><span style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(127,127,127)" lang="EN-AU"><u></u><u></u></span></p><p><b style="font-size:12.8px"><span style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(0,64,128)" lang="FR">Rania Azad</span><span style="font-size:9pt;font-family:Calibri,sans-serif" lang="FR"><font color="#000080"> |</font></span></b><span style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(153,153,153)" lang="FR"> </span><span style="font-size:9pt;font-family:Calibri,sans-serif" lang="FR"><font color="#1f497d">Library Manager</font><br><font color="#1f497d">Library Department<br></font></span><font color="#1f497d" face="Calibri, sans-serif"><span style="font-size:12px"><a href="http://library.auis.edu.iq/" target="_blank">http://library.auis.edu.iq/</a><br></span></font><span style="font-size:9pt;font-family:Calibri,sans-serif"><font color="#004080">The American University of Iraq, Sulaimani<br></font></span><span style="font-size:9pt;font-family:Calibri,sans-serif;color:gray" lang="FR">Office:</span><b style="font-size:12.8px"><span style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(0,64,128)" lang="FR"> </span></b><b style="font-size:12.8px"><span style="font-size:9pt;font-family:Calibri,sans-serif" lang="FR"><font color="#1f497d">B-G-32<br></font></span></b><span style="font-size:9pt;font-family:Calibri,sans-serif;color:gray" lang="FR"> Ext<b> </b></span><b style="font-size:12.8px"><span style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)" lang="FR">1219</span></b></p><p style="font-size:12.8px"><br></p></div></div></div></div></div></div>
</font></span></div></div>
<br></div></div><span>_______________________________________________<br>
Koha-devel mailing list<br>
<a href="javascript:_e(%7B%7D,'cvml','Koha-devel@lists.koha-community.org');" target="_blank">Koha-devel@lists.koha-community.org</a><br>
<a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" rel="noreferrer" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>
website : <a href="http://www.koha-community.org/" rel="noreferrer" target="_blank">http://www.koha-community.org/</a><br>
git : <a href="http://git.koha-community.org/" rel="noreferrer" target="_blank">http://git.koha-community.org/</a><br>
bugs : <a href="http://bugs.koha-community.org/" rel="noreferrer" target="_blank">http://bugs.koha-community.org/</a><br></span></blockquote></div><span><font color="#888888"><br><br clear="all"><br>-- <br><div data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div>Michael Hafen<br></div>Washington County School District Technology Department<br></div>Systems Analyst<br><br></div></div></div></div>
</font></span></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><p style="font-size:12.8px"><span style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(127,127,127)"><b>Regards,</b></span></p><p style="font-size:12.8px"><span style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(127,127,127)"><b><img height="29" width="420"><br></b></span></p><p style="font-size:12.8px"><span style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(127,127,127)"></span><span style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(127,127,127)" lang="EN-AU"><u></u><u></u></span></p><p><b style="font-size:12.8px"><span style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(0,64,128)" lang="FR">Rania Azad</span><span style="font-size:9pt;font-family:Calibri,sans-serif" lang="FR"><font color="#000080"> |</font></span></b><span style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(153,153,153)" lang="FR"> </span><span style="font-size:9pt;font-family:Calibri,sans-serif" lang="FR"><font color="#1f497d">Library Manager</font><br><font color="#1f497d">Library Department<br></font></span><font color="#1f497d" face="Calibri, sans-serif"><span style="font-size:12px"><a href="http://library.auis.edu.iq/" target="_blank">http://library.auis.edu.iq/</a><br></span></font><span style="font-size:9pt;font-family:Calibri,sans-serif"><font color="#004080">The American University of Iraq, Sulaimani<br></font></span><span style="font-size:9pt;font-family:Calibri,sans-serif;color:gray" lang="FR">Office:</span><b style="font-size:12.8px"><span style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(0,64,128)" lang="FR"> </span></b><b style="font-size:12.8px"><span style="font-size:9pt;font-family:Calibri,sans-serif" lang="FR"><font color="#1f497d">B-G-32<br></font></span></b><span style="font-size:9pt;font-family:Calibri,sans-serif;color:gray" lang="FR"> Ext<b> </b></span><b style="font-size:12.8px"><span style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)" lang="FR">1219</span></b></p><p style="font-size:12.8px"><br></p></div></div></div></div></div></div>
</div>
</div></div></blockquote></div><br><br clear="all"><br>-- <br><div data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div>Michael Hafen<br></div>Washington County School District Technology Department<br></div>Systems Analyst<br><br></div></div></div></div>
</div>
</blockquote></div><br><br>-- <br><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><p style="font-size:12.8px"><span style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(127,127,127)"><b>Regards,</b></span></p><p style="font-size:12.8px"><span style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(127,127,127)"><b><img src="https://docs.google.com/uc?export=download&id=0B9FRV5t6zNZQbFpIbnl6ZnFBck0&revid=0B9FRV5t6zNZQZ2E5TXozYU1qRzUxcGdEbUxMa1EremN2b0tRPQ" width="420" height="29"><br></b></span></p><p style="font-size:12.8px"><span style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(127,127,127)"></span><span lang="EN-AU" style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(127,127,127)"><u></u><u></u></span></p><p><b style="font-size:12.8px"><span lang="FR" style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(0,64,128)">Rania Azad</span><span lang="FR" style="font-size:9pt;font-family:Calibri,sans-serif"><font color="#000080"> |</font></span></b><span lang="FR" style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(153,153,153)"> </span><span lang="FR" style="font-size:9pt;font-family:Calibri,sans-serif"><font color="#1f497d">Library Manager</font><br><font color="#1f497d">Library Department<br></font></span><font color="#1f497d" face="Calibri, sans-serif"><span style="font-size:12px"><a href="http://library.auis.edu.iq/" target="_blank">http://library.auis.edu.iq/</a><br></span></font><span style="font-size:9pt;font-family:Calibri,sans-serif"><font color="#004080">The American University of Iraq, Sulaimani<br></font></span><span lang="FR" style="font-size:9pt;font-family:Calibri,sans-serif;color:gray">Office:</span><b style="font-size:12.8px"><span lang="FR" style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(0,64,128)"> </span></b><b style="font-size:12.8px"><span lang="FR" style="font-size:9pt;font-family:Calibri,sans-serif"><font color="#1f497d">B-G-32<br></font></span></b><span lang="FR" style="font-size:9pt;font-family:Calibri,sans-serif;color:gray"> Ext<b> </b></span><b style="font-size:12.8px"><span lang="FR" style="font-size:9pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">1219</span></b></p><p style="font-size:12.8px"><br></p></div></div></div></div></div><br>