Truesight Middleware and Transaction Management: Last day or last hour of query time frame appears to be missing from report

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    TrueSight Middleware Monitor


    COMPONENT:

    BMC Middleware and Transaction Management


    APPLIES TO:

    TrueSight Middleware Monitor TrueSight Middleware Transaction Monitor BMC Middleware and Transaction Management BMC Middleware Management - Performance and Availability BMC Middleware Management - Transaction Monitoring



    PROBLEM:

    Last day or last hour of query time frame appears to be missing from report

    Example 1:
    Report Resolution: Day
    Query time frame: Mar. 1st to Mar. 31st
    Resulting report ends on Mar. 30th

    Example 2:
    Report Resolution: Hour
    Query time frame: 09:00:00 am to 12:00:00 pm
    Resulting report ends at 11:00 am
     


    CAUSE:

    On reports with a resolution of "Day", the provided time is ignored and always set to "00:00:00" (12am). The same applies to reports with a resolution of hour. The minutes and seconds are always replaced with "00:00"


    SOLUTION:

    For reports with a resolution of "Day", set the end date to one day after the actually desired end date.

    For reports with a resolution of "Hour", set the end time to one hour after the actually desired end time 
     


    Article Number:

    000133627


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles