Fair enough, however, the attached extract is for the last 2 days only during which time I've either been up to date or running the beta, and there are tons of time gaps... (uniqueID 70 is a good example, but there are many more)
this is driving the SQL person crazy... Any clues? (attached .txt is zipped becasue it was 28k and the list max is 25k) ________________________ Roland Gaspar Tel.: (514) 398-7880 xt 8603 ICQ # 1355591 www.roland-gaspar.com >>> [EMAIL PROTECTED] 04/08/03 04:05PM >>> That could be caused by bugs in previous versions.... dirk. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Roland Gaspar Sent: Tue Apr 08 9:50 PM To: [EMAIL PROTECTED] Subject: [SA-list] Statistical Logging (Missing Records) Started another thread for this one... SQL query for uniqueid 24: HOST UNIQUEID STATUS PREVIOUSSTATUS TIMING PREVIOUSSTATUSCHANGE LASTSTATUSCHANGE -------------------------------------------------- ---------- ---------- -------------- ---------- -------------------------- -------------------------- V2K (6H1) 24 1 5 52766 3/22/03 10:46:20 PM 3/23/03 1:25:46 PM V2K (6H1) 24 5 1 333 3/23/03 1:41:00 PM 3/23/03 1:46:33 PM V2K (6H1) 24 5 1 1072 3/23/03 2:09:33 PM 3/23/03 2:27:25 PM V2K (6H1) 24 1 5 147588 4/4/03 4:09:32 PM 4/6/03 9:09:20 AM V2K (6H1) 24 5 1 31952 4/6/03 9:09:20 AM 4/6/03 6:01:52 PM what happened between 3/23/03 1:25PM and 3/23/03 1:41pm? and between 3/23/03 1:46pm and 3/23/03 2:09pm? and between 3/23/03 2:27pm and 4/4/03 4:09pm? the only transition that makes sense is between 4/6/03 9:09am and 9:09am .. the prev change date should match the last change date of the following changed state at all times right? There is a lot of missing data here... ________________________ Roland Gaspar Tel.: (514) 398-7880 xt 8603 ICQ # 1355591 www.roland-gaspar.com To unsubscribe from a list, send a mail message to [EMAIL PROTECTED] With the following in the body of the message: unsubscribe SAlive To unsubscribe from a list, send a mail message to [EMAIL PROTECTED] With the following in the body of the message: unsubscribe SAlive xxxxxxxx Ce message a �t� analys� par Guinevere2 et McAfee This message was Scanned by Guinevere2 and McAfee http://cheese.patlq.com/guinevere.htm Questions? [EMAIL PROTECTED] xxxxxxxx
missing_data.zip
Description: PKZIP (compressed) files
