Querying the Database

From the Dashboard, you query the Spector 360 Database by selecting criteria. Criteria includes dates, users, computers, programs used, keywords, and so on. Criteria acts as a "filter." The Dashboard will retrieve ONLY the data that matches your criteria selections. Every chart, report, or form in the Dashboard has predefined (default) criteria settings.

The Dashboard may prompt you for Criteria selections before opening your selected report or Data/User Explorer form. You can simply click OK to accept the default criteria, or make adjustments as you wish and then click OK.

To set criteria:

Open the Criteria box.
Double-click to open a form or report - OR -
Right-click on a form or report and select Criteria - OR -
Click the Criteria button below a Quick View chart or in a Event window. The Criteria box has two panels of settings: General Criteria and Event Criteria.

Select General Criteria.
General Criteria provides the same options as Global Criteria, and if General Criteria is set to <Use Global Criteria Setting>, whatever is set in the Global Criteria pane (on the main Dashboard window) will be the General Criteria. Each activity type has different Event Criteria, allowing you to search for specific event records.

Select Event Criteria.
By default, Event Criteria does not filter activity records and includes ALL data: programs, domains, types of email, an so on.

Click OK to set Criteria.
When you click OK to accept your selections and close the Criteria box, the Dashboard calls up data from the Database that matches your selections.

Instead of viewing all data, select criteria (yellow boxes) for data

To Look up Data by:

Choose:

Date of activity

Global or General Criteria

Users or user groups

Global or General Criteria

Computers or computer groups

Global or General Criteria

Search for matching information in any recorded field

Event Criteria - All events except Snapshots and User Activity

Programs or program groups

Event Criteria - All events except User Activity

Domains or domain groups

Event Criteria - Web, Email, File Transfer, Network Events

Web Filtering category or category groups

Event Criteria - Web Events

Time spent in activity

Event Criteria - Web, Network, Program Events

URL type (blocked, post, download, etc.)

Event Criteria - Web Events

Type of action taken

Event Criteria - Document Tracking, File Transfer

Type of service or protocol used

Event Criteria - Chat/IM, Email, File Transfer Events

Direction of Email

Event Criteria - Email Events

Email with or without attachments

Event Criteria - Email Events

Communication ports used

Event Criteria - File Transfer Events

Keyword detected in

Event Criteria - Keyword Alert Events

Search engine used

Event Criteria - Online Search

Many Quick View charts use customized Event Criteria settings. A red "Custom Criteria" stamp appears in the lower left corner of a Quick View chart when any setting has been changed from the default.

To save your criteria selections:

At the bottom of the Criteria box, select Save Criteria before clicking OK. The criteria you set will be retained for the chart, report, or data form. Criteria selections are normally applied until you use Refresh to update the Dashboard view with new data from the database. Then, criteria reverts to the default for a particular data view.

To bypass criteria and display the data:

If you don't want to select criteria before viewing this specific chart, report or data grid, check the Bypass Criteria Dialog option on the General Criteria box. The next time you open the view, there will be no prompt for criteria. You can always open the Criteria box from a Criteria button or the Data menu. Any Dashboard user can set this option. See Setting General Criteria.

To always bypass criteria selection:

A Master Login can turn off automatic display of the Criteria Dialog box for ALL tools in the Dashboard. Select Tools > Options from the menu bar. Check Bypass Criteria Dialog box option. See Tools: Options.