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