Technical Library | Support

Go to the table of contents Go to the previous page You are at the end of the document View or print as PDF
Web Security Reporting FAQ : How do I export the Suspicious Event Summary?
How do I export the Suspicious Event Summary?
50380 | Reporting FAQ | Web Security Solutions | Updated 22-Oct-2013
Applies to:
Websense Web Filter, Web Security, Web Security Gateway, and Web Security Gateway Anywhere, v7.7 and 7.8
The Suspicious Event Summary on the Threats Dashboard lists information about threat-related events in your network. To export the event data to a CSV file, click the Export To CSV link above the summary table.
If your system has more than 100,000 threat-related event records, the TRITON console cannot generate the CSV file directly. Instead, you are prompted to export the records directly from the Log Database.
To do this:
1.
Connect to the Microsoft SQL Server machine that hosts the Log Database.
2.
Open SQL Server Management Studio (Start > All Programs > Microsoft SQL Server 2008 or 2012 > SQL Server Management Studio) and log on to the SQL Server instance that hosts your Websense Web Security Log Database.
3.
In the Object Explorer, under Databases, select the catalog database (wslogdb70, by default).
4.
Click New Query at the top of the window.
5.
When the query window displays, enter:
select * from amt_UI_log_details
6.
Click Execute.
A Results pane will display the data in a table format.
7.
In the Results pane, right-click and select Save Results As to output the results to a file.

Go to the table of contents Go to the previous page You are at the end of the document View or print as PDF
Web Security Reporting FAQ : How do I export the Suspicious Event Summary?
Copyright 2016 Forcepoint LLC. All rights reserved.