User Guide for the Cisco Mobile Wireless Transport Manager 6.0
Archived Reports File Formats

Table Of Contents

Archived Reports File Formats

ITP Specific Archived Reports File Formats

Application Server Process Statistics Daily and Peaks Daily Format

Application Server Process Statistics Hourly Format

Application Server Process Statistics MTP3 Daily and MTP3 Peaks Daily Format

Application Server Statistics Daily and Peaks Daily Format

Application Server Statistics Hourly Format

GTT Accounting Statistics Daily Format

Link Statistics Daily and Peaks Daily Format

Link Statistics Hourly Format

Link Statistics Multi Day Format

Linkset Statistics Daily and Peaks Daily Format

Linkset Statistics Hourly Format

MLR Aborts and Continues Daily Format

MLR Processed Statistics Daily Format

MLR Result Invokes Statistics Daily Format

MLR Rule Matches Statistics Daily Format

MLR SubTriggers Daily Format

MLR Triggers Daily Format

MSU Rates Load and Peaks Reports Format

MTP3 Accounting Statistics Daily Format

MTP3 Events Hourly Format

Point Code Inventory Format

Q.752 Link Statistics Hourly Format

Custom Network Reports File Formats

Rolling Network Reports File Formats

RAN-O Specific Archived Reports File Formats

Capacity Summary Backhaul Reports

Capacity Summary Shorthaul Reports

Minimum Capacity Backhaul Reports

Average Capacity Backhaul Reports

Maximum Capacity Backhaul Reports


Archived Reports File Formats


This appendix contains this content:

ITP Specific Archived Reports File Formats

RAN-O Specific Archived Reports File Formats

ITP Specific Archived Reports File Formats

This section lists the formats for these Cisco IP Transfer Point (ITP) specific archived reports files:

Application Server Process Statistics Daily and Peaks Daily Format

Application Server Process Statistics Hourly Format

Application Server Process Statistics MTP3 Daily and MTP3 Peaks Daily Format

Application Server Statistics Daily and Peaks Daily Format

Application Server Statistics Hourly Format

GTT Accounting Statistics Daily Format

Link Statistics Daily and Peaks Daily Format

Link Statistics Hourly Format

Link Statistics Multi Day Format

Linkset Statistics Daily and Peaks Daily Format

Linkset Statistics Hourly Format

MLR Aborts and Continues Daily Format

MLR Processed Statistics Daily Format

MLR Result Invokes Statistics Daily Format

MLR Rule Matches Statistics Daily Format

MLR SubTriggers Daily Format

MLR Triggers Daily Format

MSU Rates Load and Peaks Reports Format

MTP3 Accounting Statistics Daily Format

MTP3 Events Hourly Format

Point Code Inventory Format

Q.752 Link Statistics Hourly Format

Custom Network Reports File Formats

Rolling Network Reports File Formats

Application Server Process Statistics Daily and Peaks Daily Format

Archived reports for the Cisco Mobile Wireless Transport Manager (MWTM) daily and peaks daily application server process statistics reports use this format:

# =================================================================================
# Format of ASP Statistics Daily Archived Reports:
#   Any value = 999.2 means a math error occurred
# =================================================================================

# Field Variable                         Description
# ---------------------------------------------------------------------------------
#  1  Id
#  2  Date                               Calendar date in Excel import format
#  3  Sort Date                          Calendar date good for sorting
#  4  Node 
#  5  ASP Name                           Val cItpXuaAspName
#  6  Node Disp Name                     Display name of node from MWTM server
#  7  Hours                              Hours in day with data
#  8  Day Str                            Day string
#  9  Tot Pkts From Asp                  In kilos
#  10 Tot Pkts To Asp                    In kilos
#  11 Tot Pkts From Mtp3                 In kilos
#  12 Tot Pkts To Mtp3                   In kilos
#  13 Tot Errors Sent                    In kilos
#  14 Tot Errors Rcvd                    In kilos
#  15 Hourly Avg Pkts From Asp           Average hourly value
#  16 Hourly Avg Pkts To Asp             Average hourly value
#  17 Hourly Avg Pkts From Mtp3          Average hourly value
#  18 Hourly Avg Pkts To Mtp3            Average hourly value
#  19 Hourly Avg Errors Sent             Average hourly value
#  20 Hourly Avg Errors Rcvd             Average hourly value
#  21 Peak Pkts From Asp
#  22 Peak Pkts From Asp Hour
#  23 Peak Pkts To Asp
#  24 Peak Pkts To Asp Hour
#  25 Peak Pkts From Mtp3
#  26 Peak Pkts From Mtp3 Hour
#  27 Peak Pkts To Mtp3
#  28 Peak Pkts To Mtp3 Hour
#  29 Peak Errors Sent
#  30 Peak Errors Sent Hour
#  31 Peak Errors Rcvd
#  32 Peak Errors Rcvd Hour
#  33 Node SGM Id
#  34 SP Name
#  35 SP SGM Id
#  36 AS Parent
#  37 Ver
# =================================================================================

Application Server Process Statistics Hourly Format

Archived reports for the MWTM hourly application server process statistics reports use this format:

# =================================================================================
# Format of ASP Statistics Hourly Archived Reports:
#   Any value = 999.2 means a math error occurred
# =================================================================================

