SGM Statistics Export File Formats

Table Of Contents

SGM Statistics Export File Formats

SGM Custom Network Statistics Export File Formats

SGM Daily and Hourly Accounting Statistics Export File Format

SGM Link Statistics Daily Export File Format

SGM Link Statistics Hourly Export File Format

SGM Linkset Statistics Daily Export File Format

SGM Linkset Statistics Hourly Export File Format

SGM Point Code Inventory Export File Format

SGM Rolling Network Statistics Export File Formats

SGM Statistics Export File Formats

---

This appendix lists the formats for the following SGM statistics export files:

•SGM Custom Network Statistics Export File Formats

•SGM Daily and Hourly Accounting Statistics Export File Format

•SGM Link Statistics Daily Export File Format

•SGM Link Statistics Hourly Export File Format

•SGM Linkset Statistics Daily Export File Format

•SGM Linkset Statistics Hourly Export File Format

•SGM Point Code Inventory Export File Format

•SGM Rolling Network Statistics Export File Formats

SGM Custom Network Statistics Export File Formats

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

•The export file for a custom accounting statistics report uses the same format as the daily and hourly accounting statistics report export file, as shown in the "SGM Daily and Hourly Accounting Statistics Export File Format" section.

•The export file for a custom link statistics summary report uses the same format as the daily link statistics report export file, as shown in the "SGM Link Statistics Daily Export File Format" section.

•The export file for a custom linkset statistics summary report uses the same format as the daily linkset statistics report export file, as shown in the "SGM Linkset Statistics Daily Export File Format" section.

SGM Daily and Hourly Accounting Statistics Export File Format

Export files for SGM daily and hourly accounting statistics reports use the following format:

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

# Format of Accounting Statistics Daily and Hourly Files:

#   Any value = 999.2 means a math error occurred

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

# Field Variable                         Description

# ----------------------------------------------------------------

#  1  Row Id

#  2  Calendar Date in Excel Import Format

#  3  Calendar Date Good for Sorting

#  4  Node Name

#  5  Linkset Name                Name of Linkset

#  6  ACL Test                    Passed or Failed

#  7  DPC                         Destination Point Code

#  8  OPC                         Originating Point Code

#  9  SI                          Service Indicator

#  10 Received MSUs               Number of MSUs sent this period

#  11 Sent MSUs                   Number of MSUs received this period

#  12 Received Bytes              Number of bytes sent this period

#  13 Sent Bytes                  Number of bytes received this period

#  14 Node DisplayName            Display Name of Node from SGM Server

#  15 Linkset DisplayName         Display Name of Linkset from ITP

#  16 Period                      Length of this period in seconds

#  17 Day String                  Textual value for day. Sun, Mon, etc

#  18 Node SGMId                  Internal Id of node in SGM server

#  19 Version                     File version

#  20 Signaling Point Name        Name of Signaling Point from ITP

#  21 Signaling Point SGMId       Internal Id of SP in SGM server

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

SGM Link Statistics Daily Export File Format

Export files for SGM daily link statistics summary reports use the following 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  Row Id

#  2  Calendar Date in Excel Import Format

#  3  Calendar Date Good for Sorting

#  4  Node Name

#  5  Linkset Name                Val cItpSpLinksetName

#  6  SLC                         Val cItpSpLinkSlc

#  7  Node DisplayName            Display Name of Node from SGM Server

#  8  Link DisplayName            Val cItpSpLinkDisplayName

#  9  Link Type (integer)         Val cItpSpLinkType

#  10 Link Type (text)

#  11 MIB-II ifIndex of link. Serial/HSL Only.

#  12 Plan send capacity of link in bits/sec.

#                                 Val cItpSpLinkPlanCapacitySent

#  13 Plan receive capacity of link in bits/sec.

#                                 Val cItpSpLinkPlanCapacityRcvd

#  14 MIB-II ifSpeed of link. Serial/HSL Only. In bits/sec.

#  15 Hours in Day with Data

#  16 Day String

#  17 DailyAvgSndU

#  18 DailyAvgRcvU

#  19 PeakSndU

#  20 PeakSndHour

#  21 PeakRecvU

#  22 PeakRecvHour

#  23 TotSendMSUs - In Kilos

#  24 TotRecvMSUs - In Kilos

#  25 Drops

#  26 DailyAvgInSrv

#  27 LowInSrv

#  28 LowHour

#  29 LTAvgInSrv

#  30 LTAvgSndU

#  31 LTAvgRcvU

#  32 Node SGMId

#  33 Version

#  34 Signaling Point Name

#  35 Signaling Point SGMId

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

SGM Link Statistics Hourly Export File Format

