Capture remote server clock datetime & pass to ODBC log?

[blowery]

Hello,

Running HM 6.42c, w/ODBC logging to SQL Server db table via a stored procedure call like this (SQL Query field on Primary Log tab in Options):

exec HMDB.dbo.usp_hostmon_logevent '%CommentLine1%','%CommentLine2%','%TestName%','%DateTime%','%Status%','%Reply%', '%TotalTime%', '%PassedCnt%', '%FailedCnt%', '%AliveTime%', '%DeadTime%', '%StatusChangedTime%', '%AcknowledgedAt%', '%AcknowledgedBy%', '%AckComment%', '%AckRecurrences%','%Recurrences%'

Suppose the test is performed via RMA to a server in a remote time zone. Is it possible to capture the remote server's clock datetime with any test performed over RMA and pass it in a macro variable to the proc call, like:

exec HMDB.dbo.usp_hostmon_logevent '%CommentLine1%','%CommentLine2%','%TestName%','%DateTime%','%Status%','%Reply%', '%TotalTime%', '%PassedCnt%', '%FailedCnt%', '%AliveTime%', '%DeadTime%', '%StatusChangedTime%', '%AcknowledgedAt%', '%AcknowledgedBy%', '%AckComment%', '%AckRecurrences%','%Recurrences%'[color=red],'%RemoteServerDateTime%'[/color]

Since %DateTime% refers to the dt on the HM monitoring server, it would be useful to capture the remote server's dt as well for complete diagnostic and event correlation purposes.

[KS-Soft]

Please use "Problems and bugs" forum when something works incorrectly.
Use "Wish list" forum for new features requests.
http://www.ks-soft.net/cgi-bin/phpBB/viewforum.php?f=6

We were thinking about folder-level property: TimeZone. Probably TimeZone option even better because you may monitor remote servers without using agent and invalid system time on remote server will not effect reports

Regards
Alex