Writing multiple test results to a database

[bbackx]

Writing the result from one test to a database is no problem, that works like a charm.
But now, I would like to structure things a bit.
As you have read in my previous posts, monitoring the backup status/results is one of those things.
The different tests are:
- Job status
- Total files backed up
- Size of all those files

Is there a way to write all those files to a table resulting in a single entry for each day, something like this:
{timestamp, servername, job status, total files, size}
Especially the time dependency of the whole thing is kind of a problem for me, since the SQL-functionality of HostMonitor is not that extended (as in: limited to writing things to a database when a test is finished). Or am I missing something here?

[KS-Soft]

So, basically you want to save results of several tests using single database record?
I think you may make these tests dependant (Test2 depends on Test1, Test3 depends on Test2) and use "SQL Query" action assigned to last test (Test3) to record results into database. You may use macro variables like %::Test1::Reply%, %::Test2::Reply% and %::Test3::Reply% in SQL Query.

Regards
Alex