# Field Variable                               Description
# ---------------------------------------------------------------------------------
#  1  Id
#  2  Date                                     Calendar date in Excel import format
#  3  Sort Date                                Calendar date good for sorting
#  4  Node 
#  5  ASP Name                                 Val cItpXuaAspName
#  6  Period                                   Length of this period in seconds
#  7  Day Str                                  Day string
#  8  Pkts From Asp                            Number of packets from ASP this period
#  9  Pkts To Asp                              Number of packets to ASP this period
#  10 Pkts From Mtp3                           Number of packets from MTP3 this period
#  11 Pkts To Mtp3                             Number of packets to MTP3 this period
#  12 Errors Sent                              Number of errors sent this period
#  13 Errors Rcvd                              Number of errors received this period
#  14 Node Disp Name                           Display name of node from MWTM server
#  15 Node SGM Id
#  16 SP Name
#  17 SP SGM Id
#  18 AS Parent                                Parent AS name
#  19 Ver                                      File version
#  20 UPACKs Sent 
#  21 UPs Rcvd 
#  22 DNACKs Sent 
#  23 DNs Rcvd
#  24 ACACKs Sent
#  25 ACs Rcvd
#  26 IAACKs Sent
#  27 IAs Rcvd
#  28 Notifys Sent
#  29 DUNAs Sent
#  30 DUNAs Rcvd 
#  31 DAVAs Sent
#  32 DAVAs Rcvd
#  33 DUPUs Sent 
#  34 DUPUs Rcvd
#  35 DAUDs Sent 
#  36 DAUDs Rcvd 
# =================================================================================

Application Server Process Statistics MTP3 Daily and MTP3 Peaks Daily Format

Archived reports for the MWTM Message Transfer Part level 3 (MTP3) daily and MTP3 peaks daily application server statistics reports use this format:

# =================================================================================
# Format of AS Statistics MTP3 Daily Archived Reports:
# =================================================================================

# Field Variable                         Description
# ---------------------------------------------------------------------------------
#  1  Id
#  2  Date                               Calendar date in Excel import format
#  3  Sort Date                          Calendar date good for sorting
#  4  Node
#  5  ASP Name                           Val cItpXuaAspName
#  6  Node Disp Name                     Display name of node from MWTM server
#  7  Hours                              Hours in day with data
#  8  Day Str                            Day string
#  9  Tot Pkts From Mtp3                 In kilos
#  10  Tot Pkts To Mtp3                  In kilos
#  11 Tot Errors Sent                    In kilos
#  12 Tot Errors Rcvd                    In kilos
#  13 Hourly Avg Pkts From Mtp3          Average hourly value
#  14 Hourly Avg Pkts To Mtp3            Average hourly value
#  15 Hourly Avg Errors Sent             Average hourly value
#  16 Hourly Avg Errors Rcvd             Average hourly value
#  17 Peak Pkts From Mtp3
#  18 Peak Pkts From Mtp3 Hour
#  19 Peak Pkts To Mtp3 
#  20 Peak Pkts To Mtp3 Hour
#  21 Peak Errors Sent
#  22 Peak Errors Sent Hour
#  23 Peak Errors Rcvd
#  24 Peak Errors Rcvd Hour
#  25 Node SGM Id
#  26 SP Name
#  27 SP SGM Id
#  28 AS Parent
#  29 Ver
# =================================================================================

Application Server Statistics Daily and Peaks Daily Format

Archived reports for the MWTM application server daily and peaks daily statistics reports use this format:

# =================================================================================
# Format of AS Statistics Daily Archived Reports:
# =================================================================================

# Field Variable                         Description
# ---------------------------------------------------------------------------------
#  1  Id
#  2  Date 
#  3  Sort Date 
#  4  Node 
#  5  AS Name                            Val cItpXuaAsName
#  6  Node Display Name                  Display name of node from MWTM server
#  7  Hours in Day with Data             Hours in day with data
#  8  Day Str                            Day string
#  9  TotPktsFromMtp3                    In kilos
#  10 TotPktsToASPsOfAs                  In kilos
#  11 HourlyAvgPktsFromMtp3              Average hourly value
#  12 HourlyAvgPktsToASPsOfAs            Average hourly value
#  13 PeakPktsFromMtp3
#  14 PeakPktsFromMtp3Hour
#  15 PeakPktsToASPsOfAs
#  16 PeakPktsToASPsOfAsHour
#  17 Node SGM Id
#  18 SP Name
#  19 SP SGM Id
#  20 Ver
# =================================================================================

Application Server Statistics Hourly Format

Archived reports for the MWTM hourly application server statistics reports use this format:

# =================================================================================
# Format of AS Statistics Hourly Archived Reports:
# =================================================================================

# Field Variable                               Description
# ---------------------------------------------------------------------------------
#  1  Id
#  2  Date
#  3  Sort Date
#  4  Node
#  5  AS Name                                  Val cItpXuaAsName
#  6  Period
#  7  Day Str
#  8  PktsFromMtp3 this period
#  9  PktsToASPsOfAs this period
#  10 Node Display Name                        Display name of node from MWTM server
#  11 Node SGM Id
#  12 SP Name
#  13 SP SGM Id
#  14 Ver
# =================================================================================

GTT Accounting Statistics Daily Format

Archived reports for the MWTM daily Global Title Translation (GTT) accounting statistics reports use this format:

# =================================================================================
# Format of GTT Accounting Statistics Daily Archived Reports:
#   Any value = 999.2 means a math error occurred
# =================================================================================

