Network Performance Server (NPS) System Timezone Configuration

  • KM01772077
  • 05-Aug-2015
  • 05-Aug-2015


The following document contains some considerations when changing the Default Time Zone for Reports in HP Network Node Manager (NNMi) iSPI Performance for Metrics.


When a report is run how would that affect the report which uses Time-based query ?
How does HP Network Performance Server (NPS) store metrics data? Specifically how does it store the date time values ?
If NPS is storing the data in Greenwich Mean Time (GMT), which field or column could be use/check to be able to query data and filter it out based on a particular timezone ?


By default NNM iSPI Performance for Metrics reports select data using “Server Time” which is NPS server time and not the Cognos servertime. The Cognos server timezone has no impact on report outputs, it is only applicable to report scheduling. If reports are needed for different timezones, the required timezone need to be selected from the time control page. There is no way the Cognos timezone setting can be used for reports.
Default reports do not create direct queries for different time-zones, they create the quieries in a particular format which has the hint which column should be used for querying. The dbproxy process does the same.
Query studio/custom reports are not able to report on different time-zones because those columns are not available in the Cognos model.
In order to create a Structured Query Language (SQL) command  to fetch the data directly from the database for any timezone, the best way to know which column should be queried is the following:
(1)  Run any report after changing the timezone to the required timezone in the time control page.
For changing timezone please refer to:
a. iSPI Metrics Deployment by Example
Scheduling 45
b. iSPI Metrics Online Help
Time Changes and Time 61
(2)   Check $NPSDataDir/logs/dbproxy.log for the query and column name.
(3)  Please refer to the following example how Cognos creates the query(INCOMING Query), and how it is replaced by the timezone column name in the OUTGOING Query.
Hint provided by Cognos query is marked in yellow in the incoming query and replaced timezone column is marked in Green in outgoing query.
INCOMING Query buffer:
---------------------------------------------------------------------- "T0"."C0" "TimeSamples" , "T0"."C1" "agg_metric1" , "T0"."C1" "metric_y1_2" , "T0"."C1" "metric_y1_3" , "T0"."C1" "metric_y1_4" , "T0"."C1" "metric_y1_5" , "T0"."C1" "metric_y1_6" , "T0"."C2" "agg_metric2" , "T0"."C2" "metric_y2_2" , "T0"."C2" "metric_y2_3" , "T0"."C2" "metric_y2_4" , "T0"."C2" "metric_y2_5" , "T0"."C2" "metric_y2_6"  from (select "f_Virtual_ComponentMetrics"."5 Minute" "C0" , avg("f_Virtual_ComponentMetrics"."Memory Utilization (avg)") "C1" , avg("f_Virtual_ComponentMetrics"."CPU 1min Utilization (avg)") "C2"  from "DBA"."f_Virtual_ComponentMetrics" "f_Virtual_ComponentMetrics" where hp_relativeTimerangeFilter('f_Virtual_ComponentMetrics', 'd_Component_Health_Time', '300', '3600', '0', '0', PADDING_PADDING_PADDING_PADDING_PADDING_PADDING_PADDING_PADDING_PADDING_PADDING_PADDING_PADDING_
"f_Virtual_ComponentMetrics"."UserTZName" = 'America/New_York' group by "f_Virtual_ComponentMetrics"."5 Minute") "T0" order by 1 asc .........@..................
OUTGOING Query buffer:
---------------------------------------------------------------------- "T0"."C0" "TimeSamples" , "T0"."C1" "agg_metric1" , "T0"."C1" "metric_y1_2" , "T0"."C1" "metric_y1_3" , "T0"."C1" "metric_y1_4" , "T0"."C1" "metric_y1_5" , "T0"."C1" "metric_y1_6" , "T0"."C2" "agg_metric2" , "T0"."C2" "metric_y2_2" , "T0"."C2" "metric_y2_3" , "T0"."C2" "metric_y2_4" , "T0"."C2" "metric_y2_5" , "T0"."C2" "metric_y2_6"  from (select "fv_Raw_ComponentMetrics"."5MINVB"      "C0" , avg("fv_Raw_ComponentMetrics"."Memory Utilization (avg)"   ) "C1" , avg("fv_Raw_ComponentMetrics"."CPU 1min Utilization (avg)"   ) "C2"  from "DBA"."fv_Raw_ComponentMetrics"    "fv_Raw_ComponentMetrics"    where "5MINVB"   >= ( select dateadd(SECOND,-3600,max("5MINVB"  )) from "v_Component_Health_Time" ) AND "5MINVB"   < ( select max("5MINVB"  ) from "v_Component_Health_Time" ) and "fv_Raw_ComponentMetrics"."one"    = 1   group by "fv_Raw_ComponentMetrics"."5MINVB"     ) "T0" order by 1 asc .........@..................