UIM CABI Report Time Zone configuration

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We are using CABI to generate reports and we observed that in the report It is showing the wrong time zone.

How can we configure the timezone that shows in jasperserver reports / CABI Reports? 

 

Environment

Release : UIM 20.x , Cabi all versions

Cause

Guidance

Resolution

In general, the timezones on Jasperserver (CABi) reports are managed within the configuration mentioned in this useful wiki Jasperserver document: Localizing Reports in TIBCO JasperReports® Server with respect to time zones | Jaspersoft Community Community

 

However, without changing any configuration, so, regardless of the timezone set on the DB/CABI Server itself, the UIM or CABI User using the CABIjs application can localize his timezone by selecting the time zone before logging in. 

 

Before logging in, please select the timezone:

 

If your preferred timezone is not listed there, you can add it by following the instruction on the above Jaspersoft Wiki link at section "2 Setting the database time zone:Setting the database time zone:"

 

For the UIM version of Jasperserver would be: 

 

Go to : C:\Program Files (x86)\Nimsoft\probes\service\wasp\webapps\cabijs\WEB-INF\

open "applicationContext.xml" with a text editor

 

Find the section below and add the time zone

In this example we are adding the timezone for Turkey (GMT+3): "<value>Etc/GMT-3</value>"

 

</beans>
    <beans profile="engine">
    <bean id="userTimeZonesList" class="com.jaspersoft.jasperserver.war.common.JdkTimeZonesList">
        <property name="timeZonesIds">
            <list>
                 <value>Europe/Bucharest</value>
                 <value>Etc/GMT+3</value>
                 <value>Australia/Canberra</value>
                 <value>Etc/GMT-3</value>
                 <value>Europe/Minsk</value>
            </list>
        </property>
    </bean>
</beans>

 

* The list of tz timezones can be found here: List of tz database time zones - Wikipedia
** The Timezone must be copied from what is listed in that "TZ Database Name" in the list in the wikipedia article

 

 

A restart of the CABI Robot is needed to make the change effective. 

 

 

Example of Group Trend Report showing Turkey time: 

 

Additional Information

Related KB: Bulk Update of CABI Reports Schedules via REST API (broadcom.com)