<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Ok, that helps some I guess. Sounds like I will need to create a search for each person/status though,which I'm trying to avoid.<div><br><div><div>On Apr 14, 2010, at 12:18 PM, Kenneth Crocker wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">Tyler,<br><br>Well, setting up a dashboard is pretty simple, but it will do you no good if you do not know how to create a query.<br><br>Once you have a query up and running correctly, you save it as your personal query. Then you navigate to Tools->Dashboards. Click Dashboards. Then click "New". Give your new dashboard a meaningful name. Save it it as a personal dashboard. While in the same screen (after saving the name of the new dashboard) navigating to the right where you will see <br> Basics Queries Subscriptions". Click "Queries" and select the one that you want to be in your dashboard (you can have multiple queries and charts in a dashboard). Then select Subscriptions and in that page you select when you want it to run and who you want to receive it other than yourself.<br> <br>Note: if you want someone other than yourself to get the dashboard results, you need to create a cron job to run.<br><br>Most of this is in the tutorial on dashboards, but this little summary might help.<br><br>Kenn<br> LBNL<br><br><div class="gmail_quote">On Tue, Apr 13, 2010 at 3:45 PM, <span dir="ltr"><<a href="mailto:teaves@mail.nccooke.com">teaves@mail.nccooke.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"> <div class="im">> Tyler,<br> ><br> > Are you saying you do not know how to develop a query to do this or do not<br> > know how to put it in a dashboard or both?<br> ><br> > Kenn<br> > LBNL<br> ><br> <br> </div>A bit of both. Just did an install of RT today so I'm certainly not<br> familiar with it. I do have the book and it was helpful during the install<br> but it makes little mention of TicketSQL or Dashboards beyond saying they<br> exist.<br> <div><div></div><div class="h5"><br> > On Tue, Apr 13, 2010 at 1:52 PM, Tyler Eaves <<a href="mailto:teaves@reflector.com">teaves@reflector.com</a>> wrote:<br> ><br> >> Got a request here...<br> >><br> >> I'd like a dashboard I can put on the at a glance page that will show<br> >> the<br> >> new / open / stalled tickets per user, in the same style as the<br> >> per-queue<br> >> list that's there by default. I'm on 3.8.7.<br> >><br> >><br> >> Tyler Eaves<br> >> Programmer<br> >> Cooke Communications / The Daily Reflector<br> >> 252-329-9633<br> >><br> >> <a href="mailto:teaves@reflector.com">teaves@reflector.com</a><br> >><br> >><br> >><br> >><br> >> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br> >> Buy a copy at <a href="http://rtbook.bestpractical.com" target="_blank">http://rtbook.bestpractical.com</a><br> >><br> ><br> <br> <br> </div></div></blockquote></div><br></blockquote></div><br><div apple-content-edited="true"> <span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div>Tyler Eaves</div><div>Programmer</div><div>Cooke Communications / The Daily Reflector</div><div>252-329-9633</div><div><br></div><div><a href="mailto:teaves@reflector.com">teaves@reflector.com</a></div><div><br></div></div></div></span><br class="Apple-interchange-newline"> </div><br></div></body></html>