05-31-2010
Quote:
Originally Posted by abciscool
* Is it (even) possible to filter W2k3 Evenlogs with AWK?
Directly? I doubt it. I do know that it's possible to export the eventlog data to text files, but I wouldn't know how to (possibly) automate this. awk itself can only operate on text data.
Quote:
Originally Posted by abciscool
* How would I go "defining" the structure of the Eventlog within AWK?
Exported, it's a simple CSV file.
Quote:
Originally Posted by abciscool
Secondly, questions about the implementing of AWK within an Access 2007-database(wierd, I know):
* Is this even possible?!
Maybe as an extension. But I doubt that this would be doable by a single person on a 2 weeks deadline.
Quote:
Originally Posted by abciscool
* If yes, how would go about doing this? If no, why?
Again, it might be possible as an extension-DLL. Or maybe even using a VBscript macro. But not with a 2 weeks deadline.
Quote:
Originally Posted by abciscool
* How would Access know how to interpet a AWK script?
It doesn't.
You might be a lot faster if you wrote a small awk script to transform the exported data to a format compatible with the existing "database", import the file(s) directly, and do any statistics inside the DB using SQL.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Are there any major differences in performance?
Does any large corperation actually use Windows Server software instead of Unix for massive production jobs?
i.e., could Amazon run their website on Win2k3 and IIS instead of Unix (and whatever web server they use)? (1 Reply)
Discussion started by: CapsuleCorpJX
1 Replies
2. Red Hat
Dear all
i hav dual operating system ie windows 2003 and Red Hat Advance Server3
trying to mount windows partition on linux operating system using the following method
1)mkdir /mnt/windows
2)mount -t ntfs /dev/hda1 /mnt/windows
mount: fs type ntf not supported by kernel
and my kernel... (2 Replies)
Discussion started by: maooah
2 Replies
3. UNIX for Advanced & Expert Users
Hi !
I have a FTP site, where I softlinked my server log file.
Now I want to view the logs in IE as I do in unix
Some kind of free tool should be there, Can somebody provide me a pointer.
Thanks. (0 Replies)
Discussion started by: dashok.83
0 Replies
4. Shell Programming and Scripting
How I can get the logs that are getting stored in specific location in unix server
through an Apache web server installed in unix server?
Requirement is to access the logs through the URL in windows browser without any access. (1 Reply)
Discussion started by: alvida
1 Replies
5. UNIX for Dummies Questions & Answers
hi all
which is best online tool to analyze the vmstat logs to measure the cpu performance (2 Replies)
Discussion started by: din_annauniv
2 Replies
6. Shell Programming and Scripting
Hi all,
I spent the last few hours Googling for a solution without result, so here goes:
I have Windows server 'source' that produces files that need to be copied to an external Linux server 'target'. I initiate this process from AIX server 'jobrunner'. An additional step is a Linux server... (2 Replies)
Discussion started by: whbos
2 Replies
7. AIX
good day all
how to send aix syslogs to a shared folder in windows
regards , (2 Replies)
Discussion started by: thecobra151
2 Replies
8. Shell Programming and Scripting
Can anybody please help me on how to code for the below requirement:
I need to write a shell script (on different unix server) to copy files from multiple folders (ex. BRN-000001) from one windows server (\\boldls-mwe-dev4)to a different windows server(\\rrwin-ewhd04.ecomad.int). This shell... (4 Replies)
Discussion started by: SravsJaya
4 Replies
9. Shell Programming and Scripting
Hi all,
I am developing a log parsing agent in perl to send windows Event logs to Zenoss Monitoring tool. Using Win32::EventLog i can able to get the Event messages but only one Eventype eg Application or System could able to parse at a time. Can you please help to how to open mutiple eventlogs... (3 Replies)
Discussion started by: kar_333
3 Replies
10. UNIX for Dummies Questions & Answers
is it possible to monitor log files that are on a windows server, from a linux/unix host?
i'm thinking that the directory that the files are located in on windows can be be mounted on the linux host, and then a script or tool can just monitor the log as though it were local?
any thing wrong... (3 Replies)
Discussion started by: SkySmart
3 Replies
LEARN ABOUT MOJAVE
datetime::timezone::local::win32
DateTime::TimeZone::Local::Win32(3) User Contributed Perl Documentation DateTime::TimeZone::Local::Win32(3)
NAME
DateTime::TimeZone::Local::Win32 - Determine the local system's time zone on Windows
VERSION
version 1.63
SYNOPSIS
my $tz = DateTime::TimeZone->new( name => 'local' );
my $tz = DateTime::TimeZone::Local->TimeZone();
DESCRIPTION
This module provides methods for determining the local time zone on a Windows platform.
HOW THE TIME ZONE IS DETERMINED
This class tries the following methods of determining the local time zone:
o $ENV{TZ}
It checks $ENV{TZ} for a valid time zone name.
o Windows Registry
When using the registry, we look for the Windows time zone and use a mapping to translate this to an Olson time zone name.
o Windows Vista and 2008
We look in "SYSTEM/CurrentControlSet/Control/TimeZoneInformation/" for a node named "/TimeZoneKeyName". If this exists, we use
this key to look up the Olson time zone name in our mapping.
o Windows NT, Windows 2000, Windows XP, Windows 2003 Server
We look in "SOFTWARE/Microsoft/Windows NT/CurrentVersion/Time Zones/" and loop through all of its sub keys.
For each sub key, we compare the value of the key with "/Std" appended to the end to the value of
"SYSTEM/CurrentControlSet/Control/TimeZoneInformation/StandardName". This gives us the English name of the Windows time zone,
which we use to look up the Olson time zone name.
o Windows 95, Windows 98, Windows Millenium Edition
The algorithm is the same as for NT, but we loop through the sub keys of "SOFTWARE/Microsoft/Windows/CurrentVersion/Time
Zones/"
AUTHOR
Dave Rolsky <autarch@urth.org>
COPYRIGHT AND LICENSE
This software is copyright (c) 2013 by Dave Rolsky.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
perl v5.18.2 2013-10-28 DateTime::TimeZone::Local::Win32(3)