Flexible detail investigative reports

Administrator Help | TRITON AP-WEB and Web Filter & Security | Version 8.3.x

Related topics:

Investigative reports

Summary investigative reports

Multi-level summary investigative reports

Favorite investigative reports

Scheduling investigative reports

Outliers investigative reports

Output options for investigative reports

Database connection and report defaults

Columns for flexible detail investigative reports

Detail reports give you a tabular view of the information in the Log Database. Access the detail report view from the main page after viewing a summary report for which you want more detail.

You can request a detail view from any row. However, when requesting a detail report based on hits, it is best to start from a row that shows fewer than 100,000 hits. If there are more than 100,000 hits for a particular row, the hits value displays in red to alert you that a detail report may be slow to generate.

Detail report view is considered flexible because it lets you design your own report. You can add or delete columns of information, and change the order of the columns displayed. The information is sorted according to order of the columns. You can even reverse the sort order within any column from ascending to descending, or vice versa.

Investigative reports are limited by the processor and available memory of the TRITON management server, as well as some network resources. Requests for large reports may time out. When you request a large report, you are given options for generating the report without timeouts.


	Important In any drop-down or values list, some options may appear in red. The red lettering indicates that selecting this option may result in a very large report. It is generally more effective to drill down further into the details before selecting that option.

Generate a summary report or multi-level report on the investigative reports main page. (See Summary investigative reports or Multi-level summary investigative reports.)

Drill down into the results to focus on the information of immediate interest.

When generating a report on hits, it is best to drill down to an entry that shows fewer than 100,000 hits before opening the detail report view.

Click the number or the bar on the row that you want to explore in more detail.To include multiple rows in one report, mark the check box for each row before clicking the number or bar on one row.

A popup message shows progress while the detail report loads.


	Note If the report takes a long time to generate, consider saving it as a Favorite report by clicking the link in the Loading message, and scheduling it to run later. See Favorite investigative reports.

Review the information in the initial report.

The default columns vary, depending on whether you are reporting on hits, bandwidth, or browse time, and on the selections made on the Options page. (See Database connection and report defaults.)

Click Modify Report at the top of the page.

The Current Report list in the Modify Report dialog box shows which columns appear in the current detail report.

Select a column name in the Available Columns or Current Report list, and click the right arrow (>) or left arrow (<) buttons to move that column to the other list.

Choose a maximum of 7 columns for the report. The column showing the measure (hits, bandwidth, browse time) from the initial summary report always appears as the right-most column. It does not appear as a choice when modifying the report.

See Columns for flexible detail investigative reports for a list of the columns available, and a description of each.

Select a column name in the Current Report list and use the up and down arrow buttons to change the order of the columns.

The column at the top of the Current Report list becomes the left column in the report.

Click the Summary or Detail link above the report to toggle between the two displays.


Option	Description
Summary	You must remove the Time column to display a summary report. Summary reports group into a single entry all records that share a common element. The specific element varies, according to the information reported. Typically, the right-most column before the measure shows the summarized element.
Detail	The Detail option displays every record as a separate row. The Time column can be displayed.

Click Submit to generate the report you defined.

10.

Use the following options to modify the displayed report.

Use the View options above the report to change the time period reported.

Click the up or down arrow in a column heading to reverse the sort order for that column, and the associated data.

Use the Next and Prev links above and below the report to display additional pages of the report, if any. By default, each page contains 100 rows, which can be adjusted to fit your needs. See Display and output options.

Click the URL to open the requested website in a new window.

11.

Click Favorite Reports if you want to save the report so that you can generate it again quickly or on a recurring basis (see Working with presentation report Favorites).