# In house use data - Sierra

**URL:** https://forum.innovativeusers.org/t/in-house-use-data-sierra/2308
**Category:** Sierra, Millennium & Encore
**Tags:** sierra-sql
**Created:** [March 18, 2025, 10:36pm UTC](https://forum.innovativeusers.org/t/in-house-use-data-sierra/2308 "2025-03-18T22:36:24Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![AnnieW](https://forum.innovativeusers.org/letter_avatar_proxy/v4/letter/a/b4bc9f/32.png) [@AnnieW](https://forum.innovativeusers.org/u/AnnieW)
#### Post date: [March 18, 2025, 10:36pm UTC](https://forum.innovativeusers.org/t/in-house-use-data-sierra/2308/1 "2025-03-18T22:36:25Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![pruntela](https://forum.innovativeusers.org/user_avatar/forum.innovativeusers.org/pruntela/32/1666_2.png) [@pruntela](https://forum.innovativeusers.org/u/pruntela)
#### Post date: [March 19, 2025, 12:49pm UTC](https://forum.innovativeusers.org/t/in-house-use-data-sierra/2308/2 "2025-03-19T12:49:54Z")

</div>

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](https://documentation.iii.com/sierrahelp/Default.htm#sgwr/sgwr_intro.html).

---

<div class="post-metadata">

### Author: ![jmgold](https://forum.innovativeusers.org/user_avatar/forum.innovativeusers.org/jmgold/32/228_2.png) [@jmgold](https://forum.innovativeusers.org/u/jmgold)
#### Post date: [March 19, 2025, 12:55pm UTC](https://forum.innovativeusers.org/t/in-house-use-data-sierra/2308/3 "2025-03-19T12:55:21Z")

</div>

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).