Send report in email, not attachment

oryagel · Post by **oryagel** » Thu Jan 06, 2011 4:32 am

Hi,

I configured host monitor to send report every few hours.
The report is for specific folder.
Currently the report is sent as an attachment.

The guys that get the report asked if they can get it integrated into the email body and not as an attachment.
I couldn't figure how to do that.
Is it possible? How?

Thanks

KS-Soft Europe · Post by **KS-Soft Europe** » Thu Jan 06, 2011 9:02 am

You may use special directive inside email profile like: <<IncludeFile=path_to_the_file>>

Please visit our web site for more information at:
http://www.ks-soft.net/hostmon.eng/mfra ... .htm#Mails

oryagel · Post by **oryagel** » Sun Jan 09, 2011 10:59 am

Great!

Another question:
I send report to different time zone.
Some tests in the report refer to specific time frame.
For example:
1. How many new XXX were created in the last 3 hours.
2. How many new XXX were created yesterday in the last 3 hours (27H-24H ago)

The guys that get the report ask to see the time frame for of the tests.
For example: 2011-01-09 7:07:29 AM - 2011-01-09 10:07:29 AM

Is it possible?

Thanks

KS-Soft · Post by **KS-Soft** » Mon Jan 10, 2011 12:16 pm

1) If you have absolutelly different question, its better to start new topic
2) What software do you use to create these reports? HostMonitor? Log Analyzer? or perhaps custom made application?

Regards
Alex

oryagel · Post by **oryagel** » Tue Jan 11, 2011 2:28 am

1) Sorry for that.
2) The report is created by HostMonitor.

KS-Soft · Post by **KS-Soft** » Tue Jan 11, 2011 11:59 am

No, HostMonitor reports cannot show time frame because they do not work with time frame, they show current status (except SLA reports).

Truth to say I don't understand how you could creare such report (How many new XXX were created yesterday in the last 3 hours 27H-24H ago).
Is there such option in HostMonitor?? I ask this question 1st time in 10 years

Regards
Alex

oryagel · Post by **oryagel** » Wed Jan 12, 2011 2:04 am

HostMonitor can do everything!
It's an ODBC query...
I understand that HostMonitor just execute the query and get the answer.
But, is it possible to attach the time frame or something like that?

In theory it should be possible because it's simple expression.
I just need a field in the report or in the test that can parse the expression.
It should be something like:
1st time frame: (%CurrentTime%+5Hours) to (%CurrentTime%+8Hours)

It can be per test or per report, doesn't matter.

Can you think about a way to display this?

KS-Soft · Post by **KS-Soft** » Wed Jan 12, 2011 2:30 pm

I still don't have any idea how you create report

If you are using ODBC Query test or SQL Query action, HostMonitor will not create any report.
May be you are using some script that is launched by this query? Then your script creates some report file?

May be we misunderstood term "report"?
Report in HostMonitor terms is text, dbf, wml or html file, parameters of such report can be configured in Report Manager
http://www.ks-soft.net/hostmon.eng/index-logs.htm
http://www.ks-soft.net/hostmon.eng/mfra ... tm#Reports

All reports except SLA reports show current snapshot, so they cannot display any time range, they display time when report was created.

Regards
Alex

oryagel · Post by **oryagel** » Thu Jan 13, 2011 2:07 am

Thanks.

I will try to explain again.

I have a folder in HostMonitor, in this folder there are few tests, some of them are queries to MSSQL DB with ODBC connection.

In the folder properties I configured a HTML report to be generated every 3 hours.
After the report is generated there is an action profile which sends the HTML file in email.

As I wrote before, some of the tests in this report refer to specific time frame.
I want to add this time frame in some way to the report.

Did you understand the issue?
Can you think about a way?

Thanks

KS-Soft · Post by **KS-Soft** » Thu Jan 13, 2011 2:42 pm

Then this part does not make any sense to me
=======================
1. How many new XXX were created in the last 3 hours.
2. How many new XXX were created yesterday in the last 3 hours (27H-24H ago)
=======================
I thouth "XXX" means "test item". That's why I said HostMonitor cannot create such reports.
Am I wrong? What is "XXX"?

As I wrote before, some of the tests in this report refer to specific time frame.
I want to add this time frame in some way to the report

Sorry, I don't understand what exactly means "refer to specific time frame".
HostMonitor test items offers several time related fields, such as
- Last test time
- Status changed time
- Created at
- Modified at
- Acknowledged at

What time do you want to display?
May be you want to show time interval between 2 probes of the test item?

Regards
Alex

oryagel · Post by **oryagel** » Sun Jan 16, 2011 3:45 am

OK.

XXX doesn't mean test items.

We have a MSSQL DB.
The DB is constantly growing.
One of the tests (SQL query) displays how many items were added to that DB in the last 3 hours.
The DB isn't related to HostMonitor.

HostMonitor executes the query that asks "How many items were added in the last 3 hours".
Let say that the test was executed at 5PM, the time frame will be 2PM-5PM.

I want to display the time frame in the report.
Currently the report displays the result of the test without the time frame, for example:

Code: Select all

Items added in the last 3 hours - 15352

I want to see the time frame of the test in the report, for example:

Code: Select all

Items added in the last 3 hours (2011/01/16 2PM-5PM) – 15352

Or

Code: Select all

Time Frame: 2011/01/16 2PM-5PM
Items added in the last 3 hours – 15352

Do you understand?

Thanks

KS-Soft · Post by **KS-Soft** » Mon Jan 17, 2011 1:48 pm

Yes, not I understand: you want to display
1) time of the test probe. No problem here, this value can be represented by "Last test time" field (or %LastTestTime% vairable if you are using Custom HTML report type)
2) time of the test probe - 3 hours. Sorry, there is no such option

Regards
Alex