In house use data - Sierra

Hello - Does anyone have a query to pull In-House Use data over different time periods (last year, last 2 years, etc)? We’re Sierra users. Thanks in advance.

I use the Web Management Reports to look at in-house use (circulation activity – Inhouse). See https://documentation.iii.com/sierrahelp/Default.htm#sgwr/sgwr_intro.html.

Decision Center works similarly to Web Management Reports for that. On the SQL end of things you can search for circ_trans.op_code = ‘u’, but have to deal with your local data retention on that (2 weeks only by default if you haven’t asked Innovative to expand the table).