SPS can create statistics (bar, pie and list) from various information about the search results, for example, the distribution of the target hosts, and so on. To display statistics about the connections, complete the following steps:
Navigate to the Search (classic) > Search page.
Set the filters you need.
Click the icon in the header of the table. A pop-up window is displayed.
Figure 212: Search (classic) > Search — Displaying statistics
Select the type of metadata you want to create statistics on from the Statistics based on field
Select the type of chart to display, that is, Bar, Pie or List. The chart will be displayed in the same pop-up window.
By default, the statistics start with the largest number of entries. To start statistics with the least number of entries, select Least.
Select the number of data groups to display from the Number of entries field. For example, if you want to display the statistics of the ten hosts that start the most connections (the "top talkers"), select 10. That way the top ten talkers will be displayed individually, while the amount of connections started by the other hosts will be aggregated and labeled as Others.
For pie and bar charts you can select 5, 10 and 15, for lists 5, 10, 15, 50 and 100.
Figure 213: Search (classic) > Search — Selecting display type
Optional step: To export statistics data to a CSV file, select List, set the number of entries and click Export all to CSV. SPS compiles the selected data into a results.csv file.
This action exports all rows, not only the currently displayed ones.
Optional step: You can also save these statistics and include them in reports as a report subchapter. You can include these subchapters into your reports in the Reports > Configuration menu.
To save these statistics as custom statistics for reporting, click Save As Custom Statistics For Reporting.
Add a name for the statistics in the Name field.
Select a group from the already existing groups in the Groups field. The autocomplete function helps you with the selection.
Optional step: The Add to report as a subchapter function enables you to instantly add this statistics as a subchapter to the selected report.
Click Save. This action includes the saved statistics as a selectable subchapter into Reporting > Configuration. For details on how to add this subchapter to a selected report, see Configuring custom reports.
Use the Search interface to:
Search for audit trails stored on SPS, or archived to a remote server as described in Searching audit trails: the SPS connection database.
View meta-information about connections and connection-requests as described in Viewing connection details.
Download and replay audit trails as described in Replaying audit trails in your browser.
Use the Search (classic) interface:
If you want users to access audit trails only for connections for which they are granted permission.
For more information on configuring authorizers for a connection, see Configuring four-eyes authorization.
To upload the certificates and corresponding private keys to your private keystore, use the Search (classic) interface.
To view screenshots generated for encrypted audit trails, and replay encrypted audit trails in your browser, you have to upload the necessary certificates and corresponding private keys to your private keystore.
For more information, see Replaying encrypted audit trails in your browser.
This section describes how you can access the Search interface. It also lists the steps to take to search effectively, view the details of a connection, and replay the audit trails.
Users need the Search privilege to access the Search interface.
Assigning the Search privilege to a user on the AAA > Access Control page, automatically enables the Search in all connections privilege, and grants the user access to every audit trail, even if the user is not a member of the groups listed in the Access Control option of the particular connection policy.
If you want users to access audit trails only for connections for which they are granted permission, use the Search (classic) interface.
For more information on configuring:
To access the Search interface, navigate to Search > Search.
You can view sessions in a card, table or flow view.
for the card view.
Figure 214: Search > Search — Card view
for the table view.
Figure 215: Search > Search — Table view
Sessions are displayed sorted by date. For ongoing sessions, the Search interface is updated in real-time to always show the most up-to-date information.
for the flow view.
Figure 216: Search > Search — Flow view
The flow view allows you to:
Quickly visualize the distribution of the sessions based on their various metadata, such as, client address, username, protocol, verdict, server address, and Privileged Account Analytics (PAA) score.
The metadata of the sessions are presented as vertical bars and each bar represents the proportional value of the data.
The verdict column shows that most of the sessions were accepted, some sessions denied, and a small number of sessions fall into the category of ACCEPT-TERMINATED, FAIL, and so on.
Figure 217: Search > Search > Flow view — proportional data representation
See at a glance the relationship between various metadata and to identify patterns in user behavior.
You want to have an overview of activities where access was denied.
A quick look at the verdict column shows that there were several denied accesses and the lines from the DENY field point to several server addresses.
Figure 218: Search > Search > Flow view — relationship between metadata
Use it interactively to drill down further on information.
To drill down on information, click on an item, then click Search.
To exclude an item, press Ctrl while clicking the item.
You want to investigate if there were any unusual activities. To take a closer look, in the score column, click Unusual, then click Search.
The flow view now only displays the unusual session activities. You can further narrow your search as required.
Figure 219: Search > Search > Flow view — interactive drill down
To sort columns, from the card or table view, click the Sort by drop-down menu and select from the list.
Figure 220: Search > Search — Sort columns
For example, to see the shortest session, select Duration from the list. Sessions are now sorted based on duration with the shortest session first. To see the longest session, click ascending.
Specify a date and time range to restrict your search criteria as described in Specifying time ranges.
Filter connections as described in Using the connection search.
Search in the contents of audit trails as described in Using the content query.
View connection details as described in Viewing connection details.
Download and replay audit trails as described in Replaying audit trails in your browser.
Specify a time range to restrict, or filter your search criteria by setting boundaries on your searches. You can restrict the search to one of the preset time ranges, or use a custom time range for a more specific search.
When you specify a time range, the search result includes:
Connections started and finished anywhere between the start time and end time you specified.
Connections started anywhere between the start time and end time you specified.
Connections ended anywhere between the start time and end time you specified.
Active connections if they were started anywhere between the start time and the end time you specified.
For example, at 17:00 PM you specify a start date of 10:00 AM and end date of 15:00 PM for your search. The search result includes:
Connections started at 8:00 AM and ended at 14:00 PM.
Connections started at 11:00 AM and ended at 14:00 PM.
Connections started at 11:00 AM and ended at 16:00 PM.
Active connections started at 11:00 AM.
Active connections started at 10:00 AM.
To select the start date of your search, click Pick a date.
Alternatively, use the shortcuts button to restrict the search to one of the preset time ranges. For example, to investigate an incident that occurred sometime in the last hour, you can select Today, but a better option is Last 60 minutes.
Figure 221: Search > Search — Pick a date
From the calendar, select the start date as required.
The date refers to the timezone configured on SPS.
For exact time ranges, specify to search by the hour and minute.
Figure 222: Search > Search — Specify hour and minute
To select the end date of your search, click Pick a date and select a date as required.
If you specify only the start date, the end date is set to the current time.
Optional: To clear the start and end date, click shortcuts > All time.
Optional: You can use the timeline for a quick time range selection and visual representation of sessions in the selected interval.
Click the icon.
Figure 223: Search > Search — Using the timeline
The bars display the number of results in the selected interval.
The active sessions columns indicate all the sessions, which were active in the selected interval. The sessions started columns indicate all the sessions started during the selected interval. For example, if the selected interval is today between 8:00 AM and 9:00 AM, then a session started at 7:00 AM but lasting after 8:00 AM is displayed in the active sessions column. A session started at 8:30 AM is displayed in the sessions started column. Since the session was active during the selected time interval, the session started at 8:30 AM is also displayed in the active sessions column.
To disable the active sessions and view only the started sessions in the timeline, click . To disable the started sessions and view only the active sessions in the timeline, click .
Hovering the mouse above a bar displays the number of entries and the start and end date of the period that the bar represents.
To select a range, drag the mouse pointer across the timeline or use Shift+Click and select multiple bars.