# Field Variable                         Description
# ---------------------------------------------------------------------------------
#  1  Id
#  2  Date
#  3  Sort Date
#  4  Node
#  5  Linkset                           Name of linkset
#  6  Sel Name                          Name of Global Title Selector
#  7  GTA                               Name of Global Title Address
#  8  PC                                    Translated point code
#  9  Diff Packets                          Number of translated packets
#  10 Diff Octets                           Number of translated octets
#  11 Node Disp Name                        Display name of node from MWTM server
#  12 Linkset Disp Name                     Display name of linkset from ITP device
#  13 Period                                Length of this period in seconds
#  14 Day Str                               Textual value for day (Sun, Mon, etc.)
#  15 Node SGM Id                           Internal ID of node in MWTM server
#  16 Ver                                   File version
#  17 SP Name
#  18 SP SGM Id
#  19 To Instance                           Instance in which the translated PC resides
# =================================================================================

Link Statistics Daily and Peaks Daily Format

Archived reports for the MWTM link daily and peaks daily statistics summary reports use this format:

# =================================================================================
# Format of Link Statistics Daily Export File:
#   Any value = 999.1 means link capacity not set
#   Any value = 999.2 means a math error occurred
# =================================================================================

# Field Variable                    Description
# ---------------------------------------------------------------------------------
#  1  Id
#  2  Date
#  3  Sort Date
#  4  Node
#  5  Linkset                       Val cItpSpLinksetName
#  6  SLC                           Val cItpSpLinkSlc
#  7  Node Disp Name                Display name of node from MWTM server
#  8  Link Disp Name                Val cItpSpLinkDisplayName
#  9  Type 
#  10 Type Str
#  11 ifIndex
#  12 Send Cap                      Plan send capacity of link in bits/sec.
#  13 Recv Cap                      Plan receive capacity of link in bits/sec.
#  14 if Speed                      MIB-II ifSpeed of link. Serial/HSL only, in bits/sec.
#  15 Hours 
#  16 Day Str
#  17 Daily Avg Snd U
#  18 Daily Avg Rcv U
#  19 Peak Snd U
#  20 Peak Snd Hour
#  21 Peak Recv U
#  22 Peak Recv Hour
#  23 Tot Send MSUs - In Kilos
#  24 Tot Recv MSUs - In Kilos
#  25 Drops
#  26 Daily Avg In Srv
#  27 Low In Srv
#  28 Low Hour
#  29 LT Avg In Srv
#  30 LT Avg Snd U
#  31 LT Avg Rcv U
#  32 Node SGM Id
#  33 Ver
#  34 SP Name
#  35 SP SGM Id
#  36 Avg Cong
#  37 Peak Congest
#  38 Peak Cong Hour
# =================================================================================

Link Statistics Hourly Format

Archived reports for the MWTM hourly link statistics reports use this format:

# =================================================================================
# Format of Link Statistics Hourly Archived Reports:
#   Possible values of Link Type are:
#   other(1),serial(2),sctpIp(3),hsl(4)
#   Any value = 999.1 means link capacity not set
#   Any value = 999.2 means a math error occurred
# =================================================================================

# Field Variable                      Description
# ---------------------------------------------------------------------------------
#  1  Id
#  2  Date
#  3  Sort Date
#  4  Node
#  5  Linkset                         Val cItpSpLinksetName
#  6  SLC                             Val cItpSpLinkSlc
#  7  Node Disp Name                  Display name of node from MWTM server
#  8  Link Disp Name                  Val cItpSpLinkDisplayName 
#  9  Type (integer)                  Val cItpSpLinkType
#  10 Type Str (text)
#  11 ifIndex                         MIB-II ifIndex of link. Serial/HSL only.
#  12 SendCap                         Plan send capacity of link in bits/sec.      
#  13 RecvCap                         Plan receive capacity of link in bits/sec.
#  14 ifSpeed                         MIB-II ifSpeed of link. Serial/HSL only. 
                                      In bits/sec.
#  15 Period
#  16 Day Str
#  17 Send Erl                        Send utilization this time period. In Erlangs, 
                                      not percent.
#  18 LT Send Erl                     Long-Term Average send utilization. In Erlangs, 
                                      not percent.
#  19 Recv Erl                        Recv utilization this time period. In Erlangs, 
                                      not percent.
#  20 LT Recv Erl                     Long-Term Average receive utilization. In Erlangs, 
                                      not percent.
#  21 Sent MSU                        Number of MTP3 MSUs sent this period
#  22 Recv MSU                        Number of MTP3 MSUs received this period
#  23 Drops                           Number of drops this period
#  24 In Ser                          Percentage of time in service this period
#  25 Avg In Serv                     Average percentage of time in service since reboot 
                                      or last counter wrap
#  26 Out Ser                         Percentage of time out of service this period
#  27 Avg Out Ser                     Average percentage of time out of service since 
                                      reboot or last counter wrap
#  28 Sent MTP3 Bytes                 Number of MTP3 bytes sent this period
#  29 Recv MTP3 Bytes                 Number of MTP3 bytes received this period
#  30 Node SGM Id
#  31 Ver
#  32 SP Name
#  33 SP SGM Id
#  34 Percent Con                     Percentage of time in congestion this period
# =================================================================================

Link Statistics Multi Day Format

Archived reports for the MWTM multi day link statistics reports use this format:

