Application Perf Mgmt (BAC / BSM) Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

[OMi] - Event Time is different after exporting to excel.

SOLVED
Go to solution
Highlighted
SB_RRK
Frequent Visitor

[OMi] - Event Time is different after exporting to excel.

 

When I export the event to Excel, I see the time changes i.e. -6 hours.

 

Any advise?

5 REPLIES
Riya_Roy
Occasional Visitor
Solution

Re: [OMi] - Event Time is different after exporting to excel.

:) faced same few months back :)

nothing to worry :) time you are getting is GMT .
At that time I added GMT + 05. 30 for IST for my timezone.
Regards,
Riya Roy

Ship in harbor is safe -- but that is not what ships are built for …
SK_AmidamarU
Regular Collector

Re: [OMi] - Event Time is different after exporting to excel.


SB_RRK wrote:

 

When I export the event to Excel, I see the time changes i.e. -6 hours.

 

Any advise?


Hi,

 

Start from the BSM menu itself. Login with the user you use to navigate in BSM web interface. Go to Admin > Personal Settings > User Account. Under section "Personal Settings", check the "Time zone" field, if it is the right one.

You can also try to change it, hit Apply and Logout/Login. Test the export option one more time. Does that make a difference?

 

 

BR,

Stanislav

SB_RRK
Frequent Visitor

Re: [OMi] - Event Time is different after exporting to excel.

Hi Riya,

 

Is this in the user profile in BSM?

I have checked & the time is +5:30 Calcutta.

 

You mean should that be set up 00:00GMT

Polter
Frequent Visitor

Re: [OMi] - Event Time is different after exporting to excel.

Yes Riya is correct, as data is coming directly from DB, so u are getting GMT time instead of custom time.
Riya_Roy
Occasional Visitor

Re: [OMi] - Event Time is different after exporting to excel.

Good point Polter :)

SB you can verfiy the same in database event schema

select * from ALL_EVENTS;

Hope it will help you :)
Regards,
Riya Roy

Ship in harbor is safe -- but that is not what ships are built for …
//Add this to "OnDomLoad" event