<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class=""><span style="line-height: 16px; background-color: rgb(255, 255, 255); font-family: arial, helvetica, sans-serif; font-size: small;" class="">Our "Nobody" user is ID #6 so I'd use that in the TicketSQL query as: </span></div><div class=""><font face="arial, helvetica, sans-serif" size="2" class=""><span style="line-height: 16px; background-color: rgb(255, 255, 255);" class=""><br class=""></span></font></div><div class=""><font face="arial, helvetica, sans-serif" size="2" class=""><span style="line-height: 16px; background-color: rgb(255, 255, 255);" class="">"</span></font>Requestor.id = 6"</div><div class=""><br class=""></div><div class=""><div class="">You can find out what your "Nobody" user's ID is (probably the same as ours):</div><div class=""><br class=""></div><div class="">1) Admin -> Users -> Select </div><div class="">2) <span style="font-family: arial, helvetica, sans-serif; font-size: 13px; line-height: 16px; background-color: rgb(255, 255, 255);" class="">Go to user: Nobody</span></div><div class="">3) click "Go!"</div></div><div class=""><br class=""></div><div apple-content-edited="true" class="">
<div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Landon Stewart : <a href="mailto:lstewart@iweb.com" class="">lstewart@iweb.com</a></div><div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Lead Specialist, Abuse and Security Management<br class="">Spécialiste principal, gestion des abus et sécurité<br class=""><a href="http://iweb.com" class="">http://iweb.com</a> : +1 (888) 909-4932</div></div>
</div>
<br class=""><div><blockquote type="cite" class=""><div class="">On Mar 13, 2015, at 1:02 PM, Al Joslin <<a href="mailto:allen.joslin@gmail.com" class="">allen.joslin@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class="">What is the TicketSQL to select all tickets with requestor "nobody in particular” ?<br class=""><br class="">I can’t get that list from the Search GUI either<br class=""><br class="">thanks<br class="">al;</div></blockquote></div><br class=""></body></html>