# =================================================================================
# Format of Link Statistics Multi Day Archived Reports:
#   Any value = 999.1 means link capacity not set
#   Any value = 999.2 means a math error occurred
# =================================================================================
# Field Variable                                Description
# ---------------------------------------------------------------------------------
#  1  ID
#  2  Node
#  3  Linkset
#  4  SLC	                                      Val cItpSpLinkSlc
#  5  Node Disp Name                            Display name of node from MWTM server
#  6  Link Disp Name                            Val cItpSpLinkDisplayName
#  7  Type (integer)                            Val cItpSpLinkType
#  8  Type Str (text)                           Serial/HSL only.
#  9  ifIndex
#  10 Send Cap                                  Plan send capacity of link in bits/sec.
#  11 Recv Cap                                  Plan receive capacity of link in bits/sec.
#  12 ifSpeed                                   Serial/HSL only. In bits/sec.
#  13 Hours                                     Hours in day with data
#  14 Node SGM Id                               Internal ID of node in SGM server
#  15 Ver                                       File version
#  16 SP Name	                                  Signaling point name
#  17 SPSGM Id
#  18 AvgSendUtil-YYYY-MM-DD	                  For a 3 day report
#  19 AvgReceiveUtil-YYYY-MM-DD                  For a 3 day report
#  20 AvgSendUtil-YYYY-MM-DD                     For a 3 day report
#  21 AvgReceiveUtil-YYYY-MM-DD                  For a 3 day report
#  22 AvgSendUtil-YYYY-MM-DD                     For a 3 day report
#  23 AvgReceiveUtil-YYYY-MM-DD                  For a 3 day report
#  24 AvgSendUtil-YYYY-MM-DD                     For a 5 day report
#  25 AvgReceiveUtil-YYYY-MM-DD                  For a 5 day report
#  26 AvgSendUtil-YYYY-MM-DD                     For a 5 day report
#  27 AvgReceiveUtil-YYYY-MM-DD                  For a 5 day report
# =================================================================================

Linkset Statistics Daily and Peaks Daily Format

Archived reports for the MWTM daily and peaks daily linkset statistics summary reports use this format:

# =================================================================================
# Format of Linkset Statistics Daily Archived Reports:
# =================================================================================

# Field Variable                       Description
# ---------------------------------------------------------------------------------
#  1  Id
#  2  Date
#  3  Sort Date
#  4  Node
#  5  Linkset                          Val cItpSpLinksetName
#  6  Node Disp Name                   Display name of node from MWTM server
#  7  Linkset Disp Name
#  8  Hours
#  9  Day Str
#  10 Daily Avg In Srv
#  11 Low In Srv
#  12 Low Hour
#  13 LT Avg In Srv
#  14 Node SGM Id
#  15 Ver
#  16 SP Name
#  17 SP SGM Id
#  18 Daily Avg Snd U
#  19 Daily Avg Rcv U
#  20 Peak Snd U
#  21 Peak Snd Hour
#  22 Peak Recv U
#  23 Peak Recv Hour
#  24 LT Avg Snd U
#  25 LT Avg Rcv U
# =================================================================================

Linkset Statistics Hourly Format

Archived reports for the MWTM hourly linkset statistics reports use this format:

# =================================================================================
# Format of Linkset Statistics Hourly Archived Reports:
# =================================================================================

# Field Variable                           Description
# ---------------------------------------------------------------------------------
#  1  Id
#  2  Date
#  3  Sort Date
#  4  Node
#  5  Linkset                              Val cItpSpLinksetName
#  6  Node Disp Name                       Display name of node from MWTM server
#  7  Linkset Disp Name                    Val cItpSpLinksetDisplayName 
#  8  Period
#  9  Day Str
#  10 In Ser                               Percentage of time in service this period 
#  11 Avg In Serv                          Average percentage of time in service 
                                           since reboot
#  12 Out Ser                              Percentage of time out of service this period
#  13 Avg Out Serv                         Average percentage of time out of service 
                                           since reboot
#  14 Node SGM Id
#  15 Ver
#  16 SP Name
#  17 SP SGM Id
#  18 Send Erl                             Send utilization this time period. In Erlangs, 
                                           not percent.
#  19 Recv Erl                             Recv utilization this time period. In Erlangs, 
                                           not percent.
#  20 LT Send Erl                          Long-Term average send utilization. In Erlangs, 
                                           not percent.
#  21 LT Recv Erl                          Long-Term average recv utilization. In Erlangs, 
                                           not percent.
# =================================================================================

MLR Aborts and Continues Daily Format

Archived reports for the MWTM multilayer routing (MLR) daily aborts and continues statistics reports use this format:

# =================================================================================
# Format of MLR Aborts/Continues Stats Daily Archived Reports:
#   Signaling Point Level Statistics
#   Any value = 999.2 means a math error occurred
# =================================================================================

# Field Variable                         Description
# ---------------------------------------------------------------------------------
#  1  Id
#  2  Date
#  3  Sort Date
#  4  Node
#  5  Diff Unsup Type                    MSUs returned to SCCP due to unsupported msg type
#  6  Diff Unsup Seg                     MSUs returned to SCCP due to unsupported segment
#  7  Diff Unsup Msg                     MSUs returned to SCCP due to unsupported message
#  8  Diff Parse Error                   MSUs returned to SCCP due to parse error
#  9  Diff No Result                     MSUs returned to SCCP with no result
#  10 Diff Result Cont                   MSUs returned to SCCP with continue result
#  11 Diff No Svr Cont                   MSUs returned to SCCP due to no available server
#  12 Diff Result GTT                    MSUs returned to SCCP with GTT result
#  13 Diff No Resources                  MSUs not processed due to resource shortage
#  14 Diff Result Block                  MSUs not processed due to block result
#  15 Diff GTIM is                       MSUs not processed due to mismatched GTI
#  16 Diff No Addv Conv                  MSUs not processed due to GTA address conversion
#  17 Diff No Dest                       MSUs not processed due to destination PC unavail
#  18 Diff Failed Trigger                MSUs returned to SCCP due to no trigger match
#  19 Diff Routed                        Number of times a packet was routed by MLR
#  20 Diff Continue                      MSUs passed back to SCCP processing
#  21 Diff Abort                         MSUs not processed due to invalid data or a 
                                         blocked MSU
