List of Predefined Reports

The following section list the reports and descriptions for the categories:

•   Event Summaries

•   Operational Performance

•   Fault Diagnosis

•   Service Level Management

•   Reporter 2.1 Sample Reports and Freeform Reports

Event Summary Reports

Events_by_Node

2D vertical bar chart and supplementary drill-down table displaying the highest event-generating network nodes over a user-specified time period. Identifies active nodes on the network.

Events_by_Class

2D vertical bar chart and supplementary drill-down table displaying the highest event-generating network nodes over a user-specified time period. Identifies high event-generating vendors, equipment and devices.

Events_by_Location

2D vertical bar chart and supplementary drill-down table displaying the highest event-generating network nodes over a user-specified time period. Identifies busiest locations within the network.

Events_by_Manager

2D vertical bar chart and supplementary drill-down table displaying the highest event-generating network nodes over a user-specified time period. Identifies high event-generating management systems.

Events_by_AlertGroup

2D vertical bar chart and supplementary drill-down table displaying the highest event-generating network nodes over a user-specified time period. Identifies most common alert types within the network.

Events_by_Severity

2D vertical bar chart and supplementary drill-down table displaying the highest event-generating network nodes over a user-specified time period. Allows users to assess network activity by severity levels.

Events_by_Time

2D drill-down bar chart tallying events over various time periods, from a year down to a specific day. Allows users to identify trends in network event activity over time (for example, busiest days, alarm patterns).

Events_by_Node_Severity

3D drill-down bar chart describing highest event-generating nodes, broken down by severity level. Allows users to pinpoint the quantity and importance of alarms being generated throughout the network.

Events_by_Location_Severity

3D drill-down bar chart describing the highest event-generating locations, broken down by severity level. Allows users to pinpoint the quantity and importance of alarms being generated throughout the network.

High_Tally_Events

Drill-down table displaying the highest tally event-generating network nodes over a user-specified time period. Allows users to identify the highest tally events at each location.

Operational Performance Reports

Perf_by_Owner

2D vertical bar chart and supplementary drill-down table displaying the number of events handled by network operators (OwnerUID) over a user-specified time period. Assists in scheduling personnel, allocating workload, and planning hiring, training, and resourcing.

Perf_by_Group

2D vertical bar chart and supplementary drill-down table displaying the number of events handled by network operational groups (OwnerGID) over a user-specified time period. Assists in scheduling personnel, allocating workload, and planning hiring, training, and resourcing.

Perf_by_Class

2D vertical bar chart and supplementary drill-down table displaying the number of events generated by specific classes or vendors over a user-specified time period. Assists in correlating event levels with specific equipment types or suppliers.

Perf_by_Manager

2D vertical bar chart and supplementary drill-down table displaying the number of events generated by specific element management systems over a user-specified time period. Assists in correlating event levels with specific equipment types or suppliers.

Perf_by_Owner_Group

3D bar chart and supplementary drill-down table displaying the number of events handled by network operators and operational groups (OwnerUID and OwnerGID) over a user-specified time period. Assists in scheduling personnel, allocating workload, and planning hiring, training, and resourcing.

Fault Diagnosis Reports

Get_All_Journals

Retrieves all journals associated with a specific node. Allows users to track operator actions on specific nodes and devices that have generated events.

Get_All_Details

Retrieves all details associated with a specific node or set of nodes over a user-specified time period. Allows users to track detailed information about specific nodes and devices that have generated events within the specified time interval.

Top_Nodes

Ranks nodes by number of events generated within a user-specified time period, in order to track potentially troublesome nodes or devices.

Top_Classes

Ranks classes by number of events generated within a user-specified time period, in order to track highly active or potentially troublesome classes of devices.

Top_Manager

Ranks managers by number of events generated within a user-specified time period, in order to track highly active or potentially troublesome management systems.

Quick_Check_by_Node

Allows users to manually enter a specific node and retrieve an entire audit trail of data associated with the node.

Quick_Check_by_Serial

Allows users to manually enter a specific, unique serial number and retrieve an entire audit trail of data associated with the node.

Service Level Management Reports

Slow_to_Acknowledge

Identifies all events not acknowledged by operators within a threshold time interval (for example, 30 seconds). Assists network operators and managers in measuring and enhancing responsiveness to service-affecting alarms.

Avg_Ack_Time_by_Owner

Returns average acknowledge times across all owners (OwnerUID) within the network management environment. Assists operators and managers in pinpointing and addressing discrepancies in acknowledge rates across the network.

Avg_Ack_Time_by_Group

Returns average acknowledge times across all groups (OwnerGID) within the network management environment. Assists operators and managers in pinpointing and addressing discrepancies in acknowledge rates across the network.

Reporter 2.1 Sample Reports and Freeform Reports

To access these reports:

