The log files are just plain text, so it is rather simple to write a script that opens up each ST*.tab file in a directory and then parse through each line and insert the information into a SQL database. My SQL table is essentially:
ID Int(4) DataTime Datetime(8) Map Varchar(100) DeviceName Varchar(50) RTT int(4) MaxRTT int(4) MinRTT int(4) DownTime int(4) If you are interested in taking a look at my script (VBS), let me know... 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. -----Original Message----- From: Ahja, Alen [mailto:[EMAIL PROTECTED] Sent: Sunday, May 09, 2004 23:26 To: [EMAIL PROTECTED] Subject: [WhatsUp Forum] Logging into a SQL 2000 Database Hi @ all! It is possible to log all the data into a MS SQL 2000 Database? When yes, how does it work? Mit freundlichen Gr��en / Kind regards, A l e n A h j a _________________________________________ Union Agricole Holding AG Technical Support - Infomanagement - CCP An der M�hlenau 4 - 25421 Pinneberg Fon: +49 (0) 4101 218-107 Fax: +49 (0) 4101 218-8107 e-Mail: [EMAIL PROTECTED] Diese E-Mail, einschlie�lich s�mtlicher mit ihr �bertragenen Dateien, ist vertraulich und f�r die ausschlie�liche Verwendung durch die Person oder das Unternehmen vorgesehen, an die/das sie adressiert ist. F�r den Inhalt dieser E-Mail ist alleine der Urheber verantwortlich, Inhalt und Meinung m�ssen nicht die Ansicht der Firma Union Agricole Holding AG wiedergeben. Sollten Sie diese E-Mail f�lschlicherweise erhalten haben, benachrichtigen Sie bitte Ihren Systemadministrator. Diese E-Mail wurde auf die Anwesenheit von Computer-Viren �berpr�ft. This E-mail, including all with their transferred files, is intended confidentially and for the exclusive use by the person or the enterprise to which/she is addressed. Only the author is responsible for the content of this E-mail, content and opinion must not return the view of the company Union Agricole Holding AG. If you should have got this E-mail wrongly, please, inform your Systemadministrator. This E-mail was checked on the presence by computer viruses. 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/ _________________________________________________ Scanned on 10 May 2004 06:26:01 Scanning by http://erado.com 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/