#  22 Diff No Svr Discard                MSUs not processed due to no available server 
#  23 Node Disp Name                     Display name of node from MWTM server
#  24 Period                             Length of this period in seconds
#  25 Day Str                            Textual value for day (Sun, Mon, etc.)
#  26 Node SGM Id                        Internal ID of node in MWTM server
#  27 Ver                                File version
#  28 SP Name                            Display name of signaling point
#  29 SP SGM Id                          Internal ID of signaling point in MWTM server
# =================================================================================

MLR Processed Statistics Daily Format

Archived reports for the MWTM MLR daily processed statistics reports use this format:

# =================================================================================
# Format of MLR Processed Statistics Daily Archived Reports:
#   Signaling Point Level Statistics
#   Any value = 999.2 means a math error occurred
# =================================================================================

# Field Variable                        Description
# ---------------------------------------------------------------------------------
#  1  Id
#  2  Date
#  3  Sort Date
#  4  Node
#  5  Diff Routed                       Number of times a packet was routed by MLR
#  6  Diff Continue                MSUs passed back to SCCP processing
#  7  Diff Abort                   MSUs not processed due to invalid data or a blocked MSU
#  8  Diff SMS MO                  Number of MSUs of type GSM-MAP SMS-MO
#  9  Diff SMS MT                  Number of MSUs of type GSM-MAP SMS-MT
#  10 Diff SRI SM                  Number of MSUs of type GSM-MAP SRI-SM
#  11 Diff Alert                   Number of MSUs of type GSM-MAP AlertSc
#  12 Diff SMD PP                  Number of MSUs of type ANSI-41 SMD-PP
#  13 Diff SMS REQ                 Number of MSUs of type ANSI-41 SMSRequest
#  14 Diff SMS Notify              Number of MSUs of type ANSI-41 SMSNotify
#  15 Node Disp Name               Display name of node from MWTM server
#  16 Period                       Length of this period in seconds
#  17 Day Str                      Textual value for day (Sun, Mon, etc.)
#  18 Node SGM Id                  Internal ID of node in MWTM server
#  19 Ver                          File version
#  20 SP Name                      Display name of signaling point
#  21 SP SGM Id                    Internal ID of signaling point in MWTM server
# =================================================================================

MLR Result Invokes Statistics Daily Format

Archived reports for the MWTM MLR daily result invokes statistics reports use this format:

# =================================================================================
# Format of MLR Result Invokes Statistics Daily Archived Reports:
#   Any value = 999.2 means a math error occurred
# =================================================================================

# Field Variable                         Description
# ---------------------------------------------------------------------------------
#  1  Id
#  2  Date
#  3  Sort Date
#  4  Node
#  5  Result set Name                    
#  6  Result Num                         Number of results within the result set
#  7  Diff Invoke            
#  8  Node Disp Name                     Display name of node from MWTM server
#  9  Period                             Length of this period in seconds
#  10 Day Str                            Textual value for day (Sun, Mon, etc.)
#  11 Node SGM Id                        Internal ID of node in MWTM server
#  12 Ver                                File version
#  13 SP Name                            Display name of signaling point
#  14 SP SGM Id                          Internal ID of signaling point in MWTM server
# =================================================================================

MLR Rule Matches Statistics Daily Format

Archived reports for the MWTM MLR daily rule matches statistics reports use this format:

# =================================================================================
# Format of MLR Rule Matches Statistics Daily Archived Reports:
#   Any value = 999.2 means a math error occurred 
# =================================================================================

# Field Variable                         Description
# ---------------------------------------------------------------------------------
#  1  Id
#  2  Date
#  3  Sort Date
#  4  Node
#  5  Ruleset Name                         
#  6  Rule Num                             Number of rules within the ruleset
#  7  Diff Match            
#  8  Node Disp Name                       Display name of node from MWTM server
#  9  Period                               Length of this period in seconds
#  10 Day Str                              Textual value for day (Sun, Mon, etc.)
#  11 Node SGM Id                          Internal ID of node in MWTM server
#  12 Ver                                  File version 
#  13 SP Name                              Display name of signaling point
#  14 SP SGM Id                            Internal ID of signaling point in MWTM server
# =================================================================================

MLR SubTriggers Daily Format

Archived reports for the MWTM MLR daily subtrigger statistics reports use this format:

# ==============================================================================
# Format of MLR SubTrigger Stats Daily Archived Reports:
#   Any value = 999.2 means a math error occurred
# ==============================================================================

# Field Variable                      Description
# ------------------------------------------------------------------------------
#  1  Id
#  2  Date
#  3  Sort Date
#  4  Node
#  5  Table Name                      Name for this collection of MLR configs
#  6  Trigger Num                     Index number for parent trigger statement
#  7  Sub Trigger Num                 Index number for each subtrigger statement
#  8  Action                          Action taken by the subtrigger
#  9  Params Str                      Parameters that control the trigger
#  10 Diff Match                
#  11 Node Disp Name                  Display name of node from MWTM server
#  12 Period                          Length of this period in seconds
#  13 Day Str                         Textual value for day (Sun, Mon, etc.)
#  14 Node SGM Id                     Internal ID of node in MWTM server
#  15 Ver                             File version
#  16 SP Name                         Display name of signaling point
#  17 SP SGM Id                       Internal ID of signaling point in MWTM server
# ================================================================================

