Standard deviation

[oryagel]

Can I test for standard deviation in some way?

Thanks

[KS-Soft]

Sure, you can write a program or a script.
How to calculate standard deviation
http://en.wikipedia.org/wiki/Standard_deviation

If this question is related to HostMonitor in some way, please provide details.

Regards
Alex

[oryagel]

It's related, of course...

I want to compare a test result to the result of the same test in past.
For example:
Compare the result to the results of the same test in the same day but last week.
I want to calculate the standard deviation of the same day in the last week and compare to the current result.

Any idea?

Thanks

[KS-Soft]

This means log file should be analyzed.
If you need to analyze all test items, I would recommend to use ODBC logging to store test results (just don't use Oracle - too many bugs in client sofware, ODBC drivers) and then use SQL procedures to analyze data.
If you need to check single test item, you may use "SQL Query" or "Execute external program" action to store test results in database or simple text file.

Regards
Alex

[oryagel]

Thanks

I want to configure ODBC logging.
Do you have a script to create the table?
If not, which columns and types should I create?

Using MSSQL 2008R2

Thanks

[KS-Soft Europe]

You may use the following SQL query to create table for ODBC logging:

Code: Select all

CREATE TABLE NEW_HMLOG ( 
  eventtime datetime, 
  testname varchar (100), 
  status varchar (24), 
  reply varchar(100), 
  testid int, 
  testmethod varchar(100) 
);

[oryagel]

Thanks

I configured ODBC logging and it looks like it's working.

But now, when I get alerts I don't see the values.

The email looks like this:

Code: Select all

Message from HostMonitor (host changed status)

Test     : %TestName%
Method: %TestMethod%
Status  : %STATUS%
Date    : %DATETIME%
Reply   : %Reply%

Recurrences : %Recurrences%
Last status: %LastStatus%
Total tests: %TotalTests%
Alive ratio : %AliveRatio%
Dead ratio: %DeadRatio%

Folder: %Folder%

What did I miss?

[KS-Soft]

I assume this action is not triggered by test status change.
Probably you assigned this action to built-in scheduler or some folder... Please check where action is used.

Regards
Alex