Table settings for hmlog table SQL 2008 R2

Thore · Joined: 26 Nov 2009 Posts: 23

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 · Joined: 03 Apr 2002 Posts: 12801 Location: USA

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 · Joined: 26 Nov 2009 Posts: 23

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 · Joined: 03 Apr 2002 Posts: 12801 Location: USA

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

Regards
Alex