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.
ScriptForODBC
LogAnalyzer 5.86KS-Soft wrote:We cannot reproduce the problem.
What version of the software do you use?
ODBC driver?
Table structure?
Regards
Alex
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.