Hi! You can check on this post posted by a fellow Filipino librarian and also answered by the same http://koha.1045719.n5.nabble.com/REport-that-displays-the-bib-record-with-i.... Copy/pasted the reports for you (with some modification on the original post), here are the reports: Reports of All Catalog Actions within a certain date based on Surname and First Name SELECT b.title , b.author , i.itemnumber, i.itemcallnumber , i.barcode , l.action_id, l.user, l.module, l.action, l.object, l.info , br.borrowernumber FROM items i LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) LEFT JOIN action_logs l ON (b.biblionumber=l.object) LEFT JOIN borrowers br on (l.user=br.borrowernumber) WHERE br.surname = <<Enter Surname>> AND br.firstname = <<Enter Firstname>> AND date(i.timestamp) BETWEEN <<Between (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> Reports of Added Catalog within a certain date based on Surname and First Name SELECT b.title , b.author , i.itemnumber, i.itemcallnumber , i.barcode , l.action_id, l.user, l.module, l.action, l.object, l.info , br.borrowernumber FROM items i LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) LEFT JOIN action_logs l ON (b.biblionumber=l.object) LEFT JOIN borrowers br on (l.user=br.borrowernumber) WHERE br.surname = <<Enter Surname>> AND br.firstname = <<Enter Firstname>> AND date(i.timestamp) BETWEEN <<Between (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> AND action='ADD' Reports of Modified/Edited Catalog within a certain date based on Surname and First Name SELECT b.title , b.author , i.itemnumber, i.itemcallnumber , i.barcode , l.action_id, l.user, l.module, l.action, l.object, l.info , br.borrowernumber FROM items i LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) LEFT JOIN action_logs l ON (b.biblionumber=l.object) LEFT JOIN borrowers br on (l.user=br.borrowernumber) WHERE br.surname = <<Enter Surname>> AND br.firstname = <<Enter Firstname>> AND date(i.timestamp) BETWEEN <<Between (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> AND action='MODIFY' Reports of All Catalog Actions within a certain date based on ID number SELECT b.title , b.author , i.itemnumber, i.itemcallnumber , i.barcode , l.action_id, l.user, l.module, l.action, l.object, l.info , br.borrowernumber, br.cardnumber FROM items i LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) LEFT JOIN action_logs l ON (b.biblionumber=l.object) LEFT JOIN borrowers br on (l.user=br.borrowernumber) WHERE br.cardnumber = <<Enter ID number>> AND date(i.timestamp) BETWEEN <<Between (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> Reports of All Added Catalog Actions within a certain date based on ID number SELECT b.title , b.author , i.itemnumber, i.itemcallnumber , i.barcode , l.action_id, l.user, l.module, l.action, l.object, l.info , br.borrowernumber, br.cardnumber FROM items i LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) LEFT JOIN action_logs l ON (b.biblionumber=l.object) LEFT JOIN borrowers br on (l.user=br.borrowernumber) WHERE br.cardnumber = <<Enter ID number>> AND date(i.timestamp) BETWEEN <<Between (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> AND action='ADD' Hope this helps. -- View this message in context: http://koha.1045719.n5.nabble.com/Staff-activity-report-tp5906107p5906146.ht... Sent from the Koha-general mailing list archive at Nabble.com.