Hello,
There is a query which runs everyday and sends report with the server list, which are placed in maintenance mode with start and end time.
The problem we are facing here is, Time updated in the CSV file we are receiving and time which shows in the SCOM console is varying with 2 hours. however both database server and operation manager server are in same time zone.
Please let me know, what or where exactly i need to check to understand the actual problem?
My Guess: In the database table itself it is writing with different timezone?. if my guess is correct, then i am not sure how to query database and verify the same?
Thanks,
Deepak