Custom Report Query Building Help Needed


ATTENTION Customers, All Partners and Employees: The Customer Support Portal (CSP) will be undergoing maintenance and unavailable on Saturday, November 7, 2020, from 11 am to 11 pm PST. Please read our blog for more information.

L3 Networker

Custom Report Query Building Help Needed

I'm having a hard time getting my URL report built and sorted.


I want to accomplish the following


1. category must match ADULT or NUDITY

2. source user must not be a member of FILT_STAFF or M_FILT_STAFF active directory groups (basically students)

3. search all IPs in EXCEPT the following subnets


Another way of prhasing it:

show me all students who went to PORN or NUDITY sites.  Don't show me any IPs which don't have "domain\<student id>" listed as the source user.  I don't want to see our BYOD wireless or Chromebook subnets because there is no authentication.


Any suggestions?




L7 Applicator

Try this:


((category eq adult) or (category eq nudity)) and (user.src neq FILT_STAFF ) and (user.src neq M_FILT_STAFF ) and ( addr.src in ) and !(( addr.src in ) or ( addr.src in ) or ( addr.src in ) or ( addr.src in ) or ( addr.src in ) or ( addr.src in ))

Enterprise Architect @ Cloud Carib
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the Live Community as a whole!

The Live Community thanks you for your participation!