TQL Fields For USP Exceptions

The following fields are available via TQL.

All Fields

Field Name	Description	Field Type / Example Values
applications	Excepted applications The auto-complete feature lists only predefined application names. Customized application names are not included in the auto-complete list. You can type the name in the search.	String
appliedToAnyDomain	When true, returns USP exceptions where Domain is set to All domains.	true, false
approver	Approver of the exception	String
creator	Username of the USP exception creator.	String
description	Exception description	String
destinations	Excepted destinations	String
device.name	Name of the device	String
disabled	Is exception disabled?	true, false
domain.name	Name of the domain to which the device has been assigned	String
fromZone.is.Any	When true, returns USPs where the From zone is set to "Any zone in the USP" or left empty.	true, false
fromZone.name	Excepted from zones	String
ruleException	Shows type of exceptions True: Shows rule exceptions False: Shows traffic exceptions	true, false
id	The unique internal identifier of the USP exception.	String
invalid	Is exception invalid?	true, false
name	Exception name	String
policy.name	Name of the policy	String
ruleException	Shows type of exceptions True: Shows rule exceptions False: Shows traffic exceptions	true, false
rule.id	Rule UID	String
rule.name	Name of the rule	String
services	Excepted services	String Note that the auto-complete feature lists only pre-defined service names. If you have a customized service name, it will not appear in the auto-complete list, however you can type the name in the search.
sources	Excepted sources	String
ticketId	Ticket ID	String
timeCreated	Date the exception was created	YYYY-MM-DD
timeEnd	End date for exception to be active	YYYY-MM-DD
timeLastModified	Date the exception was last modified	YYYY-MM-DD
timeStart	Start date for exception to be active	YYYY-MM-DD
toZone.is.Any	When true, returns USPs where the To zone is set to "Any zone in the USP" or left empty.	true, false
toZone.name	Excepted to zone	String
trafficException	Shows type of exceptions True: Shows traffic exceptions False: Shows rule exceptions	true, false
usp.name	Names of excepted USPs	String

Sort Fields

Fields than can be used with the 'order by' operator.

name

Query Examples

Review traffic exception for legacy servers - search for source destination and service of the exception.

sources = '192.168.1.1' and destinations = '10.100.1.1' and services in ('http', 'telnet') order by name