TicketSQL to select all tickets with requestor "nobody in particular"

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;

Use ‘nobody’ vs. ‘nobody in particular’ as your search criteria.On Fri, Mar 13, 2015 at 4:02 PM, Al Joslin allen.joslin@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;

no, that doesn’t work

I was able to get something by selecting requestor email not like ‘@‘> On Mar 13, 2015, at 4:33 PM, Trev trevor@onepost.net wrote:

Use ‘nobody’ vs. ‘nobody in particular’ as your search criteria.

On Fri, Mar 13, 2015 at 4:02 PM, Al Joslin <allen.joslin@gmail.com mailto:allen.joslin@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;

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@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@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;

signature.asc (203 Bytes)