Sponsored Content
Special Forums Windows & DOS: Issues & Discussions Question; AWK to analyze Windows Server 2k3 logs Post 302425987 by pludi on Monday 31st of May 2010 08:03:08 AM
Old 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

Windows Server 2k3 vs. Unix

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

accessing windows 2k3 partition from Linux Advance Server 3

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

How to view the unix logs in windows ??

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

Logs access in windows fetching the data from a unix server

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

which is the best online tool to analyze vmstat logs

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

(yet another) copy files from windows to server question

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

How to send AIX logs to windows

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

Unix shell script to Copy files from one Windows server to another Windows server.

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

Perl script to parse multiple windows event logs.

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

Monitoring windows logs

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
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)
All times are GMT -4. The time now is 06:37 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy