Will writing to a database with suggested query give metrics

[grantqa]

Will writing the primary log to a database with the suggested query give the same metrics as writing to the text log file, when viewing the log with Log Analyzer?

http://www.ks-soft.com/hostmon.eng/mfra ... ctions.htm

INSERT INTO HMLOG (EVENTTIME, TESTNAME, STATUS, REPLY, TESTID, TESTMETHOD, RECURRENCES) VALUES (‘%DateTime%', '%TestName%', '%Status%', ‘%Reply%', %TestID%, ‘%TestMethod%’, %Recurrences%)

I plan to select "Midnight" default logging mode for primary log.

[ironcurtain]

http://www.ks-soft.com/hostmon.eng/mfra ... ctions.htm

From menu select "Logs & Reports", then from "Common log" section click on hyperlink "ODBC" from sentence "For each log you may choose defferent log type (ODBC or File),"

[KS-Soft]

INSERT INTO HMLOG (EVENTTIME, TESTNAME, STATUS, REPLY, TESTID, TESTMETHOD, RECURRENCES) VALUES (‘%DateTime%', '%TestName%', '%Status%', ‘%Reply%', %TestID%, ‘%TestMethod%’, %Recurrences%)

Yes, it will work. You may remove Recurrences field. Its not necessary.
http://www.ks-soft.net/hostmon.eng/mfra ... tm#odbclog

Regards
Alex