-
Notifications
You must be signed in to change notification settings - Fork 7
Home
Jeremy Goldstein edited this page Jun 30, 2020
·
112 revisions
This is my attempt to organize my various queries, updated as time allows.
- Bad Item Barcodes
- Bad Price Fields
- Bibs With Duplicate Non-Repeating Fields
- Bibs With Paid Orders and no items at a library
- Clear Holdshelf Audit
- Course Reserves Items Off Reserve
- Duplicate Axis 360 Records
- Duplicate Bib Records (By Index)
- Duplicate Patron Records (by Name and bdate)
- False Holdshelf status
- Fund Encumbrance Audit
- Fund Expenditure Audit
- Holds on Unavailable Titles
- Items Attached to Multiple Bibs
- Item holds on bibs with available copies
- Items with Multiple Barcodes
- Items Without Parents
- Itype Mattype Mismatches
- Locked Order Records
- Old Order Records
- On the Fly Records
- Online Patron Conversion Errors
- Orders On Hold
- Order Records Outside of Scopes (Downloaded Without Grid)
- Outstanding Holds report
- Patron Records with data entry errors
- Patrons with duplicate Online Renewal Charges
- Too Many Renewals
- Unused iTypes
- unused pTypes
- User Settings
- Volume Fields That Should Not Be Used
- Age of Collection
- Average Age of Collection By Scat
- Bibs with duplicate copies
- Collection Development by Call Number Range
- Collection Development by Language
- Collection Development by SCAT
- Cost Per Circ
-
Item / Order Collection Development
NOTE put results of two reports together by mattype columns - Collection Development Item report with Relative totals (total circ version)
- Collection Development Item report with Relative Totals (YTD circ version)
- High Utilization - Not Owned
- High Utilization - Owned
- Item Count By Location and Language
- Missing Titles
- Periodical circulation counts by title
- Purchase Alert With Orders
- Purchase Alert without Local Holds
- Network-wide Stats Query On Review File
- Top Requests List
- Underutilized Items
- Annual Items Added Summary
- ARIS Holdings by IType
- ARIS Holdings by Mat Type, Loc and IType
- Holdings By Status
- Holdings Loc by IType
- Items Added Loc By IType
- Magazine Count for ARIS
- Magazine Count by Checkin
- Magazine Count by Item
- Patron Count By Barcode Prefix
- Patron Count By PType
- Amount Spent Per Scat
- ARIS Holdings By IType
- ARIS Holdings By MatType
- Average Age by Last_checkout_date
- Average Patron
- Average Time to Pay Fine
- Bibs In a Subject With X Copies
- Bibs With Items Only Using 1 IType
- Blocked patron stats
- Call # Browse / Shelf List
- Check digit function
- Checkin Box Export
- Checkouts By Library, Format and Fines
- Checkout Location By Checkin Location
- Collection Value By Location and IType
- Comcat NCIP records
- Count Scat Usage
- Current SQL activity
- Edifact Usage
- Expiring Holds
- Fine ranges
- Fund Summary
- Holdings Crosstab By Location
- Index Listing
- Invoice Summary
- Item Status Count
- Items In Transit Snapshot
- Last Issue Received
- Library Transit Counts
- Loan Rule Snapshot
- Loan Rule Snapshot with blocked patron stats
- Loan Rule Snapshot by Checkout
- Loan Rule Snapshot by Fine
- Mass Market Paperbacks
- Patron Activity by Age
- Patron Count At a Location
- Patron Count By PType
- Patron Count By Barcode Prefix
- Patron Count By Zipcode
- Patrons created by hour
- Patrons with High Fines
- Payments Against a Fund
- Random Sampling of Records
- Recent Circ Transactions By PNumber
- Record Counts
- Record Ranges
- Relative Patron Checkouts
- Returning Patron Checkouts
- Review File to Booklist
- Shelf List
- Sierra Feature Usage
- Time On Holdshelf
- Top titles x Years Ago
- Transit snapshot
- Unique Patron Checkouts
- Users with SierraWeb option enabled
- User Permissions
- Value Calculator
- Vendor Stats
- View Outstanding Holds
- World Language Print Ownership
- X-Order Finder
-
NOTE Script developed by Gem Stone Logan and presented at 2017 IUG conference