1.   Select the My Folders link in the navigation panel.

2.   Select the Reporter 2.1 link in the My Folders section on the My Folders page.

3.   The Reporter 2.1 folder is opened. This folder contains the following sub-folders:

•   Sample Charts

•   Sample Freeform Reports

•   Sample Tabular Reports

•   Supporting Files

Sample Charts

This folder contains lightweight charts (LCharts) generated using the Lightweight Chart Property Designer, with different output types such as Pie, Line, Bar, Stack, Time Series, and so on.

Time Series is new in Reporter 2.1. It looks similar to an ordinary Line chart but with richer formatting options on the X Axis. Only Date type data can be used on the time axis (X Axis).

A listing of the sample lightweight charts is provided below:

•   Event_Detail_Report_All_Loc_Hor_Stack_Lchrt.lcht

Horizontal Stack LChart showing number (count(*)) of events by Manager, by Severity, ordered by count(*) desc. Last 90 days.

•   Event_Detail_Report_All_Loc_Pie_Lchrt.lcht

Pie LChart showing number of events by Original Severity.

Select OriginalSeverity count(*) from REPORTER_STATUS where date >= (getdate-90) group by Original Severity

•   Event_Detail_Report_All_Loc_TimeSeries_Lchrt.lcht

TimeSeries LChart showing number of events per day for last 90 days.

Select date, count(*) from REPORTER_STATUS where date >= (getdate -90) group by day.

•   Event_History_Report_By_Loc_Hor_Stack_Lchrt.lcar

Horizontal Stack LChart showing number (count(*)) of events by Manager, by Severity, ordered by count(*) desc. Last 90 days.

•   Event_History_Report_By_Loc_Pie_Lchrt.lcar

Pie Lchart showing number of events by Original Severity.

Select OriginalSeverity count(*) from REPORTER_STATUS where date >= (getdate-90) group by Original Severity .

•   Event_History_Report_By_Loc_TimeSeries_Lchrt.lcar

TimeSeries LChart showing number of events per day for last 90 days.

Select date, count(*) from REPORTER_STATUS where date >= (getdate -90) group by day.

•   Event_Sources_Report_All_Dev_Hor_Stack_Lchrt.lcht

Horizontal Bar LChart showing number (count(*)) of events by Manager, by Severity, ordered by count(*) desc. Last 30 days.

•   Event_Sources_Report_All_Dev_Pie_Lchrt.lcht

Pie LChart showing number of events by Original Severity.

Select OriginalSeverity count(*) from REPORTER_STATUS where date >= (getdate-30) group by Original Severity

•   Event_Sources_Report_All_Mngrs_Hor_Stack_Lchrt.lcht

Horizontal Bar LChart showing number (count(*)) of events by Manager, by Severity, ordered by count(*) desc. Last 30 days.

•   Event_Sources_Report_All_Mngrs_Pie_Lchrt.lcht

Pie LChart showing number of events by Original Severity.

Select OriginalSeverity count(*) from REPORTER_STATUS where date >= (getdate-30) group by Original Severity

•   Event_Type_Report_All_Loc_Hor_Stack_Lchrt.lcht

Horizontal Stack LChart showing number (count(*)) of events by Manager, by Severity, ordered by count(*) desc. Last 30 days.

•   Event_Type_Reprot_All_Loc_Pie_Lchrt.lcht

Pie LChart showing number of events by Original Severity.

Select OriginalSeverity count(*) from REPORTER_STATUS where date >= (getdate-30) group by Original Severity

•   Event_Volume_Report_All_Dev_Pie_Lchrt.lcht

Pie LChart showing number of events by Original Severity.

Select OriginalSeverity count(*) from REPORTER_STATUS where date >= (getdate-90) group by Original Severity

•   Event_Volume_Report_All_Dev_Stacked_Bar_Lchrt.lcht

Stacked bar LChart showing number of events by Original Seveity per month for last 12 months.

Select month, OriginalSeverity, sum(Tally) from REPORTER_STATUS where date >= (getdate -365) group by month, Original Severity.

•   Event_Volume_Reprot_All_Dev_TimeSeries_Lchrt.lcht

TimeSeries LChart showing number of events per day for last 90 days.

Select date, count(*) from REPORTER_STATUS where date >= (getdate -90) group by day.

•   Event_Volume_Report_All_Dev_TimeSeries_SumTally_Lchrt.lcht

TimeSeries LChart showing number of events per day for last 90 days.

Select date, sum(Tally) from REPORTER_STATUS where date >= (getdate -90) group by day.

•   Event_Volume_Report_By_Mngr_Pie_Lchrt.lcar

Pie LChart showing number of events by Original Severity.

Select OriginalSeverity count(*) from REPORTER_STATUS where date >= (getdate-90) group by Original Severity

•   Event_Volume_Report_By_Mngr_Stacked_Bar_Lchrt.lcar

