Hi Donald,

If you don't mind, I have two questions here regarding to database report:
(1) For node availability report, I also find something strange. This year node Availability is all 100%, although this month one is not. It doesn't make sense either, does it?

I have captured SQL statements from report.log for both reports. Those look similar except for the time range, which looks OK as well:
This month:

EXTRACT( epoch from ( 'Wed Feb 1 00:00:00 +0800 2012'::TIMESTAMP +
CAST( EXTRACT( DAY FROM 'Wed Feb 15 00:00:00 +0800 2012'::TIMESTAMP) ||
' days' as interval ) - 'Wed Feb 1 00:00:00 +0800 2012'::TIMESTAMP ) ) AS avail_total,

This year:

EXTRACT( epoch from ( 'Sun Jan 1 00:00:00 +0800 2012'::TIMESTAMP +
CAST( EXTRACT( DAY FROM 'Wed Feb 15 00:00:00 +0800 2012'::TIMESTAMP) ||
' days' as interval ) - 'Sun Jan 1 00:00:00 +0800 2012'::TIMESTAMP ) ) AS avail_total,

However, for this year, the result set of column duration_tally and average_duration are all 0; while for this month they have values. For the value of avail_total, both are 1296000.

How do you explain this? Pls take note one thing: my testing NMS was installed this month.

(2) The second one is about snmp interface availability: the report gives me negative percentage. Does it make sense? I have yet to study its SQL query.

Thx.

Best Regards
dj

It happens to many report sub-report templates. Is it right to change all of them?

I found out where it comes from and why just using the START_TIME would solve the issue. Turns out that the START_TIME_STRING uses a SimpleDateFormat object to format the date into a SQL friendly timestamp. In doing so it uses the following template.

"EEE MMM F HH:mm:ss Z yyyy"

The problem with that format is that the F stands for "Day of Week in Month" and not the actual "Day in Month". Change it to the following template and it should resolve the matter.

"EEE MMM d HH:mm:ss Z yyyy"

I will go ahead and update the report accordingly. Thanks again.

In SQL statement of the report template, replacing DS_START_TIME_STRING with DS_START_TIME will solve my problem. The side effect is hour and minute inputs no longer work.

The html input box "Report Time Range in Days" and drop-down list hour and minute work, but not the input box "Start Date".