Jason That is perfect - it is something we can give to the end users too (We very much like being transparent / visible to our user community here).
I would very much appreciate your script, I do like the idea of storing the info in SQL. Christian p.s. I also automatically added a read receipt to my original e-mail (sorry) and I can see it also added our default footer. I will try and get that removed in future postings. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jason Bohreer Sent: 30 December 2003 17:33 To: [EMAIL PROTECTED] Subject: RE: [WhatsUp Forum] New user and question on reporting While I don't have nearly the level of sites that you do, we have quite a few devices that we monitor in multiple sites. I was looking for a method to compare a devices availability to itself over months (as well as relate to the other devices), but couldn't find a way to do it without manually compiling the information. So I spent a little time examining the format of the ST*.tab files and decided to import them into an SQL database for better post processing. In a nutshell, I have a script that imports the values of the ST files into an SQL table. I then can use a web page & SQL query to determine the availability of the systems over months. I've attached an example of my reports page. If this is kinda what your looking for, let me know and I'll forward over the code for the import & ASP reporting. -jb Jason M. Bohreer, MCSA Network Administrator Nastech Pharmaceutical 3450 Monte Villa Parkway Bothell, WA 98021 (425) 908-3657 --------------------------- This email or fax and any attachments thereto may contain private, confidential, and privileged material for the sole use of the intended recipient. Any review, copying, or distribution of this email (or any attachments thereto) by others is strictly prohibited. If you are not the intended recipient, please contact the sender immediately and permanently delete the original and any copies of this email and any attachments thereto. -------------------------------------------------------------------------------- The Salvation Army is an international Christian church working in 109 countries worldwide. As a registered charity, The Salvation Army demonstrates its Christian principles through social action and is one of the largest, most diverse providers of social welfare in the world. Visit our ever-growing website to find out what The Salvation Army is doing across the United Kingdom and Ireland... and near you - www.salvationarmy.org.uk. -------------------------------------------------------------------------------- Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any system and destroy any copies. Thank You. -------------------------------------------------------------------------------- Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/