Stacked bar LChart showing number of events by OriginalSeveity per month for last 12 months.

Select month, OriginalSeverity, sum(Tally) from REPORTER_STATUS where date >= (getdate -365) group by month, Original Severity.

•   Event_Volume_Report_By_Mngr_TimeSeries_Count_Lchrt.lcar

TimeSeries LChart showing number of events per day for last 90 days.

Select date, count(*) from REPORTER_STATUS where date >= (getdate -90) group by day.

 

Sample Freeform Reports

This folder contains various presentations generated using the enhanced Freeform Report Designer. These presentations combine the sample charts, as described in the above section, into Freeform templates. They include:

•   Event_Detail_Report_All_Loc.xml

•   Event_Detail_Report_All_Loc_HTML.xml

•   Event_History_Report_By_Location.xml

•   Event_History_Report_By_Location_HTML.xml

•   Event_Source_Report_All_Dev.xml

•   Event_Source_Report_All_Dev_HTML.xml

•   Event_Source_Report_All_Mngrs.xml

•   Event_Source_Report_All_Mngrs_HTML.xml

•   Event_Type_Report_All_Locations.xml

•   Event_Type_Report_All_Locations_HTML.xml

•   Event_Volume_Report_All_Dev.xml

•   Event_Volume_Report_All_Dev_HTML.xml

•   Event_Volume_Report_By_Mngr.xml

•   Event_Volume_Report_By_Mngr_HTML.xml

Sample Tabular Reports

This folder contains sample (parameterized) tabular reports created using the Report Designer. They include:

•   Event_Detail_Report_All_Loc_Report_Top20.rpt

Table showing top 20 devices (Node) generating alarms in last 90 days. Columns: Node, NodeAlias, sum(Tally), count(*). Top 20 devices are the ones which have the highest sum(Tally).

•   Event_History_Report_By_Loc_Report_Top20.par

Table showing top 20 devices (Node) generating alarms in last 90 days. Columns: Node, NodeAlias, sum(Tally), count(*). Top 20 devices are the ones which have the highest sum(Tally).

•   Event_Sources_Reprot_All_Dev_DrillAcross_Master.rpt

Table showing all devices (Node) generating alarms in last 30 days. Columns: Manager(Break) Node, NodeAlias, sum(Tally), count(*). Drill-across on Node to show the detail report, as described below.

•   Event_Sources_Report_All_Dev_DrillAcross_Detail.par

   Columns: Node, NodeAlias, Summary, AlertKey, AlertGroup, Location, FirstOccurrence, LastOccurrence, Tally, OriginalSeverity. Conditional format on OriginalSeverity(red=5, orange=4, yellow=3, blue=2, purple=1, green=0)

•   Event_Sources_Report_All_Mngrs_DrillAcross_Master.rpt

Table showing all probes (Managers) generating alarms in last 30 days. Columns: Manager(Break), Location, sum(Tally), count(*). Drill-across on Manager to show the detail report, as described below.

•   Event_Sources_Report_All_Mngrs_DrillAcross_Detail.par

   Columes: Node, NodeAlias, Summary, AlertKey, AlertGroup, Location, FirstOccurrence, LastOccurrence, Tally, OriginalSeverity. Conditional format on OriginalSeverity(red=5, orange=4, yellow=3, blue=2, purple=1, green=0)

•   Event_Type_Report_All_Loc_DrillAcross_Master.rpt

Table showing top 20 devices (Node) generating alarms in last 30 days. Columns: Node(break), NodeAlias, sum(Tally), count(*). Top 20 devices are the ones which have the highest sum(Tally). Drill-across on Node to show the detail report, as described below.

•   Event_Type_Report_All_Loc_DrillAcross_Detail.par

   Columns: Node, NodeAlias, Summary, AlertKey, AlertGroup, Location, FirstOccurrence, LastOccurrence, Tally, OriginalSeverity. Conditional format on OriginalSeverity(red=5, orange=4, yellow=3, blue=2, purple=1, green=0)

Supporting Files

This folder contains drill across definitions, lightweight chart property files, and the netcool image which is displayed in the Freeform report output.

•   Event_Horizontal_Stack_Chart.xml

•   Event_Line_Chart.xml

•   Event_Line_Chart_For_sumTally.xml

•   Event_Pie_Chart.xml

•   Event_Stack_Bar.xml

•   Event_Table_Style.xml

•   Event_Table_Style_For_HTML.xml

•   Event_TimeSeries_Chart.xml

•   Event_TimeSeries_Chart_For_sumTally.xml

•   Event_Sources_Report_All_Dev_DrillAcross_xml

•   Event_Sources_Report_All_Mngrs_DrillAcross_xml

•   Event_Type_Report_All_Loc_DrillAcross_xml

•   netcool_soution