We don't keep the time/date of the previous check only of the current check and of the status change times.
dirk. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Shook Sent: Wed Oct 29 3:27 PM To: [EMAIL PROTECTED] Subject: [SA-list] question regarding internal time keeping... Dirk, when you run a check cycle, do you track the last time each check was run, or just the time the last cycle was run? The reason I'm asking is because by DBA here has suggested that if you could output in the interchange database the checktime of the previous check, we can use that to calculate how long that particular entry was in the current state. Thus, calculate the total times for each state. 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
