I currently use a template to extract summary information from each cycle to a .asp page that I can include in my other web lookup pages.
------------------------------------------------------------
<%
strSAID = "<sa_said>"
strCycleStart = "<sa_cyclestart>"
strCycleTime = "<sa_cycletime>"
strSAStart = "<sa_startshortdate> <sa_startlongtime>"
strSAVersion = "<sa_version>"
strEntriesTotal = "<sa_nr_entries>"
strEntriesUnavailable = "<sa_nr_unavailable>"
strEntriesUnchecked = "<sa_nr_unchecked>"
strEntriesUp = "<sa_nr_up>"
strEntriesDown = "<sa_nr_down>"
strEntriesMaintenace = "<sa_nr_maintenance>"
%>
<!--
This space intentionally left blank
<sa_report>
</sa_report>
-->
---------------------------------------------------------------------
Due to reporting requirements, I need this data from the SQL Server. I can query the interchange db for this info, but due to the large number of records, (3 millionish), it takes several seconds to run.
So, my request is for a new db output alongside of the interchange and status dbs for this 'recap' information. Since this is a recap, it would have to be smart enough to delete any previous records from a SAID, then add the current ones. That way I have a record for each of my ServersAlive servers.
Please?
Michael D. Shook
Technical Analyst
Saddle Creek Corporation
Michael.Shook@saddlecrk.com
863 668 4477 (work)
863 860 4070 (cell)
863 665 1261 (fax)
www.saddlecrk.com
--------------------------------------
The information contained in this message is intended only for the use of the addressee. If the reader of this message is not the intended recipient or agent of the intended recipient, you are hereby notified that any dissemination, distribution, or copying of the message is strictly prohibited.
To unsubscribe send a message with UNSUBSCRIBE as subject to salive@woodstone.nu
If you use auto-responders (like out-of-the-office messages), then make sure that they are not send to the list nor to the individual members of the list that send a message. Doing this will get you removed from the list.
