[Modus] sql scripts

[Michael B. Smith]

Title: Message

I guess I'm looking for, in general:

 

1) Ways to give me the SIGNIFICANT errors out of the ERR log (I've gotten some traction using awk/sed/grep, but those are painful and remind me of college 20 years ago) and SVR3 and BSD4.1 (yes, I'm that old). Maybe I should learn perl or what's-that-other-new-fangled scripting language? Python? Boa? Who knows? ;-)

 

2) Daily totals that actually mean something from OPR, SIEVE, and VIRUS logs

 

3) User reports and counts that mean something from the database.

 

TOp 10's sound like a good place to start. They would at least give me some ideas.

 

I gotta admit, everything I start out with seems to begin "select trim(emailaddress)..." or VERY similar

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jim Barstow
Sent: Tuesday, February 03, 2004 5:19 PM
To: [EMAIL PROTECTED]
Subject: [Modus] sql scripts

Im still working on the star-base, but the moon-base one is next on the list.

 

I have some "top 10 scripts" that were originally written for modus2 by someone else in here, and I ported them over to work with modus3.

 

Top 10 filters, top 10 receivers, etc.  If you have ideas on what you want counted, I can write scripts for them (of course, they have to make sense so I can pretend I wrote them for myself), but I always share whatever I have.

 

Sr. Network Engineer
Diversified Solutions and Services, Inc.

22645 Canal Road, Suite B

Orange Beach, AL 36561

(251)980-8968

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael B. Smith
Sent: Tuesday, February 03, 2004 3:52 PM
To: [EMAIL PROTECTED]
Subject: [Modus] sql scripts

Just stuff for counting stuff, statistics, etc.

 

It wouldn't be even nicer if it would build a moon-base, but hey, I'm flexible.

---

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Barstow
Sent: Tuesday, February 03, 2004 4:36 PM
To: [EMAIL PROTECTED]
Subject: [Modus] sql scripts

I have some collected scripts.. what are you looking for?

 

 

Sr. Network Engineer
Diversified Solutions and Services, Inc.

22645 Canal Road, Suite B

Orange Beach, AL 36561

(251)980-8968

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael B. Smith
Sent: Tuesday, February 03, 2004 3:13 PM
To: [EMAIL PROTECTED]
Subject: [Modus] sql scripts

another fine question ---

 

i find myself writing lots of little sql scripts to figure things out. is there a collection somewhere of where people might have collected scripts for modus?