View previous topic :: View next topic |
Author |
Message |
kediedri
Joined: 07 May 2003 Posts: 3
|
Posted: Thu May 08, 2003 9:18 am Post subject: |
|
|
I am trying to generate a report showingthe average CPU usage for the last 4 months between the hours of 8AM and 5PM is there away to do this inside HOSTMON or do I need to export the data to a DB to generate this report? I currently run the CPU usage test every 10min 24hours a day. |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12807 Location: USA
|
Posted: Thu May 08, 2003 11:56 am Post subject: |
|
|
The only way to do this inside HostMonitor is to perform CPU test between 8AM and 5PM.
Regards
Alex |
|
Back to top |
|
|
kediedri
Joined: 07 May 2003 Posts: 3
|
Posted: Thu May 08, 2003 12:49 pm Post subject: |
|
|
Thanks for the quick response I guess my next question is there a way to export my current log file into an MS Access table this would allow me to query out the data that I need as I have 6 months worth of data already collect it is just showing for the entire day not just the hours I need.
Thanks |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12807 Location: USA
|
Posted: Thu May 08, 2003 1:09 pm Post subject: |
|
|
What log format do you use? Its easy to convert file if you use DBF log, more difficult in case of text log and very difficult convert data from HTML log.
Regards
Alex |
|
Back to top |
|
|
kediedri
Joined: 07 May 2003 Posts: 3
|
Posted: Thu May 08, 2003 1:30 pm Post subject: |
|
|
I am using HTML is there a way to export that or should I just change the setting now and collect more data. |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12807 Location: USA
|
Posted: Thu May 08, 2003 2:58 pm Post subject: |
|
|
Probably the simplest way to get data from HTML log is:
- start Log analyzer
- select the test
- click on left bottom pane (list of all checks for specifid test)
- mark all text (except 3 first lines) and press Ctrl+C
- paste text into any text editor and save it
You will have tab separated text file that (I think) is possible to import into access table
Regards
Alex |
|
Back to top |
|
|
|