Both your and Brent's suggestions are what I am doing now. It's just that it would be simpler to explain to my team if it was more straight forward. Also, these should make for nice selling points. Less coding on users part to get data out.
Mike >>> [EMAIL PROTECTED] 10/27/03 09:34AM >>> The 2nd thing can be done :-) Use the interchange file export and create an app that insert this into a db. And instead of doing an append this just does an update (or add). This app can then be execute by SA after the generation of the interchange file. dirk. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Shook Sent: Mon Oct 27 3:07 PM To: [EMAIL PROTECTED] Subject: [SA-list] Dreaming of features for version 5..... The discussions around the stats table (the regedit of which is being tested this morning - Thanks Dirk!!!) got me to thinking about tables that SA could create that would save me time and effort in the future (especially when I have to explain SA to the Network team!!!) The first is as had been mentioned where SA keeps track of the timing for all of the states a check has been in for a given period of time and then sends that to a database on a regular schedule. The second is exactly the same as the current interchange database table EXCEPT that it only keeps the results of the last check cycle (like the interchange file). This would also assist the gentleman who wanted a list of the current hosts being checked. I love the history, but it's a bit of a challange to get the latest test results. The third is a database with only one record, the fields being all of what is available via HTML tags for the SA software itself and the top level group (sa_version, sa_cycles, sa_group_up_entries, etc....). Here's to dreaming!! 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
