Edge Threat Management Wiki - Arista - User contributions [en]

Operators

2016-01-22T21:12:29Z

ENewvine:

Operators are used with Conditions to create custom reports and alerts. The operator is used to evaluate the value criteria specified for the given condition.

{| border="1"
|-
! style="width:1%; text-align:left; padding:5px;" | Operator
! style="width:14%; text-align:left; padding:5px;" | Description
! style="width:33%; text-align:left; padding:5px;" | Syntax
! style="width:22%; text-align:left; padding:5px;" | Notes
! style="width:30%; text-align:left; padding:5px;" | Example
|-
| style="text-align:left; vertical-align:top;" | =
| style="text-align:left; vertical-align:top;" | Is Equal To
| style="text-align:left; vertical-align:top;" | Condition = value
| style="text-align:left; vertical-align:top;" | Requires an exact match it will not match partials.
| style="text-align:left; vertical-align:top;" | ''Only show Web Filter events where host accessed is "www.google.com" '' Host [host] = www.google.com
|-
| style="text-align:left; vertical-align:top;" | !=
| style="text-align:left; vertical-align:top;" | Is Not Equal To
| style="text-align:left; vertical-align:top;" | Condition != value Condition <> value
| style="text-align:left; vertical-align:top;" | Requires an exact match it will not match partials.
| style="text-align:left; vertical-align:top;" | ''Show all Web Filter events where client IP address is not "192.168.2.214" '' Client [c_client_addr] != 192.168.2.214
|-
| style="text-align:left; vertical-align:top;" | >
| style="text-align:left; vertical-align:top;" | Is Greater Than
| style="text-align:left; vertical-align:top;" | Condition > value
| style="text-align:left; vertical-align:top;" | Requires an exact match it will not match partials.
| style="text-align:left; vertical-align:top;" | ''Show all activity in Firewall for non-standard ports (1024 - 65535) '' Server Port [s_server_port] > 1024
|-
| style="text-align:left; vertical-align:top;" | <
| style="text-align:left; vertical-align:top;" | Is Less Than
| style="text-align:left; vertical-align:top;" | Condition < value
| style="text-align:left; vertical-align:top;" | Requires an exact match it will not match partials.
| style="text-align:left; vertical-align:top;" | ''Show all instances where available memory was less than 500 MB. Server Status Events, found under System > Reports, shows memory usage.'' Memory Free [mem_free] < 524288000 (it is stored in the database as bytes)
|-
| style="text-align:left; vertical-align:top;" | >=
| style="text-align:left; vertical-align:top;" | Is Greater Than Or Equal To
| style="text-align:left; vertical-align:top;" | Condition >= value
| style="text-align:left; vertical-align:top;" | Requires an exact match it will not match partials.
| style="text-align:left; vertical-align:top;" | ''Show all sessions scanned by Shield where total bytes sent to destination IP is greater than 1 GB'' To-Server Bytes [p2s_bytes] >= 1073741824 (it is stored in the database as bytes)
|-
| style="text-align:left; vertical-align:top;" | <=
| style="text-align:left; vertical-align:top;" | Is Less Than Or Equal To
| style="text-align:left; vertical-align:top;" | Condition <= value
| style="text-align:left; vertical-align:top;" | Requires an exact match it will not match partials.
| style="text-align:left; vertical-align:top;" | ''Show all instances where Free Disk Space was less than or equal to 100 GB. Server Status Events, found under System > Reports, shows free disk space.'' Disk Free [disk_free] < 100000000000 (it is stored in the database as bytes)
|-
| style="text-align:left; vertical-align:top;" | LIKE
| style="text-align:left; vertical-align:top;" | Is Similar to
| style="text-align:left; vertical-align:top;" | Condition LIKE (%)value(%)
| style="text-align:left; vertical-align:top;" | Often used in conjunction with % to wildcard the value
| style="text-align:left; vertical-align:top;" | ''Show all Web Filter Events where a user accessed any part of google.com.'' Host [host] like %google.com
|-
| style="text-align:left; vertical-align:top;" | NOT LIKE
| style="text-align:left; vertical-align:top;" | Is Not Similar to
| style="text-align:left; vertical-align:top;" | Condition NOT LIKE (%)value(%)
| style="text-align:left; vertical-align:top;" | Often used in conjunction with % to wildcard the value
| style="text-align:left; vertical-align:top;" | ''Show Firewall events that do not have a destination address (server) in your ISP's subnet. Example 123.45.67.0/24'' Server [s_server_addr] not like 123.45.67%
|-
| style="text-align:left; vertical-align:top;" | IS
| style="text-align:left; vertical-align:top;" | Is value
| style="text-align:left; vertical-align:top;" | Condition IS NULL Condition IS true/false/unknown Condition1 IS distinct from Condition2
| style="text-align:left; vertical-align:top;" | Requires an exact match it will not match partials. Does not work with string or number values
| style="text-align:left; vertical-align:top;" | ''Show all Shield events where there was no username on the session.'' Username [username] is NULL
|-
| style="text-align:left; vertical-align:top;" | IS NOT
| style="text-align:left; vertical-align:top;" | Is Not value
| style="text-align:left; vertical-align:top;" | Condition IS NOT NULL Condition IS NOT true/false/unknown Condition1 IS NOT distinct from Condition2
| style="text-align:left; vertical-align:top;" | Requires an exact match it will not match partials. Does not work with string or number values
| style="text-align:left; vertical-align:top;" | ''Show all Application Control events that have Detail values.'' Detail (Application Control) [application_control_detail] is not NULL
|-
| style="text-align:left; vertical-align:top;" | IN
| style="text-align:left; vertical-align:top;" | Is In set of values (value_1, value_2, ...)
| style="text-align:left; vertical-align:top;" | Condition IN (value_1, value_2, value_3)
| style="text-align:left; vertical-align:top;" | Requires an exact match it will not match partials. Only works with integer (whole number) and boolean (true/false) type values.
| style="text-align:left; vertical-align:top;" | ''Show In Firewall all entries for web related ports'' Server Port [s_server_port] in (53,80,443)
|-
| style="text-align:left; vertical-align:top;" | NOT IN
| style="text-align:left; vertical-align:top;" | Is Not In set of values (value_1, value_2, ...)
| style="text-align:left; vertical-align:top;" | Condition NOT IN (value_1, value_2, value_3)
| style="text-align:left; vertical-align:top;" | Requires an exact match it will not match partials. Only works with integer (whole number) and boolean (true/false) type values.
| style="text-align:left; vertical-align:top;" | ''Show all traffic in Application Control that is not email related.'' Server Port [s_server_port] not in (25,110,143,993.995.587,465)
|}

