KS-Soft. Network Management Solutions
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister    ProfileProfile    Log inLog in 

ScriptForODBC

 
Post new topic   Reply to topic    KS-Soft Forum Index -> Reports
View previous topic :: View next topic  
Author Message
Mikevirtu



Joined: 01 Mar 2014
Posts: 41

PostPosted: Mon Sep 01, 2014 11:13 am    Post subject: ScriptForODBC Reply with quote

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.
Back to top
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12791
Location: USA

PostPosted: Mon Sep 01, 2014 2:36 pm    Post subject: Reply with quote

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

Regards
Alex
Back to top
View user's profile Send private message Visit poster's website
Mikevirtu



Joined: 01 Mar 2014
Posts: 41

PostPosted: Mon Sep 01, 2014 10:27 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12791
Location: USA

PostPosted: Tue Sep 02, 2014 11:26 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    KS-Soft Forum Index -> Reports All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

KS-Soft Forum Index