Table settings for hmlog table SQL 2008 R2

Thore · Post by **Thore** » Mon May 23, 2011 8:49 am

Hi all

I'm struggling with setting up the hmlog table for proper logging into a SQL db running on a SQL 2008 R2 server. I get several errors etc. Is there any overview available which colums/data types must be added to the hmlog table?
Thanks for any help

Thore

KS-Soft · Post by **KS-Soft** » Mon May 23, 2011 8:57 am

Format of this table is up to you, you may add any fields you like.
However if you want to analyze this log using Log Analyzer application, then some parameters are obligatory:
- time of the event
- name of the test item
- unique test ID
- test method
- status of the test
- reply value
Some parameters can be recorded in different form. E.g. you may store status as text ("Host is alive", "No answer", etc) or as a number.

Please check the manual for details (page 291 if you are using latest version of the software).

Regards
Alex

Thore · Post by **Thore** » Fri Jul 15, 2011 6:06 am

Hi Alex

Sorry for delay
Thanks a lot Alex. I'm now able to log into the SQL Server. Is there any recommended design of needed tables etc.?

Best regards
Thorsten

KS-Soft · Post by **KS-Soft** » Fri Jul 15, 2011 9:48 am

Please check the manual for details (page 291 if you are using latest version of the software).

Regards
Alex