SIP Reports is a powerful, flexible tool for summarizing call activities in a variety of ways. This can help gain insight into trends and patterns in call activity to better understand and manage the network.
Here’s a list of terms used in SIP Reports and explanations of what they mean:
- Filters - selection criteria used to filter output to a subset of the available data
- Group By - how report data is summarized in the report, with one row for each unique value of the Group By field
- Sort By - the field used for sorting
- Order - whether the Sort By is in ascending or descending order
- Columns - selection of data columns to appear on the report
SIP Reports Features
Date Selection
As with other ClearIP analytics functions, the top-left of the SIP Reports screen provides options for date/time range selection. (See date/time range selection for more information.) The default initial view shows data for a rolling hour. ClearIP retains 14 weeks of history, and old data rolls out of the system automatically.
Filters
Filters can be used to enter data selection criteria.
In the Filter Value field, it is possible to select from a drop-down list of values or begin typing the value desired. While typing, the drop-down list will show just the values that match what’s been typed.
It’s possible to enter more than one filter. For more than one filter, the Filter Operator will determine how the filters are used. If the Filter Operator is And, only records that match all the filters will be selected. If the Filter Operator is Or, records will be selected if they match at least one of the filters.
ClearIP does not support using multiple filters with a mixture of And and Or Filter Operators.
Group By
The Group By field offers a variety of fields to choose from, which make SIP Reports such a powerful tool for understanding call activity and setting control values to fine-tune the system. The Group By fields available can be classified in different categories:
- Date/time fields. Examples include Second, Minute, Five-Minutes, Hour and Day (using UTC time, not local time). These Group By fields are great for looking at Total Calling Fraud Score and Total Called Fraud Score. For example, fast traffic pumping is detected when the Total Fraud Score in a five-minute period exceeds the fraud threshold. A report can be run summing fraud scores grouped by Five-Minute blocks of time to see what those totals look like. This would help set reasonable Default Fraud Threshold values in Fast Traffic Pumping triggers, for example.
- Organizational fields. Examples include SBC, Service Provider, Group and User. These Group By fields are useful for summing call counts by organizational groups, if segmented organizational groups are used.
- Other call attributes. Examples include Called Country, Calling Country, and a variety of other fields found in SIP records. Calculating totals for these groups help better identify and understand patterns in call traffic.
Sort-By and Order
The Sort By and Order settings allow for one numeric field to be selected to use for sorting in either ascending or descending order.
Columns
The Columns button displays a list of fields that can be displayed in the report table. The first field (or fields, sometimes) is the Group By field chosen; this decides whether to display that field in the report.
The remaining fields listed are numeric fields that are available to be summed for each value of the Group By field chosen. Examples include Total Called Fraud Score, Total Calling Fraud Score, SIP Count, SIP 404 Count, SIP 603 Count, etc.