Report Viewer

2016-01-14T18:59:48Z

ENewvine: /* Conditions */

Event_Log
<noinclude>
= Reports =
Reports provide a graphical view of the network traffic and actions of your Untangle. Various reports are available within applications and base system components. The reports can be manipulated to drill down, customize, and export data in many ways using the Report Viewer.

[[Image:112_report_viewer_081015.png|700px|center|Web Filter - Reports]]
</noinclude>

= Report Viewer =
<includeonly>
Reports provide a graphical view of the network traffic and actions of your Untangle. Various reports are available within applications and base system components. The reports can be manipulated to drill down, customize, and export data in many ways using the Report Viewer.
</includeonly>

[[Image:112_report_viewer_color.png|700px|center|Web Filter - Reports]]
There are five panels in the Report Viewer:

* Application Selector (Green)(Left): This allows you to choose from the system and application report groupings. By selecting an option here, the results in the Report Selector section will be filtered to show just that application. When using the report viewer within an application, this pane is not shown.

* Report Selector (Blue)(Left): This panel is broken into two areas containing reports and event log queries. The "Select Report" contains a list of pre-defined reports and event log queries. Saved custom reports will also appear in the reports list.

* Report Chart (Yellow)(Top): Shows the currently selected report and contains options to change the type of chart, customize the report, change the report start and end times, and view the report in Event Log format. You can also interact directly with the report. Data series can be removed from the view using the legend and hovering over data series will show the values in reader friendly format.

* Current Data (Orange)(Right): Displays the raw data that is being used to generate the report. Data points will be displayed in reader friendly format when hovering over the graph. The data can be exported to a CSV text file that can be viewed by your favorite spreadsheet or text editor. Additionally, by clicking the filter icon in this pane, conditions can be applied instantly. This window will only display with report charts and is not displayed for event reports.

* Conditions (Red)(Bottom): Conditions can be used to filter the traffic information shown in reports and events. Multiple conditions can be added to drill down and inspect data. The available conditions will vary based on which application you are viewing.

=== Report Charts ===

The Report Chart contains several features to help manipulate the view of the report to your liking.

[[Image:Report_viewer_071415.png|600px|center|Web Filter - Report Viewer]]

Along the top and bottom toolbars you will find the following selections:

*Top Toolbar:
** Chart Type (if available): Choose from Line, Bar, Bar Overlapped, Bar 3D, Bar 3D Overlapped. This feature is not available for pie charts.
** Customize: Build and save customized reports. Custom reports will be saved in the report selection.
** View Events: View the individual events that were used to build the report in Events format.
** Download: Download a .png image of the chart.

* Bottom Toolbar:
** Time Selection: Select the start and end time of the report. Beware that running queries (viewing reports) against a huge number of days can still be expensive if the server is busy.
** Refresh: Force the writing of all events currently buffered in memory to the database, and then re-query the database for current data.
** Auto Refresh: Automatically refresh every few seconds. This is useful to keep displayed while debugging an issue or if you want to see whats happening in real time.

The legend will appear at the bottom of the chart for line or bar charts, and to the right for pie charts. By clicking the fields in the legend a data series can be removed or re-added. This can help to remove clutter and focus on certain data series.

<blockquote>
''Note:'' Some queries are more expensive than others to run. Depending on your hardware and the current amount of traffic Untangle is processing it is possible that you can slow network traffic by running expensive queries.
</blockquote>

