Subscribers with the highest outbound call volume
The table below explains in detail the steps of a Splunk Enterprise or Splunk Cloud Platform search to see which of your telecom services subscribers have the highest outbound call volume. For more information, review the use case monitoring key telecommunications service metrics.
Some commands, parameters, and field names in the searches below may need to be adjusted to match your environment. In addition, to optimize the searches shown below, you should specify an index and a time range when appropriate.
Splunk recommends that customers look into using data models, report acceleration, or summary indexing when searching across hundreds of GBs of events in a single search. The searches provided here are a good starting point, but depending on your data, search time range, and other factors, more can be done to ensure that they scale appropriately.
Splunk Search | Explanation |
---|---|
| sourcetype=<call detail records> | Search only your telephony data. |
| eval _time = start | Extract the timestamp and put it in a field called "start". |
| rex field=dst "(?<dstCountry>\d+)(?=\d{10})" |
Extract the destination (dst) country code. This example assumes that the country code is what precedes a 10 digit number. |
| lookup <country code to name mapping file> phoneCode AS dstCountry OUTPUTNEW countryName as dstCountryName ISO2 AS dstCountryCode |
Enrich the results by adding a country name and iso code, based on the dstCountry field extracted. If the column names in your lookup file differ from those shown here, adjust the search to match the names in your lookup. |
| stats count count(dstCountryName) AS dcount values(dstCountryName) AS CountryName BY src dstCountryName | Calculate counts of dialed countries and return them with the names of the countries, sorted first by source country. |
| stats sum(count) AS count list(dcount) AS dcount values(CountryName) AS dstCountryName BY src | Sum the total count by source, list dialed destinations and counts, and sort by source. |
| sort - count | Sort the results with the largest count first. |
| table src dstCountryName dcount count | Display the results in a table with columns in the order shown. |
| rename src AS "Subscriber" count AS "Total Call Count" dcount AS "Destination Calls" dstCountryName AS "Dialed Countries" | Rename the fields as shown for better readability. |