How to test Database driven logging with macro variables

[grzchr15]

We created a ODBC Datasource and we log to it using a SQL Query like:


begin NewHostmonitorEntry ('%DateTime%','%TestName%', '%Status%', '%Reply_CStyle%','%TestMethod%','%LastTestTime%','%StatusID%','%SimpleStatus%','%Agent%','%AckComment%','%LastStatus%','%PreviousStatus%','%TaskComment%','%TestID%');end;

This Query is a PL/SQL Procedure at our Oracle Server.

We would need to see the macro variables replacements for the tests to make shure that all parameters have the right (Oracle) Format.

The simple Tests in Options dialog can only produce errors ( eg %DateTime% is not a date parame )

Thanks for help

[KS-Soft Europe]

We would need to see the macro variables replacements for the tests to make shure that all parameters have the right (Oracle) Format.

I think, you may assign "Send Email" action to some test and add necessary variables into the mail profile, assigned to "Send Email" action. All variables will be resolved in letter you receive.

http://www.ks-soft.net/hostmon.eng/mfra ... m#actEMail
http://www.ks-soft.net/hostmon.eng/mfra ... .htm#Mails


Regards,
Max