MLR Triggers Daily Format

Archived reports for the MWTM MLR daily trigger statistics reports use this format:

# =================================================================================
# Format of MLR Trigger Stats Daily Archived Reports:
#   Any value = 999.2 means a math error occurred
# =================================================================================

# Field Variable                           Description
# ---------------------------------------------------------------------------------
#  1  Id
#  2  Date
#  3  Sort Date
#  4  Node
#  5  Table Name                           Name for this collection of MLR configs
#  6  Trigger Num                          Index number for each trigger statement
#  7  Action                               Action taken by the trigger
#  8  Params Str                        Parameters that control the trigger
#  9  Active                            Determines whether trigger is active
#  10 Diff Prel Match                   Preliminary count of trigger matches
#  11 Diff Match                     
#  12 Node Disp Name                    Display name of node from MWTM server
#  13 Period                            Length of this period in seconds
#  14 Day Str                           Textual value for day (Sun, Mon, etc.)
#  15 Node SGM Id                       Internal ID of node in MWTM server
#  16 Ver                               File version
#  17 SP Name                           Display name of signaling point
#  18 SP SGM Id                         Internal ID of signaling point in MWTM server
# =================================================================================

MSU Rates Load and Peaks Reports Format

Archived reports for the MWTM message signal units (MSU) load and peaks daily, hourly, and 15 minute reports use this format:

# =================================================================================
# Format of MSU Load and Peaks Archived Reports:
# =================================================================================

# Field Variable                              Description
# ---------------------------------------------------------------------------------
#  1  id
#  2  time Stamp		                            Database time stamp value
#  3  node Id	                               Internal MWTM node ID
#  4  node Name  
#  5  node Display Name
#  6  processor Slot Number                  Contains the processor for which this record 
                                             contains data
#  7  processor Bay Number                   Contains the processor for which this record
                                             contains data
#  8  acceptable Threshhold                  Level of traffic below which traffic is 
                                             acceptable
#  9  warning Threshold                      Level of traffic is above acceptable level 
                                             but below a level that impacts MSU routing
#  10 overloaded Threshold                   Level of traffic indicating a rate that may 
                                             impact MSU routing
#  11 reset Timestamp                     
#  12 send Duration Warning                  Number of seconds rate state is warning
#  13 send Duration Overloaded               Number of seconds rate state is overloaded
#  14 send Max Rate                          Maximum value of send rate since time 
                                             specified
#  15 send Max Timestamp                     Time and date when send max rate was last 
                                             sent
#  16 send Dur 00 to 09 Percent              Total number of seconds when the MSU rate for 
                                             this processor was x-x percent of the current 
                                             overloaded threshold value.
#  17 send Dur 10 to 19
#  18 send Dur 20 to 29 Percent     
#  19 send Dur 30 to 39 Percent     
#  20 send Dur 40 to 49 Percent     
#  21 send Dur 50 to 59 Percent     
#  22 send Dur 60 to 69 Percent     
#  23 send Dur 70 to 79 Percent     
#  24 send Dur 80 to 89 Percent 
#  25 send Dur 90 or Above
#  26 receive Duration Warning                Number of seconds the rate state is warning
#  27 receive Duration Overloaded             Number of seconds the rate state is 
                                              overloaded
#  28 receive Max Rate                           Maximum value of receive rate since time 
                                                 specified
#  29 receive Max Timestamp                      Time and date when receive max rate was 
                                                 last set
#  30 receive Dur 00 to 09 Percent               Total number of seconds when the MSU rate 
                                                 for this processor was x-x percent of the 
                                                 current overloaded threshold value.
#  31 receive Dur 10 to 19
#  32 receive Dur 20 to 29 Percent     
#  33 receive Dur 30 to 39 Percent     
#  34 receive Dur 40 to 49 Percent     
#  35 receive Dur 50 to 59 Percent     
#  36 receive Dur 60 to 69 Percent     
#  37 receive Dur 70 to 79 Percent     
#  38 receive Dur 80 to 89 Percent 
#  39 receive Dur 90 or Above

# =================================================================================

MTP3 Accounting Statistics Daily Format

Archived reports for the MWTM daily MTP3 accounting statistics reports use this format:

# =================================================================================
# Format of MTP3 Accounting Statistics Daily Archived Reports:
#   Any value = 999.2 means a math error occurred
# =================================================================================

# Field Variable                         Description
# ---------------------------------------------------------------------------------
#  1  Id
#  2  Date
#  3  Sort Date
#  4  Node
#  5  Linkset                            Name of Linkset
#  6  ACL Test                           Passed, failed, or unroutable
#  7  DPC                                Destination point code
#  8  OPC                                Originating point code
#  9  SI                                 Service indicator
#  10 Diff Rcvd MSUs                     Number of MSUs sent this period
#  11 Diff Sent MSUs                     Number of MSUs received this period
#  12 Diff Rcvd Bytes                    Number of bytes sent this period
#  13 Diff Sent Bytes                    Number of bytes received this period
#  14 Node Disp Name                     Display name of node from MWTM server
#  15 Linkset Disp Name                  Display name of linkset from ITP
#  16 Diff Up Time
#  17 Day Str                            Textual value for day (Sun, Mon, etc.)
#  18 Node SGM Id                        Internal ID of node in MWTM server
#  19 Ver                                File version
#  20 SP Name                            Name of signaling point from ITP
#  21 SP SGM Id                          Internal ID of signaling point in MWTM server
# =================================================================================

