Link Detailed Report Script

Asset ID:	1-72-2173091.1
Update Date:	2017-11-27
Keywords:

Solution Type Problem Resolution Sure

Solution 2173091.1 : Link Detailed Report Script

Applies to:

Oracle Communications Performance Intelligence Center (PIC) Software - Version 10.1.5 and later
Information in this document applies to any platform.

Symptoms

There are 3 changes in the CCM report in release 10.1.5 compared to the one from 6.6.4:

NSP Overview sheet is not available in the new reports, which contains session and mapped dataflows
Header issue in "SS7 Linksets" sheet
Link details missing in "SS7 Linksets" sheet

Cause

N/A

Solution

Use following script until the bug 24384216 is fixed. This script provides a link view of the Config Report and the Link Detail Report Analysis scripts.

Config Report Script

Download the script from this location: Config Report Script.

Deployment instructions

Copy this script in the Oracle home directory in the NSP Oracle server.

unzip ConfigReport.zip

Usage

At the sqlplus prompt type:

@ConfigReport.sql

After script execution is complete, navigate to the following directory:

/var/log/nsp

The generated file is named

LinkDetailReport.csv

Link Detail Report Analysis Script

Download the script from this location: Link Detail Report Analysis Script.

Deployment instructions

Copy this script in the Oracle home directory in the NSP Oracle server.

unzip LinkDetailReportAnalysis.zip
chmod 555 LinkDetailReportAnalysis.pl

Usage

Note: This script is Customized for TNS report output.

Run the script against the SQL script csv output:

./LinkDetailReportAnalysis.pl /var/log/nsp/LinkDetailReport.csv > /var/log/nsp/LinkDetailAnalysisReport.csv

Transfer the csv file from the NSP/Oracle Server to a PC in binary mode.

PC <-[Binary Transfer]- NSP/Oracle

Open the csv file in Excel and format the data.

Home Tab -> Format Table As -> pick table format.
View Tab -> Freeze Pane -> Freeze Top Row
Select Column A through the last column (maybe Column AG).
Home Tab -> Format -> Autofit Column Width
Resize any session columns that wrap an _1 from the end of the name to the next line.
Home Tab -> Format -> Autofit Row Height
View Tab -> View -> 80%
Office Button -> Save File As a Excel Workbook

References

<BUG:24384216> - CCM CONFIG REPORT

Attachments

This solution has no attachment