KS-Soft

I should have tell that I have tried without the quotes. Without the quotes the error message is : incorrect syntaxe near '%fvar_clientname%' With the quote the error message is : incorrect syntaxe near '%' system log : 9/26/2013 4:48:26 PM Primary log error. ODBC error code: 4294967295 ([Microsoft]...

Hello, %fvar_clientname% is a variable defined on the folder /root/client/ of the folder tree. I have tested it and this variable is working correctly. I would like to use it to define in which table write the logs. I have written this SQL query : Insert into '%fvar_clientname%' (eventtime, testname...

Hello, I know I am exhumating a old fossil here but I am still new with the product. Sorry if my question has alredy been answered. I have seen that we can consolidate data with such ideas : What would be ideal would be to execute a program that went through a specified log file and based on some pa...

Hello,

sorry this was my fault. I did not see the sentence telling to create the table first.

I thought HM would create it.

Thanks for your help.

Hi, Thank you for this page that I had never seem. Although I don't see these variables when I go to Options => Primary backup => Sql Query and then check the macro variables. These seem to be macro variable. Not usable in the sql query (am I wrong?). I have tried this so far and it endeed didn't wo...

Hi Again ! :) I have separated my tests in different subfolders. ROOT ROOT/sub1 Test1 ROOT/sub2 Test2 Where is stored the information that test 1 is linked to sub1 and test2 to sub 2? Is there anyway to have this information into the database by modifying : Insert into test (eventtime, testname, sta...

yes that was the problem.

The documentation only says CHAR so I had selected this in SqlExpress. However the default size was 10 I have increased it and it was then ok.

I haven't seen this info in the doc.

Thanks.

Hi all, I found the reason was that I had to create myself the table and each of its field myself. Of course an appropriate database table has to be created before you start using the ODBC logging. Altough after doing this I still have an error message string or binary data would be truncated It app...

Hi all, I am very new on using HM. I wanna do a POC on using a SQL DB to store de logs. I have a test machine (XP) with HM and RCC installed + SQL express 2008. I have created a DB called hm. I have a setup an ODBC object (dsn system) and tested it : test is ok. Then I HostMonitor I open the options...