MTP3 Events Hourly Format

Archived reports for the MWTM hourly MTP3 event reports use this format:


# ================================================================
# Format of MTP3 Events Hourly Archived Reports:
# ================================================================
# Field Variable                         Description
# ----------------------------------------------------------------
#  1  ID
#  2  Date                               Calendar date in Excel import format
#  3  Sort Date                          Calendar date good for sorting
#  4  Node 
#  5  Index
#  6  Event Msg 
#  7  Node Disp Name                     Display name of node from SGM server
#  8  Node SGM Id                        Internal ID of node in SGM server
#  9  Day Str                            Day string
#  10 Ver                                File version
# =============================================================================

Point Code Inventory Format

Archived reports for the MWTM point code inventory reports are comma-separated value (CSV) text files. Each line of the file has this format:

# =================================================================================
# Format of Point Code Inventory Archived Reports:
# =================================================================================

# Field Variable                               Description
# ---------------------------------------------------------------------------------
#  1  Sig Point
#  2  Point Code
#  3  Node Name
#  4  Node Display Name
#  5  PC Type                 
#  6  SGM Id
# =================================================================================

Q.752 Link Statistics Hourly Format


Note Q.752 link statistics archived reports are not available through the MWTM web interface. You can access these reports in the /opt/CSCOsgm/reports/exporthourly directory on your server.


Archived reports for the MWTM hourly Q.752 link statistics reports use this format:

# =================================================================================
# Format of Q752 Link Statistics Hourly Archived Reports:
# Possible values of Link Type are:
#        other(1),serial(2),sctpIp(3),hsl(4),virtual(5)
#   Any value = 999.2 means a math error occurred

# =================================================================================

# Field Variable                               Description
# ---------------------------------------------------------------------------------
#  1  Id
#  2  Date
#  3  Sort Date
#  4  Node
#  5  cgspLinksetName                  
#  6  cgspLinkSlc
#  7  cgspLinkType (integer)
#  8  cgspLinkType (text)
#  9  cgspLinkifIndex
#  10 cgspLinkQ752T1E1                         Number in this period               
#  11 cgspLinkQ752T1E2                         
#  12 cgspLinkQ752T1E3                         
#  13 cgspLinkQ752T1E4*                        
#  14 cgspLinkQ752T1E5                         
#  15 cgspLinkQ752T1E6*                        
#  16 cgspLinkQ752T1E7                         
#  17 cgspLinkQ752T1E8                         
#  18 cgspLinkQ752T1E9                         
#  19 cgspLinkQ752T1E10                        
#  20 cgspLinkQ752T1E11                        
#  21 cgspLinkQ752T2E1                         
#  22 cgspLinkQ752T2E2*                        
#  23 cgspLinkQ752T2E3*                        
#  24 cgspLinkQ752T2E4*                        
#  25 cgspLinkQ752T2E5                         
#  26 cgspLinkQ752T2E6                         
#  27 cgspLinkQ752T2E7                         
#  28 cgspLinkQ752T2E8*                        
#  29 cgspLinkQ752T2E9                         
#  30 cgspLinkQ752T2E10                        
#  31 cgspLinkQ752T2E11*                       
#  32 cgspLinkQ752T2E12*                       
#  33 cgspLinkQ752T2E13*                       
#  34 cgspLinkQ752T2E14*                       
#  35 cgspLinkQ752T2E15                        
#  36 cgspLinkQ752T2E16                        
#  37 cgspLinkQ752T2E17*                       
#  38 cgspLinkQ752T2E18                        
#  39 cgspLinkQ752T2E19*                       
#  40 cgspLinkQ752T3E1                         
#  41 cgspLinkQ752T3E2Bytes                    
#  42 cgspLinkQ752T3E3                         
#  43 cgspLinkQ752T3E4                        
#  44 cgspLinkQ752T3E5                         
#  45 cgspLinkQ752T3E6                         
#  46 cgspLinkQ752T3E7                        
#  47 cgspLinkQ752T3E8*                        
#  48 cgspLinkQ752T3E9*                        
#  49 cgspLinkQ752T3E10L                       Number in this period - Sum of L1-L3
#  50 cgspLinkQ752T3E11L                       Number in this period - Sum of L1-L3
#  51 Period
#  52 Ver
#  53 Day Str
#  54 Node Disp Name
#  55 Node SGM Id
#  56 SP Name (PointCode:cgspInstNetwork)
#  57 SP SGM Id
# =================================================================================

Note Fields marked with an asterisk (*) are unsupported.


Custom Network Reports File Formats

Archived reports for custom network statistics reports use the same format as the corresponding accounting, link, and linkset statistics reports:

The archived reports for a custom GTT accounting statistics report uses the same format as the daily GTT accounting statistics report, as shown in GTT Accounting Statistics Daily Format.

The archived reports for a custom MLR aborts and continues statistics report uses the same format as the daily MLR aborts and continues statistics report, as shown in MLR Aborts and Continues Daily Format.

The archived reports for a custom MLR processed statistics report uses the same format as the daily MLR processed statistics report, as shown in MLR Processed Statistics Daily Format.

The archived reports for a custom MLR subtriggers statistics report uses the same format as the daily MLR subtriggers statistics report, as shown in MLR SubTriggers Daily Format.

The archived reports for a custom MLR triggers statistics report uses the same format as the daily MLR triggers statistics report, as shown in MLR Triggers Daily Format.

