I think he is talking about the state of being up in the stats log. > -----Original Message----- > From: Dirk Bulinckx [mailto:[EMAIL PROTECTED] > Sent: Friday, October 24, 2003 10:20 AM > To: [EMAIL PROTECTED] > Subject: RE: [SA-list] Statistical database question.... > > That is not aswering the question... > The initial question was that SA would keep stats over a stop/start of > SA. The question is WHAT should it exactly keep? > > > > dirk. > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Michael Shook > Sent: Fri Oct 24 2:32 PM > To: [EMAIL PROTECTED] > Subject: RE: [SA-list] Statistical database question.... > > > Well, the columns you currently write are fine, BUT.... > > I have been tasked to create monthly / annual UP/DOWN stats for the > major devices. What I do now is sum all of the minutes where the > previousstatus is X. The problem comes in that SA doesn't regularly > output state stats to this table. I only see entries if there has been a > change in status. So, unless my network is a complete piece of trash, > most of the devices never get any entries. Also, like I said, a > close/open of SA resets all of SA's internal time stamps so that if a > change does occur, the output only reflects from when SA was last > restarted. > > If SA output stats during a graceful shutdown, and on a regular time > schedule (say a few times a day (midnight, noon)) then I can use your > table as is. Otherwise, I need to perform the metrics calculations on > the interchange table, which will be a lengthy process if they ask me > for the last years stats, and I have been writing every 5 minutes. > > I can't see any issue with a previous and current status entry being the > same, but maybe a new column to explain more exactly why the record was > written would be helpful. > > Mike > > >>> [EMAIL PROTECTED] 10/24/03 06:04AM >>> > What exact info should be kept? > > > > dirk. > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Michael Shook > Sent: Thu Oct 23 10:40 PM > To: [EMAIL PROTECTED] > Subject: [SA-list] Statistical database question.... > > > If I understand the process correctly, when the first cycle is run on > the start of SA you gather a status and datetime. When the status > changes, the duration is calculated, the datetime is reset, the new > status is recorded. Then an appropriate entry is written to the > database. > > If that's correct, then when SA is stopped/restarted, all of the > "running time" info is lost from the last program start or last status > change. > > Would it be possible to output all of the current "running time" info > for each check to the database before SA shuts down (assuming a > gracefull shutdown)? Maybe record the current status as the same for > both last and new. > > I'm trying to get the most out of this database, but I can't calculate > an accurate quality % if I don't have all of the up times. > > Thanks!!!! > > > > > > > > > > > > > Michael Shook > Business Continuity Analyst > 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 > > 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 > > 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
This email and its contents may be confidential. If it is and you are not the intended recipient, please do not disclose or use the information within this email or its attachments. If you have received this email in error, please delete it immediately. Thank you. To unsubscribe from a list, send a mail message to [EMAIL PROTECTED] With the following in the body of the message: unsubscribe SAlive
