<div dir="ltr"><div>Hi all,</div><div><br></div><div>First of all, I want to express my appreciation for Elizabeth for convening the Reports Interest Group while I was out on maternity leave. She did an excellent job and I am so grateful! I'm happy to report she has agreed to assist with future meetings. If anyone else is interested in helping with meeting planning going forward, let me know!<br></div><div><br></div><div>Our first RIG meeting in 2024 will take place on January 31st. Elizabeth and I have settled on the topic of running SQL queries on the auditor tables. Tables in the auditor schema show updates that have occurred on other tables in the database, what user account performed the update, and at what workstations the update was performed. These schemas are not exposed to the reporter, so database access is necessary in order to use them. Not all database tables have an auditor table, but enough do that they can be quite useful for admins and support staff that are asked to look at when an update took place and by whom. In our consortium, we've used them to look up how an item got to be in a particular status and what changes have been made to hold and circ rules. The can also be used to look up patron, org unit, and bib record edits. <br></div><div><br></div><div>If anyone has any examples of information they would like to try to look up in the auditor tables, send them my way and I can try to prepare more sample queries for the meeting.</div><div><br></div><div>If you have any other report-related topics that you'd like to talk about at future meetings, please let me know!<br></div><div><br></div><div>Thank you and Happy Holidays!</div><div>Jessica<br></div><div><br></div><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><p dir="ltr" style="line-height:1.2;margin-left:27pt;margin-top:0pt;margin-bottom:6pt"><span style="font-size:12pt;font-family:Arial,sans-serif;color:#2c497f;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap">Jessica Woolford</span><span style="font-size:12pt;font-family:Arial,sans-serif;color:#2c497f;background-color:transparent;font-weight:400;font-style:italic;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap"> </span><span style="font-size:11pt;font-family:Arial,sans-serif;color:#2c497f;background-color:transparent;font-weight:400;font-style:italic;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap">(she/her)</span><span style="font-size:12pt;font-family:Arial,sans-serif;color:#2c497f;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap"><br></span><span style="font-size:12pt;font-family:Arial,sans-serif;color:#2c497f;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap">Evergreen Systems Manager</span></p><p dir="ltr" style="line-height:1.2;margin-left:27pt;margin-top:0pt;margin-bottom:6pt"><a href="mailto:jwoolford@biblio.org" style="text-decoration:none" target="_blank"><span style="font-size:10pt;font-family:Arial,sans-serif;color:#1155cc;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:underline;vertical-align:baseline;white-space:pre;white-space:pre-wrap">jwoolford@biblio.org</span></a><span style="font-size:10pt;font-family:Arial,sans-serif;color:#202124;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap"> | </span><a href="tel:203-577-4070" style="text-decoration:none" target="_blank"><span style="font-size:10pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap">(203) 577-4070 </span></a><span style="font-size:10pt;font-family:Arial,sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap">x105</span></p><p dir="ltr" style="line-height:1.2;margin-left:27pt;margin-top:0pt;margin-bottom:4pt"><a href="https://helpdesk.biblio.org" style="text-decoration:none" target="_blank"><span style="font-size:10pt;font-family:Arial,sans-serif;color:#39898c;background-color:transparent;font-weight:700;font-style:normal;font-variant:normal;text-decoration:underline;vertical-align:baseline;white-space:pre;white-space:pre-wrap">» Help Desk: Open or Check a Ticket</span></a></p><p dir="ltr" style="line-height:1.2;margin-left:22.5pt;margin-top:0pt;margin-bottom:0pt"><a href="https://biblio.org/" style="text-decoration:none" target="_blank"><span style="font-size:11pt;font-family:Arial,sans-serif;color:#1155cc;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:underline;vertical-align:baseline;white-space:pre;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:219px;height:81px"><img alt="Stylized turquoise book with blue swirl around it, above text reading Bibliomation: Libraries Sharing Computerized Services" title="Bibliomation, Inc. Logo" src="https://lh7-us.googleusercontent.com/yh9-9uT1OLdC7tNAuKOg7sD5hXWKxW3p-ql_bydDiBxMUUBuh5IijR9bhO3L31DZthEAXJi-nI6Ud069GlQDbNU23K9XJkjNscTYS-n2TgYCPk7UF6QxxP2r54UC_hM80LoAoYx3_JRfJzZdR3M8X9A" style="margin-left:0px" width="219" height="81"></span></span></a></p></div></div></div></div></div></div></div></div></div>