20120712_guide kpi crbt and smsc report

KPI REPORTS DESCRIPTION: SMSC / CRBT

JOAO MAPISSE OPERATION & MAINTENANCE DEPARTMENT

OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

Table of Contents

Overview ....................................................................................................................................................... 1

1. KPI CRBT REPORTS .......................................................................................................................... 1

2.1. CAPACITY ................................................................................................................................... 2

2.2. NETWORK QUALITY .............................................................................................................. 13

2. KPI SMSC REPORTS ........................................................................................................................ 15

1.1. CAPACITY ................................................................................................................................. 15

1.2. PERFORMANCE ....................................................................................................................... 18

KPI REPORTS DESCRIPTION: CRBT


OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

1 | P a g e

Overview

Key Performance Indicators

Key Performance Indicators (KPIs) is a key for organizations understand how well they are

performing in relation to their strategic goals and objectives. It also involves the understanding

for stakeholders.

1. KPI CRBT REPORTS

The KPI CRBT reports into two parts:

The capacity: that is possible to monitor the capacity of the CBRT system, and

The Network Quality: that is possible to get the quality of the network in terms of calls.



OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

2 | P a g e

2.1. CAPACITY

In the capacity we find five parameters:

Register subscribers in day (subs)



OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

3 | P a g e

Deregister subscribers in day (subs)

Total tone download in day (times)

Total subscribers (subs)

CAPS peak in BH

Subs utilization (%)

CAPS utilization (%)

CPU (%), Memory Ratio, CPU_CCU/CSU(%) of boards

To get the



OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

4 | P a g e

Register subscribers in day (subs)

Deregister subscribers in day (subs)

Total tone download in day (times)

Total subscribers (subs)

Go to http://10.229.110.200/ and click in Report link of [CRBT] as below

Login to the system report

Username/password: nocmvt/nocmvt

Click in the report as below



OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

5 | P a g e

a) Register/ Deregister subscribers in day (subs),

Proceed as the figure below, and generate the tables:

b) Total subscribers (subs)



OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

6 | P a g e

After generate the table, choose the

For Total tone download in day (times)



OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

7 | P a g e

CAPS (Call Attempt per second) peak in BH

To get the CAPS peak, we have to go to the HUAWEI URP Performance Management

System.



OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

8 | P a g e

Login



OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

9 | P a g e

Operator Name/Password: nocmvt/Nocmovitel123

(2) from the (1). In the next step we choose the Time

type, Start and End Time, as showed in the Figure below.



OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

10 | P a g e

After that the system generates the table below.

Right click on the table to Save it as name

Use to get the CAPS

CPU (%), Memory Ratio (%), CPU_CCU/CSU(%) of boards



OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

11 | P a g e

The CPU and Memory Ratio for

Portal 1

Portal 2

USDP 1

USDP 2

DB1A

DB1B

CTI1

CTI2

VXML1

VXML2

UI 1

We get by accessing to the I2000

User Name/Password: nocmov/vasocs123



OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

12 | P a g e

Go to the menu choosing the . Expand the

correspondent parameter (CPU or Memory Ratio) and by right click in the corresponding area

choosing the option (2) as the Figure below.

New windows will open, so we have to (1) to choose the Data

Setting(2). After choosing the Start and End date (for one day we choose from 00:00Hr to

23:00Hr) we (3) the data.

Right click, as showed bellow and save with filename < CPU_CCU_Usage.csv >



OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

13 | P a g e

For Memory Ratio follow as the same but choose first in

menu. Save it with filename < VAS_MEM.csv >

Use the < CPUandMEM_UsageMACRO.xlsx > macro to get the data.

2.2. NETWORK QUALITY

To the NETWORK QUALITY we get the ratio between Call Connected (times) and Call

Attempt (times) for all Movitel MSCs (MSMP01, MSNP01, MSNP02) to get the quality of all

Network. These parameters are:

Call Attempt (times)

Call Connected (times)

Login to the HUAWEI URP Performance Management System and (2) from the < MSC_Direction >. Choose the Time type, Start and End Time, as

explained above.



OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

14 | P a g e

Right click on the table to save it. Open the < crbtDIRECTION_MACRO.xlsx> file

and copy all sheet to the < CALL DIRECTION> worksheet tab. In the

worksheet tab you can get the call direction for all MSCs.



OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

15 | P a g e

2. KPI SMSC REPORTS

The KPI SMSC reports in Movitel are composed by two parts:

The capacity: that is possible to monitor the capacity of the SMSC system, and

The Performance: that measures the system performance

1.1. CAPACITY

In the capacity we find five parameters:

MO (traffic in BH - SMS/second);

MT (traffic in BH - SMS/second);

CPU (%);

Memory Usage;

SMs in the cacheDeamon;

MO / MO license (%);



OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

16 | P a g e

MT / MT license (%).

To get these parameters we go to the SMSC web interface accessed by address:

10.229.110.10:28080

In the tab (1) choose the (2) Menu and then the (3).

In the KPI Report tag (4), we select the SMSC List, choose the statistic mode, the start

and end time and the rows per page, as showed in figure below.

As the result we get the table with the parameters:

CPU Usage: CPU (%)

Memory Usage:

Number of SMs in the L2CacheDaemon: SMs in the cacheDeamon

For :



OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

17 | P a g e

MO (traffic in BH - SMS/second);

MT (traffic in BH - SMS/second);

In tab choose the (1) Menu and then the (2).

After select the SMSC, start and end times, choose the statistic mode as , as showed in figure below

As the result we get the table below, where we have to export and save it in the harddisk,

in the same folder as the MACRO file with name < Total_Statistics_Report.xls >



OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

18 | P a g e

After that use the MACRO file to get the MO (traffic in BH - SMS/second) and MT

(traffic in BH - SMS/second). Dont forget to open the filename

Total_Statistics_Report.xls

1.2. PERFORMANCE

In the performance we find the parameters for MO and MT messages, where we can get

the total, the success, fail and errors.

To get the number of errors follow as showe:



OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

19 | P a g e

For MO errors types:



OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

20 | P a g e

Will open the fields

For MT errors types:



OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

21 | P a g e

Will open the fields



OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

22 | P a g e

To get the number of MO and MT messages follow as showed below:

For MO Attempts and delivered:



OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

23 | P a g e

Export



OCSVAS DIVISION

CREATED: 14/02/2012 UPDATED: 12/07/2012

24 | P a g e

For MT Attempts and delivered:

20120712_guide kpi crbt and smsc report

Documents

kpi crbt reports

kpi smsc reports

day subs total tone

g e register subscribers

report link of crbt

bh subs utilization

network quality

caps utilization