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

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

SOLVED
Go to Solution
Trusted Contributor

[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
Respected Contributor

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 …
Valued Contributor

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

Trusted Contributor

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

[ Edited ]

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

Trusted Contributor

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.
Respected Contributor

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 …