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.
-----Urspr�ngliche Nachricht-----
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Jason Bohreer
Gesendet: Montag, 10. Mai 2004 19:34
An: [EMAIL PROTECTED]
Betreff: RE: [WhatsUp Forum] Logging into a SQL 2000 DatabaseAttached below is the script that I used to import my WhatsUp Stat logs into our SQL database.
A couple of things:
1. You must have a DSN setup pointing to your SQL server on the machine where this script is run. Ours is called ITMaster, but you can change that near the top of the script.
2. You must specify the username and password for the DSN connection. Needless to say, make sure the script is stored in a secured location. I have my script run every day, and thus was the reason for having the credentials stored in the script.
3. The script was designed such to be able to 'scrub' the data from the database table and reimport without tweaking the script. The script will examine every log file each time it runs, and determine if it needs to import information into the database. This also means that the script could be run multiple times a day and only add the new records
4. I use Cscript as my default scripting shell. However, Windows defaults to Wscript. If you have quite a few log files, Wscript will display a message box for each log file it finds, and wait for your acknowledgement. Cscript will just open a command prompt window and display them all non-stop. You can either change your default by typing the following at a command prompt:
a. Cscript //h:cscript
i. or, run the script using the following:
b. Cscript WhatsUpStatImport.vbs "\\BogusServer\d$\Program Files\WhatsUp Gold Logs"With the information in SQL, it is MUCH easier to generate your own set of reports via SQL statements and Excel pivot tables� I'm just hoping the WhatsUp will design the next version to use some form of database for its log storage. Till then, let me know what you think about this script�
-jb
<<WhatsUpStatImport.txt>>
