The question was the NON 0 results (those <>0) :-)
Can you send those offlist?
Dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Michael Shook
Sent: Wednesday, January 07, 2004 9:23 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] DB logging
at gives the non 0 results?
Dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Michael Shook
Sent: Wednesday, January 07, 2004 8:16 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] DB logging error
Minutes. While that does change the datediff calc,
Is it always the same ping check that gives the non 0 results?
Dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Michael Shook
Sent: Wednesday, January 07, 2004 8:16 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] DB logging error
Minutes. While
Wednesday, January 07, 2004 7:02 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] DB logging error
According to my db,
SELECT COUNT(*) AS Expr1
FROM servalivestats
WHERE (status = 1) AND (timing <> 0)
returns 84
SELECT COUNT(*) AS Expr1
FROM servalivestats
WH
And what are you using as unit?
Dirk.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Michael Shook
Sent: Wednesday, January 07, 2004 7:02 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] DB logging error
According to my db,
SELECT COUNT(*) AS
ving problems with the statistical odbc logging that the
timedifference field is always 0?
Dirk.
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Ahmed Hassan
Sent: Wednesday, January 07, 2004 5:42 PM
To: [EMAIL PROTECTED]
Subject: RE: [SA-list] DB logging error
I did
alf Of Ahmed
HassanSent: Wednesday, January 07, 2004 10:42 AMTo:
[EMAIL PROTECTED]Subject: RE: [SA-list] DB logging
error
I didn't try MS Access because I use SQL and will rather like it to work
with SQL as before.
Yahoo!
Messenger - Communicate instantly..."Ping" your friends today! Download
Messenger Now
anybody else having problems with the statistical odbc
logging that the timedifference field is always 0?
Dirk.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ahmed
HassanSent: Wednesday, January 07, 2004 5:42 PMTo:
[EMAIL PROTECTED]Subject: RE: [SA-list] DB logging
Sent: Wednesday, January 07, 2004 5:42 PMTo:
[EMAIL PROTECTED]Subject: RE: [SA-list] DB logging
error
I didn't try MS Access because I use SQL and will rather like it to work
with SQL as before.
Yahoo!
Messenger - Communicate instantly..."Ping" your friends today! Download
Messenger Now
I didn't try MS Access because I use SQL and will rather like it to work with SQL as before.
Yahoo! Messenger - Communicate instantly..."Ping" your friends
today! Download Messenger Now
and did you try access as requested
before?
Dirk.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ahmed
HassanSent: Wednesday, January 07, 2004 3:08 PMTo:
[EMAIL PROTECTED]Subject: RE: [SA-list] DB logging
error
>>SQL works fine for me too
SQL doesn't
>>SQL works fine for me too
SQL doesn't still work for me. My query was
SELECT TOP 20 host, laststatuschange, previousstatuschange, timing, statusFROM salive.sastatsWHERE (status = 1)
Please see the attached file for the results.
Yahoo! Messenger - Communicate instantly..."Pi
SQL works fine for me too
Dirk.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ahmed
HassanSent: Wednesday, January 07, 2004 12:28 PMTo:
[EMAIL PROTECTED]Subject: RE: [SA-list] DB logging
error
>>I'll do some tests with this
tomorrow.
Thanks for looki
I just tested it towards an Access database and that works
fine;
Could you test that one too?
Dirk.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ahmed
HassanSent: Wednesday, January 07, 2004 12:28 PMTo:
[EMAIL PROTECTED]Subject: RE: [SA-list] DB logging
error
>>I'll do some tests with this tomorrow.
Thanks for looking into the problem. Wouldn't sending my host file off line if you require it.
Thanks
Yahoo! Messenger - Communicate instantly..."Ping" your friends
today! Download Messenger Now
I'll do some tests with this tomorrow.
Dirk.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ahmed
HassanSent: Tuesday, January 06, 2004 6:58 PMTo:
[EMAIL PROTECTED]Subject: RE: [SA-list] DB logging
error
>>And when going from 1 to 5 it gives the corr
>>And when going from 1 to 5 it gives the correct number?
Just checked my database/logs and this what I get;
When the "PREVIOUSSTATUS" is 1 and the present "STATUS" is 5 it gives the correct number (i.e the "TIMINGS" field has a the correct value)
>>Does it give the problem on all entries th
] DB logging
error
>>When going from 5 to 1 as
status?
Yes -
That's correct
Yahoo!
Messenger - Communicate instantly..."Ping" your friends today! Download
Messenger Now
>>When going from 5 to 1 as status?
Yes - That's correct
Yahoo! Messenger - Communicate instantly..."Ping" your friends
today! Download Messenger Now
When going from 5 to 1 as status?
Dirk.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ahmed
HassanSent: Tuesday, January 06, 2004 5:25 PMTo:
[EMAIL PROTECTED]Subject: RE: [SA-list] DB logging
error
It's only when the "STATUS = 1" that the "TI
It's only when the "STATUS = 1" that the "TIMINGS" gives a value of zero. In all other case it works fine. Nothing in the logs to give a clue.
Can I send a copy of my host file off-list so that you can check it out?
Yahoo! Messenger - Communicate instantly..."Ping" your friends
today! Download
Could there a reason for getting a zero for the "timings" field when it's being logged to database?
Yahoo! Messenger - Communicate instantly..."Ping" your friends
today! Download Messenger Now
Not that I can directly see no.
Anything in the log that shows an
error?
Dirk.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ahmed
HassanSent: Tuesday, January 06, 2004 4:58 PMTo:
[EMAIL PROTECTED]Subject: RE: [SA-list] DB logging
error
Could there a reason for
] DB logging
error
>>Can you also log to a file and see if that gives a
correct value?
It
appears it's does not give the correct. Please see attached log
file.
Yahoo!
Messenger - Communicate instantly..."Ping" your friends today! Download
Messenger Now
>>Can you also log to a file and see if that gives a correct value?
It appears it's does not give the correct. Please see attached log file.
Yahoo! Messenger - Communicate instantly..."Ping" your friends
today! Download Messenger NowLast Nights SQL Server dbcc Checks,315,4,3,20040106,1237,2
Can you also log to a file and see if that gives a correct
value?
Dirk.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ahmed
HassanSent: Tuesday, January 06, 2004 12:30 PMTo:
[EMAIL PROTECTED]Subject: RE: [SA-list] DB logging
error
>>What is the va
>>What is the value of
HKEY_LOCAL_MACHINE\SOFTWARE\DBU Consulting\Servers Alive\StatsLog\db_unit?
The value is set to "n".
Yahoo! Messenger - Communicate instantly..."Ping" your friends
today! Download Messenger Now
What is the value of
HKEY_LOCAL_MACHINE\SOFTWARE\DBU Consulting\Servers
Alive\StatsLog\db_unit?
Dirk.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ahmed
HassanSent: Wednesday, December 31, 2003 2:19 PMTo:
[EMAIL PROTECTED]Subject: RE: [SA-list] DB logging
>>And how is it set within SA? (what unit)
The unit is in minutes. I have the "Include Host ID" box ticked.
>>Did you change anything?
Didn't change anything. I think it started after using ver 4.0.1542. At that time I thought the database was corrupt. Got our DBAs to take a look - I recreate
And how is it set within SA? (what
unit)
Did you change anything?
Dirk.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ahmed
HassanSent: Wednesday, December 31, 2003 1:54 PMTo:
SaliveSubject: [SA-list] DB logging error
Am using SA 4.0.1554 on W2K server and logging
Am using SA 4.0.1554 on W2K server and logging the satistical log to an MS SQL server. This has been working OK until in Nov when it stopped logging the time difference (i.e. the "Timing" field). The entry on that field is now zero when the "STATUS = 1".
To run my monthly reports I use the diff
31 matches
Mail list logo