According to my db,
SELECT COUNT(*) AS Expr1
FROM servalivestats
WHERE (status = 1) AND (timing <> 0)
returns 84
SELECT COUNT(*) AS Expr1
FROM servalivestats
WHERE (status = 1) AND (timing = 0)
returns 408
Looking into the data, there is only one instance where timing wasn't = 0 and the test
was a ping test. Where the timing was equal to zero, there was a mix of tests.
SELECT CONVERT(datetime, previousstatuschange) AS pdate, CONVERT(datetime,
laststatuschange) AS ldate, DATEDIFF(ss, CONVERT(datetime,
laststatuschange), CONVERT(datetime, previousstatuschange)) AS
myDiff, timing
FROM servalivestats
returns a zero value for most myDiff (a dozen or so were actually negative values, but
were -9 or more).
SELECT COUNT(*) AS Expr1, previousstatus
FROM servalivestats
WHERE (status = 1) AND (timing = 0)
GROUP BY previousstatus
returns
4 , 3
74, 4
330, 5
I don't use the timing value since it gets reset if SA gets reset (I run a calc
externally on every check and track those values in a seprerate db), so I didn't
notice this.
Hope this helps
Michael Shook
Technical Support Analyst - Corporate
Saddle Creek Corporation
723 Joe Tamplin Industrial Blvd
Macon GA 31217
478 742 8740 ext. 105 (work)
478 256 9318 (mobile)
478 742 7917 (fax)
[EMAIL PROTECTED]
http://www.saddlecrk.com
>>> [EMAIL PROTECTED] 01/07/04 11:49AM >>>
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 Hassan
Sent: Wednesday, January 07, 2004 5:42 PM
To: [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.
_____
<http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.co
m> Yahoo! Messenger - Communicate instantly..."Ping" your friends today!
<http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.co
m/download/index.html> Download Messenger Now
To unsubscribe from a list, send a mail message to [EMAIL PROTECTED]
With the following in the body of the message:
unsubscribe SAlive