<noinclude>

= Events =
</noinclude>
<includeonly>
=== Events ===
</includeonly>
[[Image:112_eventlogs_071415.png|600px|center|Event Log]]

Event reports show recent 1000 events sorted by time_stamp with the most recent events at the top.
When opening an event report it will automatically refresh and show you the default query.

The columns along the top will show the relevant columns for the specific event report and type of event being viewed. The example above shows the [[Web Filter]] event log so you can see many columns related to the web request and what action was taken.

Along the top and bottom toolbars you will find the following selections:

*Top Toolbar:
** Filter: A filter can be used to instantly select any rows that match your filter string and display only those rows. Use the ''Case sensitive'' check box to match case and ''Clear Filters'' button to remove the filter and display all data.
** Export: Export ALL events of the relevant query to a CSV text file that can be viewed by your favorite spreadsheet or text editor. This is necessary for large datasets. Browsers can not handle huge datasets in the DOM and will become not responsive if given too much data. As such, there is an 1000 event limit on events displayed in the UI, however the ''Export'' button will give you all events in a potentially very large text file. Generating and downloading the export may take some time.

* Bottom Toolbar:
** Number of Events: The default is to show 1,000 events. This can be increased to 10,000 or 50,000.
** Time Selection: Select the start and end time of the report. Beware that running queries (viewing reports) against a huge number of days can still be expensive if the server is busy.
** Refresh: Force the writing of all events currently buffered in memory to the database, and then re-query the database for current data.
** Auto Refresh: Automatically refresh every few seconds. This is useful to keep displayed while debugging an issue or if you want to see whats happening in real time.

Finally, you have the page management which you can use to browse through the current events being displayed.

<blockquote>
''Note:'' Some queries are more expensive than others to run. Depending on your hardware and the current amount of traffic Untangle is processing it is possible that you can slow network traffic by running expensive queries. This can be especially true for queries that only return a few events because it will collect events up until 1000 events. If 1000 events don't exist it will scan the entire database and return whatever events do exist. For example, "Infected Web Events" in [[Virus Blocker]] typically only returns a few events. This query can take some time because it will scan the entire web request table looking for "Infected Web Events."
</blockquote>

<noinclude>
= Conditions =
</noinclude>
<includeonly>

=== Conditions ===
</includeonly>

The Conditions panel appears at the bottom panel and can be used to filter the queries used in both reports and events. Multiple conditions can be added to drill down and inspect data. Conditions can also be added to pie charts quickly from the Current Data window by using the filter icon.

The left hand drop down lists the available conditions that can be added. These will vary based on the application you are viewing. These can be matched to data by selecting an operator and entering the query string you're looking for. After entering a condition the report or event you are viewing will automatically refresh.

[[Image:112_addconditions_071415.png|600px|center|Conditions]]

In this example, we've added 2 conditions to see all traffic from a single client IP address (192.168.72.128) going to a specific domain (microsoft.com).

Some Conditions will also have a Quick Add selection to automatically select conditions. A common use case for this is choosing which rack/policy will be queried. Once selected, this will automatically be added to the Conditions list.

==== Condition Operators ====

The second field in the condition is the logical operator that will be used in evaluating the condition value defined in the last field. In most use cases the default "=" operator is what you want to use. However, there are several other operators available that make the reports and alerts a whole lot more powerful.

A detailed outline of each operator is on the [[Operators]] page.

===== Conditions Example - Rack by Policy ID =====

In many cases, you may just want to see the traffic related to a specific rack within policy manager. This can be accomplished very easily by adding a condition using the Quick Add feature.

[[Image:112_quickadd_policy.png|300px|right|Quick Add]]

# Open Report Viewer or Reports tab.
# In the Conditions panel, select '''Quick Add'''.
# Choose '''Policy ID''' and the rack name.
# The conditions is applied and will remain applied as you switch between reports.

Alternately, you can manually enter the condition. To do this, go to Policy Manager > Settings and take not of the rack ID number. Then, in the drop down condition list, select Policy ID, select the operator ''='', and then enter the rack ID.

===== Conditions Example - Web Filter Categories =====

From pie charts, you can quickly add a condition from the Current Data window. This can be handy for use with the Web Filter category selection which we'll use for this example. Once the condition is applied, we can then use other reports to drill down to find out more information about the traffic such as which user might be responsible.

[[Image:112_current_data_games.png|300px|right|Quick Add]]

# Open Report Viewer or the Web Filter Reports tab.
# Select the '''Top Categories''' report (by size or requests). In our example, you can see Games was at the top.
# Next to Games, click the "filter" icon.
# The conditions window displays with the category name Games pre-populated.
# Click '''Done''' to add the condition.
# To find the user(s) or machine(s) generating the traffic you can click to any other report such as '''Top Hostnames''' or '''Top Usernames'''

<noinclude>

= Application Specific Report Pages =

*[[All Reports]]
*[[Web Filter Reports]]
</noinclude>