KS-Soft. Network Management Solutions
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister    ProfileProfile    Log inLog in 

Report with the average of the last X hours

 
Post new topic   Reply to topic    KS-Soft Forum Index -> Configuration, Maintenance, Troubleshooting
View previous topic :: View next topic  
Author Message
oryagel



Joined: 28 Jul 2010
Posts: 62

PostPosted: Wed Jan 04, 2012 2:40 am    Post subject: Report with the average of the last X hours Reply with quote

Hi,

I want to send a report every 4 hours.
The report should include few tests and their average value during the last 4 hours.

How can I do that?
Back to top
View user's profile Send private message
KS-Soft Europe



Joined: 16 May 2006
Posts: 2249

PostPosted: Wed Jan 04, 2012 5:14 am    Post subject: Report with the average of the last X hours Reply with quote

HostMonitor can generate global and folder-level reports at regular intervals.
If you want to display average statistics information for last 4 hours, you will need to reset test statistics each time report is generated.
Statistics for particular test items can be reset by HMS script.
Also, you may create report for specific View.

How to do:
1. Create HMS script to clear statistics for selected test items.
Script may look like the following:
Code:
ResetTest TestItemName 1
ResetTest TestItemName 2
ResetTest TestItemName 3

2. Create Action profile with "Execute HMS script" action and select Condition to start action: "on the schedule", select prepared HMS script from step 1.

3. Create report profile using Report manager (menu Reports -> Report Manager...)
4. Create View
5. Select Report profile for that View ("Reports" page of "Dynamic view properties" dialog)
6. Activate "Generate reports every" option and set interval to 240 min
7. Activate "Execute action profile when complete" option and select action profile from step 2

Please check the manual or visit our web site for more information at:
Execute HMS script action: http://www.ks-soft.net/hostmon.eng/mframe.htm#actions.htm#actScript
View reports: http://www.ks-soft.net/hostmon.eng/mframe.htm#testlist.htm#view_reports
Back to top
View user's profile Send private message Send e-mail Visit poster's website
oryagel



Joined: 28 Jul 2010
Posts: 62

PostPosted: Wed Jan 04, 2012 9:27 am    Post subject: Reply with quote

Thanks!

I want to exclude results larger than X from the average calculation.

Is it possible?
How?
Back to top
View user's profile Send private message
KS-Soft Europe



Joined: 16 May 2006
Posts: 2249

PostPosted: Wed Jan 04, 2012 10:10 am    Post subject: Report with the average of the last X hours Reply with quote

Actually, you may exclude such test items, using View configuration.
E.g. you may additionally use "Select items by stats" section and define Alive ration > 50 %.
Also, you may use "Select items using expression" option with expression like the following:
('%AliveRatio%' > '50 %') AND ('%DeadTime%' < '00:25:00')

You may check all statistical macro-variables at:
http://www.ks-soft.net/hostmon.eng/mframe.htm#actions.htm#macro
Back to top
View user's profile Send private message Send e-mail Visit poster's website
oryagel



Joined: 28 Jul 2010
Posts: 62

PostPosted: Wed Jan 04, 2012 10:21 am    Post subject: Reply with quote

Thanks, but it's not what I'm looking for.

I want to exclude results from the calculation of the average value of a test.
Lets say I have a test which was executed 5 times, the results are:
4
2
5
42142141
5

The 4th value is a mistake and the average should be 4, (4+2+5+5)/4.
Is it possible?
Back to top
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 10401
Location: USA

PostPosted: Wed Jan 04, 2012 10:34 am    Post subject: Reply with quote

calculation of the average value?
Do you mean average Reply value? Its not a problem, HostMonitor offers such counter.

Quote:
4
2
5
42142141
5
The 4th value is a mistake and the average should be 4

Mistake? You want to ignore some Reply values from statistics?
This is impossible.

Regards
Alex
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    KS-Soft Forum Index -> Configuration, Maintenance, Troubleshooting All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

KS-Soft Forum Index