Export files for SGM hourly link statistics reports use the following format:

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

# Format of Link Statistics Hourly Export File:

#   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  Row Id

#  2  Calendar Date in Excel Import Format

#  3  Calendar Date Good for Sorting

#  4  Node Name

#  5  Linkset Name                Val cItpSpLinksetName

#  6  SLC                         Val cItpSpLinkSlc

#  7  Node DisplayName            Display Name of Node from SGM Server

#  8  Link DisplayName            Val cItpSpLinkDisplayName 

#  9  Link Type (integer)         Val cItpSpLinkType

#  10 Link Type (text)

#  11 MIB-II ifIndex of link. Serial/HSL Only.

#  12 Plan send capacity of link in bits/sec.

#                                 Val cItpSpLinkPlanCapacitySent

#  13 Plan receive capacity of link in bits/sec.

#                                 Val cItpSpLinkPlanCapacityRcvd

#  14 MIB-II ifSpeed of link. Serial/HSL Only. In bits/sec.

#  15 Length of this period in seconds

#  16 Day String

#  17 Send utilization this time period.     In Erlangs, not percent.

#  18 Average send utilization since reboot. In Erlangs, not percent.

#  19 Recv utilization this time period.     In Erlangs, not percent.

#  20 Average recv utilization since reboot. In Erlangs, not percent.

#  21 Number of MTP3 MSUs sent     this period

#  22 Number of MTP3 MSUs received this period

#  23 Number of drops this period

#  24 Percentage of time in service this period

#  25 Avg Percentage of time in service since reboot

#     or last counter wrap

#  26 Percentage of time out of service this period

#  27 Avg Percentage of time out of service since reboot

#     or last counter wrap

#  28 Number of MTP3 Bytes sent this period

#  29 Number of MTP3 Bytes received this period

#  30 Node SGMId

#  31 Version

#  32 Signaling Point Name

#  33 Signaling Point SGMId

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

SGM Linkset Statistics Daily Export File Format

Export files for SGM daily linkset statistics summary reports use the following format:

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

# Format of Linkset Statistics Daily Export File:

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

# Field Variable                         Description

# ----------------------------------------------------------------

#  1  Row Id

#  2  Calendar Date in Excel Import Format

#  3  Calendar Date Good for Sorting

#  4  Node Name

#  5  Linkset Name                Val cItpSpLinksetName

#  6  Node DisplayName            Display Name of Node from SGM Server

#  7  Linkset DisplayName

#  8  Hours

#  9  DayStr

#  10 DailyAvgInSrv

#  11 LowInSrv

#  12 LowHour

#  13 LTAvgInSrv

#  14 NodeSGMId

#  15 Version

#  16 Signaling Point Name

#  17 Signaling Point SGMId

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

SGM Linkset Statistics Hourly Export File Format

Export files for SGM hourly linkset statistics reports use the following format:

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

# Format of Linkset Statistics Hourly Export File:

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

# Field Variable                         Description

# ----------------------------------------------------------------

#  1  Row Id

#  2  Calendar Date in Excel Import Format

#  3  Calendar Date Good for Sorting

#  4  Node Name

#  5  Linkset Name                Val cItpSpLinksetName

#  6  Node DisplayName            Display Name of Node from SGM Server

#  7  Linkset DisplayName         Val cItpSpLinksetDisplayName 

#  8  Length of this period in seconds

#  9  Day String

#  10 Percentage of time in service this period

#  11 Avg Percentage of time in service since reboot

#  12 Percentage of time out of service this period

#  13 Avg Percentage of time out of service since reboot

#  14 Node SGMId

#  15 Version

#  16 Signaling Point Name

#  17 Signaling Point SGMId

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

SGM Point Code Inventory Export File Format

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

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

# Format of Point Code Inventory Export File:

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

#  PointCode,NodeName,NodeDisplayName,PCType,SGMId

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

SGM Rolling Network Statistics Export File Formats

Export files for 7-day and 30-day rolling network statistics reports use the same format as the corresponding link and linkset statistics reports:

•The export file for a 7-day link statistics summary report uses the same format as the hourly link statistics report export file, as shown in the "SGM Link Statistics Hourly Export File Format" section.

•The export file for a 7-day linkset statistics summary report uses the same format as the hourly linkset statistics report export file, as shown in the "SGM Linkset Statistics Hourly Export File Format" section.

•The export file for a 30-day link statistics summary report uses the same format as the daily link statistics report export file, as shown in the "SGM Link Statistics Daily Export File Format" section.

•The export file for a 30-day linkset statistics summary report uses the same format as the daily linkset statistics report export file, as shown in the "SGM Linkset Statistics Daily Export File Format" section.