[rt-users] TicketSQL to select all tickets with requestor "nobody in particular"

[Landon Stewart]

Our "Nobody" user is ID #6 so I'd use that in the TicketSQL query as:

"Requestor.id = 6"

You can find out what your "Nobody" user's ID is (probably the same as ours):

1) Admin -> Users -> Select
2) Go to user: Nobody
3) click "Go!"

Landon Stewart : lstewart at iweb.com
Lead Specialist, Abuse and Security Management
Spécialiste principal, gestion des abus et sécurité
http://iweb.com : +1 (888) 909-4932

> On Mar 13, 2015, at 1:02 PM, Al Joslin <allen.joslin at gmail.com> wrote:
> 
> What is the TicketSQL to select all tickets with requestor "nobody in particular” ?
> 
> I can’t get  that list from the Search GUI either
> 
> thanks
> al;

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20150313/96215ff9/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 203 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20150313/96215ff9/attachment.sig>