Requiring %TestName% %TestID% %Status% %Reply% in ODBC Log

When you post information about some problem, please include the following details: - OS version (e.g. Windows 2000 Professional SP3); HostMonitor version; problem description.
Post Reply
njackson
Posts: 4
Joined: Tue Sep 18, 2012 9:20 am

Requiring %TestName% %TestID% %Status% %Reply% in ODBC Log

Post by njackson »

Requiring %TestName% %TestID% %Status% %Reply% in Options for Backup or System log using ODBC.

I think this should be an option and at most a warning if they are not included. This should not be a requirement as I include that information in a global macro variable and use the variable in the SQL query. Perhaps it could be checked if, when it's used, the global macro variable contains the needed info.
KS-Soft
Posts: 12869
Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:

Post by KS-Soft »

Not sure where do you see a bug... and why do you use some global variable instead of %TestID%? Truth to say I do not see any sense in such substitution.
Could you please explain why do you need this?

Regards
Alex
KS-Soft
Posts: 12869
Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:

Post by KS-Soft »

PS
Also, how System log relates to this? System log has fixed format, you cannot specify any variables.

Regards
Alex
njackson
Posts: 4
Joined: Tue Sep 18, 2012 9:20 am

Post by njackson »

Sorry about System log. My oversight.

Please move to where you think would best be if it's not a bug. It was unexpected so it's my own opinion that it is a bug.

Otherwise it's not about global macro variables. It's the need for those 4 items in backup log. Perhaps I only need %TestName% and %Reply%. Or maybe I need %TestMethod%, %PreviousStatusDuration_sec% and %StatusID%. What is the sense of that? It shouldn't matter. What does is I should be able to log whatever information I may need.

An idea may be to warn that key information is not present (disclaimer) and then let it be with what is entered.
njackson
Posts: 4
Joined: Tue Sep 18, 2012 9:20 am

Post by njackson »

Host Monitor version 9.30
OS version Windows Server 2003 R2
KS-Soft
Posts: 12869
Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:

Post by KS-Soft »

Log without information about test results has no sense. That's why you need to record timestamp, testname, testID, status and reply.
You may use either %Status% or %StatusID%. Also you have several options for reply fields.
Perhaps I only need %TestName% and %Reply%. Or maybe I need %TestMethod%, %PreviousStatusDuration_sec% and %StatusID%.
Sounds like you don't know what exactly do you need. Then we recommend to keep default list of fields.
What is the sense of that? It shouldn't matter
It does matter.
Especially if you decide to start Log Analyzer, analyze your log and create some reports.

Anyway, could you please explain what exactly is the problem?
May be you just want to save 10-60 bytes per record by removing testname and/or reply_integer fields? Is this really important and useful?

Regards
Alex
njackson
Posts: 4
Joined: Tue Sep 18, 2012 9:20 am

Post by njackson »

I concede.
Post Reply