• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Help viewing logs - Network admins please help

R

reicherb

Platinum Member
I'm hoping one of you brilliant network admins can help me.

I'm trying to sort my BorderManager logs. Below is a sample line.
10.152.10.237 - .jszappan.HS.CHESANING [22/Nov/2001:08:44:55 -0500] "GET http://www.yahoo.com/ HTTP/1.0" 200 19336

They are sorted based on time of request.

I'd like to sort them by user name ".jszappan.HS.CHESANING" so I tried to open the file in excel but my logs are 30-50MB and Excel can't open the whole thing.

How do you guys sort logs or don't you?

Thanks for your help.
 
Perl scripting, my friend.

Practice makes perfect....also tail, and grep can be your friends too.

--Woodie
 
Tis a grand idea however, (yes there is always a however), I don't think that perl is available in a Netware Environment (It's all we got) and I don't currently have the time or resources to setup a *NIX box.

Any other ideas?

Thanks
 
In NetWare?? Oh. What OS is your client? There are perl ports for many platforms...I actually use NT/W2K/XP as my primary, and perl works just fine for me. Granted, tail & grep aren't available 🙁.

Seriously.....have your log file closed periodically...then run a perl script against it to copy it local, parse what you want out, get your stats, whatever, and if you want, format the summary part for an excel import.

--Woodie
 
The clients are all win98 and the log file is closed daily. Is there some version of perl that will run on a 9x platform? Is it any good if there is no grep?

Thanks again.
 
Actually, there are ports of nearly every *nix command line tool to Windows. It took about 10 seconds to find Grep for Windows.


Grab something like this and you can easily search your logs for what you're looking for. There are also a lot of specialty log analyzer apps (ie Webtrends) out there to help you analyze them in more detail. One catch is that your log file has to be somewhat standard and I'm not sure how BorderManager works.

You might also look for a TAIL command for Windows and split your log file up into chunks of < 17,000 lines which you could then import into Excel.

- G
 
Thanks Garion! I had heard that the windows grep ports didn't work terribly well. I have an actual need for this, so I will be testing shortly!

Now, to find Tail, to complete the process.

--Woodie
 
Ok guys you've got me on the right track.

I used grep to search for sites or users but is there a way to use it to look for ranges? My shell skills aren't too sharp anymore (if they ever were).

I'm sure that I've done it. Maybe it took other commands beside grep. I am just at a loss. I don't even have any of my old reference links for *NIX command anymore.

Do you guys have any idea what to try?

Thanks.
 
Brad...YHEM.


and to answer one of your original questions: No, we don't sort logs. We query (search) them for the piece(s) of data we need.


--Woodie
 
Richard (Woodie):

Thanks for the E-mail.




<< and to answer one of your original questions: No, we don't sort logs. We query (search) them for the piece(s) of data we need. >>



No, You may want to query your logs however, I would simply like to sort this specific log.

It looks like writing a small C program is my best way to accomplish sorting an/or querying this log. Just input a file, parse the file, and write the output to a new file.

Thanks,
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top