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
SHELL-QUOTE(1)						User Contributed Perl Documentation					    SHELL-QUOTE(1)

NAME
shell-quote - quote arguments for safe use, unmodified in a shell command SYNOPSIS
shell-quote [switch]... arg... DESCRIPTION
shell-quote lets you pass arbitrary strings through the shell so that they won't be changed by the shell. This lets you process commands or files with embedded white space or shell globbing characters safely. Here are a few examples. EXAMPLES
ssh preserving args When running a remote command with ssh, ssh doesn't preserve the separate arguments it receives. It just joins them with spaces and passes them to "$SHELL -c". This doesn't work as intended: ssh host touch 'hi there' # fails It creates 2 files, hi and there. Instead, do this: cmd=`shell-quote touch 'hi there'` ssh host "$cmd" This gives you just 1 file, hi there. process find output It's not ordinarily possible to process an arbitrary list of files output by find with a shell script. Anything you put in $IFS to split up the output could legitimately be in a file's name. Here's how you can do it using shell-quote: eval set -- `find -type f -print0 | xargs -0 shell-quote --` debug shell scripts shell-quote is better than echo for debugging shell scripts. debug() { [ -z "$debug" ] || shell-quote "debug:" "$@" } With echo you can't tell the difference between "debug 'foo bar'" and "debug foo bar", but with shell-quote you can. save a command for later shell-quote can be used to build up a shell command to run later. Say you want the user to be able to give you switches for a command you're going to run. If you don't want the switches to be re-evaluated by the shell (which is usually a good idea, else there are things the user can't pass through), you can do something like this: user_switches= while [ $# != 0 ] do case x$1 in x--pass-through) [ $# -gt 1 ] || die "need an argument for $1" user_switches="$user_switches "`shell-quote -- "$2"` shift;; # process other switches esac shift done # later eval "shell-quote some-command $user_switches my args" OPTIONS
--debug Turn debugging on. --help Show the usage message and die. --version Show the version number and exit. AVAILABILITY
The code is licensed under the GNU GPL. Check http://www.argon.org/~roderick/ or CPAN for updated versions. AUTHOR
Roderick Schertler <roderick@argon.org> perl v5.16.3 2010-06-11 SHELL-QUOTE(1)
All times are GMT -4. The time now is 08:22 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy