SQL

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
bax
Posts: 6
Joined: Wed Feb 22, 2006 1:39 am

SQL

Post by bax »

Is there any way to put test data for different folders into diffeerent tables? If yes, can you telle how and where.
I am running version 4.86
brgds
brian
Yoorix
Posts: 177
Joined: Wed Dec 14, 2005 8:28 am

Post by Yoorix »

Your question is not so clear.
Sorry, I do not understand your needs.

Do you mean OBDC logging?
Do you mean separated DBF report file for different folders?
Do you want to store test list for different folders in different files?
Or something else?

Please provide more information about your request.

Regards,
Yoorix
bax
Posts: 6
Joined: Wed Feb 22, 2006 1:39 am

Sorry

Post by bax »

I mean ODBC-logging, and I want to store test list for different folders in different files
Yoorix
Posts: 177
Joined: Wed Dec 14, 2005 8:28 am

Post by Yoorix »

To store test list in different files you shoud use HML manager:
Menu File > Start HML Manager. More info about HML Manager you able to read here: http://ks-soft.net/hostmon.eng/hml-manager/index.htm

Regarding ODBC Log. I think it's impossible to separate log table, but you could adjust log table entirely up to you, e.g. you can add new field like FolderName an store macro variable %Folder% as folder name in log table. Than you would use this information in your reports. Please read about ODBC logging here: http://ks-soft.net/hostmon.eng/logs.htm#ODBCLog

Pay attention to macro variables (http://ks-soft.net/hostmon.eng/actions.htm#macro) you could use in HM

Regards,
Yoorix
KS-Soft
Posts: 13012
Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:

Post by KS-Soft »

Regarding ODBC Log. I think it's impossible to separate log table,
Why not? You may use some macro variable (e.g. %FolderComment01%) as tablename. E.g. INSERT INTO %FolderComment01% (DATE1, TIME1, TEST_NAME, TestID, STATUS, REPLY) VALUES (%Date%, '%Time%', '%TestName%', %TestID%, '%Status%', '%Reply%')

Regards
Alex
Post Reply