4 SMS Statistics
Statistic Mapping
SMS-MO
This table describes the available SMS-MO statistics.
| Name | Description |
|---|---|
| NUM_IDP | Total messages processed for both SMS-MO and SMS-MT. |
| MO_NUM_IDP | Total SMS-MO messages processed. |
| MO_NUM_POSTPAID | Total SMS-MO postpaid messages processed. |
| MO_NUM_PREPAID | Total SMS-MO prepaid messages processed. |
| MO_NUM_BILLED | Total successfully billed SMS-MO prepaid messages. |
| MO_NUM_NO_CREDIT | Total SMS-MO messages where the submitter has insufficient balance. |
| MO_NUM_INVALID_BE | Total SMS-MO messages where the submitter is not valid for E2BE. |
| MO_NUM_INVALID_NE | Total SMS-MO messages where the named event is not valid for E2BE. |
| MO_NUM_NO_RULE | Total SMS-MO messages where no rating rule applies. |
| MO_NUM_CONTINUE | Total continue messages sent to message max for SMS-MO prepaid. |
| MO_NUM_RELEASE | Total releasecall messages sent to message max for SMS-MO prepaid. |
| MO_NUM_SME_FAILURE | Total SMS-MO prepaid messages where the destination SME processing failed. |
| MO_NUM_PREPAID_? | Total SMS-MO prepaid messages per country code. (where ‘?’ is the country code) |
| MO_NUM_BILLED_? | Total successful SMS-MO prepaid messages per country code. (where ‘?’ is the country code) |
| MO_NUM_PREPAID_ALL | Total SMS-MO prepaid messages for all country codes. (only when a country code stat is reported) |
| MO_NUM_BILLED_ALL | Total successful SMS-MO prepaid messages for all country codes. (only when a country code stat is reported) |
SMS-MT
This table describes the available SMS-MT statistics.
| Name | Description |
|---|---|
| NUM_IDP | Total messages processed for both SMS-MO and SMS-MT. |
| MT_NUM_IDP | Total SMS-MT messages processed. |
| MT_NUM_POSTPAID | Total SMS-MT postpaid messages processed. |
| MT_NUM_PREPAID | Total SMS-MT prepaid messages processed. |
| MT_NUM_BILLED | Total successfully billed SMS-MT prepaid messages. |
| MT_NUM_NO_CREDIT | Total SMS-MT messages where the submitter has insufficient balance. |
| MT_NUM_INVALID_BE | Total SMS-MT messages where the submitter is not valid for E2BE. |
| MT_NUM_INVALID_NE | Total SMS-MT messages where the named event is not valid for E2BE. |
| MT_NUM_NO_RULE | Total SMS-MT messages where no rating rule applies. |
| MT_NUM_CONTINUE | Total Continue messages sent to Message Max for SMS-MT prepaid. |
| MT_NUM_RELEASE | Total ReleaseCall messages sent to Message Max for SMS-MT prepaid. |
| MT_NUM_SME_FAILURE | Total SMS-MT prepaid messages where the destination SME processing failed. |
| MT_NUM_PREPAID_?_?? | Total SMS-MT prepaid messages for each ASP Id prefix matched (based on the network calling numbers). (where ‘?’ is the AspId and ‘??’ is the OAdC / network calling number) |
| ASP_?_SUB_OP_CODE | Total P4D messages where MNP wrong network occurred for each AspId. (where ‘?’ is the AspId). |
Statistics by Transaction
MT Transactions
This table indicates which statistics have MT transactions.
| Statistic | TS | NES | NoR | NoC | TF | NEF | NEI | Free |
|---|---|---|---|---|---|---|---|---|
| NUM_IDP | Y | Y | Y | Y | Y | Y | Y | Y |
| MT_NUM_IDP | Y | Y | Y | Y | Y | Y | Y | Y |
| MT_NUM_PREPAID | Y | Y | Y | Y | Y | Y | Y | Y |
| MT_NUM_PREPAID_?_?? (*3) | Y | Y | Y | Y | Y | Y | Y | Y |
| MT_NUM_BILLED | Y | Y | ||||||
| MT_NUM_NO_CREDIT | Y | |||||||
| MT_NUM_INVALID_BE | Y | Y | ||||||
| MT_NUM_INVALID_NE (*2) | Y | Y | ||||||
| MT_NUM_NO_RULE | Y | |||||||
| MT_NUM_CONTINUE | Y | Y | ||||||
| MT_NUM_RELEASE | Y | Y | ||||||
| MT_NUM_SME_FAILURE | Y | Y | ||||||
| MT_NUM_POSTPAID | ||||||||
| ASP_?_SUB_OP_CODE |
MO Transactions
This table indicates which statistics have MO transactions.
| Statistic | TS | NES | NoR | NoC | TF | NEF | NEI | Free |
|---|---|---|---|---|---|---|---|---|
| NUM_IDP | Y | Y | Y | Y | Y | Y | Y | Y |
| MO_NUM_IDP | Y | Y | Y | Y | Y | Y | Y | Y |
| MO_NUM_PREPAID | Y | Y | Y | Y | Y | Y | Y | Y |
| MO_NUM_PREPAID_? (*1) | Y | Y | Y | Y | Y | Y | Y | Y |
| MO_NUM_BILLED | Y | Y | ||||||
| MO_NUM_BILLED_? (*1) | Y | Y | ||||||
| MO_NUM_NO_CREDIT | Y | |||||||
| MO_NUM_INVALID_BE | Y | Y | ||||||
| MO_NUM_INVALID_NE (*2) | Y | Y | ||||||
| MO_NUM_NO_RULE | Y | |||||||
| MO_NUM_CONTINUE | Y | Y | ||||||
| MO_NUM_RELEASE | Y | Y | ||||||
| MO_NUM_SME_FAILURE | Y | Y | ||||||
| MO_NUM_POSTPAID | ||||||||
| MO_NUM_PREPAID_ALL (*1) | Y | Y | Y | Y | Y | Y | Y | Y |
| MO_NUM_BILLED_ALL (*1) | Y | Y |
Transaction key
This table describes Transaction keys.
| Key | Description |
|---|---|
| TS | Successful tariffed transaction. |
| NES | Successful named event transaction. |
| NoR | No tariffing rule fired for this transaction. |
| NoC | Insufficient credit for this transaction. |
| TF | Tariffed transaction failed because SMS not delivered to SME. |
| NEF | Named event transaction failed because SMS not delivered to SME. |
| NEI | Named event transaction where named event is invalid (change tariffing NE config after setting SMCB tariffing). |
| ? | MT: Asp Name, MO: Country Code. |
| ?? | MT: OAdC Number. |
| *1 | Only if not home country code and if registered country code stat found. |
| *2 | Only for named event reservations. |
| *3 | Only if Asp Id is present in IDP. |
SMS Statistics Update
Introduction
The updateStats utility updates the SMS-MO country code and SMS-MT Asp-Id/OAdC statistics in the SMF_STATISTICS_DEFN database table on the SMS machine.
SMS-MO Country Codes
The updateStats utility examines the country codes file (stats/country_codes.txt) to determine which country code statistics to insert into the database, and which to remove.
Note: Statistics that are already present in the database are ignored. Statistics that are present in the database, but are no longer present in the file, are removed.
Statistics are generated and inserted into the database using the following templates:
- MO_NUM_PREPAID_?
- MO_NUM_BILLED_?
where ? is the country code.
SMS-MT Asp-Ids
The updateStats utility examines the Asp Id directory (stats/asp_ids) to determine which Asp-Id and OAdC statistics require inserting into the database.
The name of the Asp-Id file should reflect the name of the Asp. Each Asp-Id file should contain a list of the OAdCs that are associated with that ASP.
Statistics are generated and inserted into the database using the following template:
MT_NUM_PREPAID_?_??
where ? is the Asp Name and ?? is the OAdC.
An additional extractStats utility is provided that migrates an existing set of Asp-Id/OAdC statistics into the new format used by SMCB.
The template used for existing statistics is: ASP_<asp-id> and SMSMT<asp-id>_<oadc>.
Run update stats utility
Follow these steps to run the update statistics utility on the SMS.
| Step | Action |
|---|---|
| 1 | Log in as ccs_oper. |
| 2 |
Change to the SMCB directory, by typing:
|
| 3 |
Type
Follow the on screen prompts for information. Result: This invokes the utility to update the country code and Asp-Id statistics. The statistics that are updated are different depending on your license type. If no updates are required no changes will be made to your system. |
| 4 | For the new stats to become effective the smsStatsDaemon process should be restarted on the SLC. |
Run extract stats utility
Follow these steps to run the extract statistics utility on the SMS.
| Step | Action |
|---|---|
| 1 | Log in as ccs_oper. |
| 2 |
Change to the SMCB directory, by typing:
|
| 3 |
Type:
Follow the on screen prompts for information. Result: This invokes the utility to extract the Asp-Id statistics from an existing database and produces a set of AspId files. This utility only performs changes to your system when your license type allows it. |