The archived reports for a custom MTP3 accounting statistics report uses the same format as the daily MTP3 accounting statistics report, as shown in MTP3 Accounting Statistics Daily Format.

The archived reports for a custom MTP3 events report uses the same format as the hourly MTP3 events report, as shown in MTP3 Events Hourly Format.

The archived reports for a custom application server accounting statistics summary report uses the same format as the hourly application server accounting statistics report, as shown in Application Server Statistics Hourly Format.

The archived reports for a custom application server process accounting statistics summary report uses the same format as the hourly application server process accounting statistics report, as shown in Application Server Process Statistics Hourly Format.

The archived reports for a custom link statistics summary report uses the same format as the hourly link statistics report, as shown in Link Statistics Hourly Format.

The archived reports for a custom linkset statistics summary report uses the same format as the hourly linkset statistics report, as shown in Linkset Statistics Hourly Format.

Rolling Network Reports File Formats

Archived reports for 7-day and 30-day rolling network statistics reports use the same format as the corresponding link, linkset, application server, and application server process statistics reports:

Report Type
Format

7-day:

Link statistics summary

Linkset statistics summary

Application server summary

Application server process summary

Link Statistics Hourly Format

Linkset Statistics Hourly Format

Application Server Statistics Hourly Format

Application Server Process Statistics Hourly Format

30-day:

Link statistics summary

Linkset statistics summary

Application server summary

Application server process summary

Link Statistics Daily and Peaks Daily Format

Linkset Statistics Daily and Peaks Daily Format

Application Server Statistics Daily and Peaks Daily Format

Application Server Process Statistics Daily and Peaks Daily Format


RAN-O Specific Archived Reports File Formats

This section lists the formats for these RAN-O specific archived reports files:

Capacity Summary Backhaul Reports

Capacity Summary Shorthaul Reports

Minimum Capacity Backhaul Reports

Average Capacity Backhaul Reports

Maximum Capacity Backhaul Reports

Capacity Summary Backhaul Reports

Archived reports for the MWTM backhaul daily, hourly, and 15 minutes capacity summary data use this format:

# ====================================================================
# Format of Backhaul Capacity Summary Archived Reports
#
#
# Field Variables                      Description
# 
------------------------------------------------------------------------------------------
# 1  Title                             Report title
# 2  Object                            Object path
# 3  Report Version                        
# 4  Start Date
# 5  End Date 
# 6  Type                             
# 7  Errors Timestamp 
# 8  Total Errors 
# 9  Send Minimum Timestamp 
# 10 Send Total Minimum 
# 11 Send Average Timestamp 
# 12 Send Total Average 
# 13 Send Maximum Timestamp 
# 14 Send Total Maximum 
# 15 Receive Minimum Timestamp
# 16 Receive Total Minimum
# 17 Receive Average Timestamp
# 18 Receive Total Average
# 19 Receive Maximum Timestamp
# 20 Receive Total Maximum

Capacity Summary Shorthaul Reports

Archived reports for the MWTM shorthaul daily, hourly, and 15 minutes capacity summary data use this format:

# ====================================================================
# Format of Shorthaul Capacity Summary Archived Reports
#
#
# Field Variables                      Description
# 
------------------------------------------------------------------------------------------
# 1  Title                             Report title
# 2  Object                            Object path
# 3  Report Version
# 4  Start Date
# 5  End Date 
# 6  Send Minimum Timestamp 
# 7  Send Minimum
# 8  Send Average
# 9  Send Maximum Timestamp
# 10 Send Maximum
# 11 Receive Minimum Timestamp
# 12 Receive Minimum
# 13 Receive Average Timestamp
# 14 Receive Average
# 15 Receive Maximum Timestamp
# 16 Receive Maximum

Minimum Capacity Backhaul Reports

Archived reports for the MWTM daily, hourly, and 15 minutes minimum capacity data use this format:

# ====================================================================
# Format of Backhaul Minimum Capacity Archived Reports
#
#
# Field Variables                      Description
# 
------------------------------------------------------------------------------------------
# 1  Title                             Report title
# 2  Object                            Object path
# 3  Report Version                        
# 4  Start Date
# 5  End Date
# 6  Name
# 7  Type                             
# 8  Send Minimum Timestamp 
# 9  Send Minimum
# 10 Receive Minimum Timestamp
# 11 Receive Minimum 

Average Capacity Backhaul Reports

Archived reports for the MWTM daily, hourly, and 15 minutes average capacity data use this format:

# ====================================================================
# Format of Backhaul Average Capacity Archived Reports
#
#
# Field Variables                      Description
# 
------------------------------------------------------------------------------------------
# 1  Title                             Report title
# 2  Object                            Object path
# 3  Report Version                        
# 4  Start Date
# 5  End Date
# 6  Name
# 7  Type                             
# 8  Timestamp 
# 9  Send Average
# 10 Receive Average

Maximum Capacity Backhaul Reports

Archived reports for the MWTM daily, hourly, and 15 minutes maximum capacity data use this format:

# ====================================================================
# Format of Backhaul Maximum Capacity Archived Reports
#
#
# Field Variables                      Description
# 
------------------------------------------------------------------------------------------
# 1  Title                             Report title
# 2  Object                            Object path
# 3  Report Version                        
# 4  Start Date
# 5  End Date
# 6  Name
# 7  Type                             
# 8  Send Maximum Timestamp 
# 9  Send Maximum
# 10 Receive Maximum Timestamp
# 10 Receive Maximum