ScriptForODBC

Mikevirtu · Post by **Mikevirtu** » Mon Sep 01, 2014 11:13 am

Hi,
I'd created script.

LoadTable ODBCset
DateFilter %DDMMYYYY% %DDMMYYYY%
TimeFilter Include 13:00 18:00 13:00 18:00
SkipMode Off
CreateReport "MyReport"

In report I see time from 00:00 to current time.
DateFilter is working, TimeFilter isn't working (I'd checked it).
I need
1. may be use automatic change custom filter in ODBCset (prefare)
2. working TimeFilter - when I work with DB (not file logs)
Please help me.
Mike.

KS-Soft · Post by **KS-Soft** » Mon Sep 01, 2014 2:36 pm

We cannot reproduce the problem.
What version of the software do you use?
ODBC driver?
Table structure?

Regards
Alex

Mikevirtu · Post by **Mikevirtu** » Mon Sep 01, 2014 10:27 pm

KS-Soft wrote:We cannot reproduce the problem.
What version of the software do you use?
ODBC driver?
Table structure?

Regards
Alex

LogAnalyzer 5.86
HostMonitor 9.90
C:\WINDOWS\SysWOW64\odbcad32.exe (6.1.7601.17514)
OS - Windows 2008 R2SP1
DB - Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) (local on server with HostMonitor)

CREATE TABLE [dbo].[hmlog](
[id] [bigint] IDENTITY(1,1) NOT NULL,
[eventtime] [datetime] NOT NULL,
[testname] [varchar](100) NOT NULL,
[testid] [int] NOT NULL,
[testmethod] [varchar](100) NOT NULL,
[status] [varchar](50) NOT NULL,
[reply] [varchar](50) NOT NULL,
[agent] [varchar](100) NOT NULL,
CONSTRAINT [PK_hmlog] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

Regards
Mike.

KS-Soft · Post by **KS-Soft** » Tue Sep 02, 2014 11:26 am

still cannot reproduce the problem and we don't see mistake in the code.
May be we misunderstand something. Could you please send screen shots to support@ks-soft.net?

Regards
Alex