Table settings for hmlog table SQL 2008 R2

All questions related to installations, configurations and maintenance of Advanced Host Monitor (including additional tools such as RMA for Windows, RMA Manager, Web Servie, RCC).
Post Reply
Thore
Posts: 23
Joined: Thu Nov 26, 2009 7:08 am

Table settings for hmlog table SQL 2008 R2

Post by Thore »

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
Posts: 13012
Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:

Post by KS-Soft »

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
Posts: 23
Joined: Thu Nov 26, 2009 7:08 am

Post by Thore »

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
Posts: 13012
Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:

Post by KS-Soft »

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

Regards
Alex
Post Reply