Morning all,
Okay, here's the situation ("my parents went away on a..." Stoppit,
Laura, you're having an '80s flashback):
I have an Exchange 2000 mailbox set up as a drop-box for general
customer service support inquiries for my office. The manager of the CS
area wants to keep track of how many messages are sent to the drop-box
so that she can have a pretty chart to show off at Senior Staff
meetings. :-) The solution that's currently in place is this: every
message that comes into the drop-box is copied into a "Statistics"
sub-folder. The messages in the Inbox are forwarded/replied to/deleted
as necessary, and the CS manager exports the ~\Statistics folder to an
Excel spreadsheet or some such.
This strikes me as being a really kludgey solution, since every 6 months
or so I need to call her with "You know, there are like 30,000 messages
in the Statistics folder, you might want to think about deleting them if
you've captured the information you need."
Is there something script-y that I can do that will...(this is my idea,
but I'm open to suggestions)...add a record to a SQL table every time a
message hits the Inbox? That way the metadata is captured in a way
that's conducive to searching/querying/reporting, and is a lot more
elegant than what's currently happening.
I'm not a script-maven by any stretch, so if there were even some
Shake-n-Bake code out there that I could start with (from Robbie or
someone), that would make me quite the happy network admin.
("Laura, learn how to do scripting, it'll make you a much better admin."
I know, I know, it's on my list.)
*********************************************
Laura E. Hunter
MCT, MCSE: Security, MVP - Windows Networking
Senior IT Specialist
University of Pennsylvania
********************************************
This email message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not
the intended recipient, please contact the sender by reply email,
destroy all copies of the original message, and repent! Repent!
Any views expressed in this email message, well-informed and
intellectually unassailable as they may be, are those of the individual
sender except where the sender specifically states them to be the views
of Student Financial Services.
List info : http://www.activedir.org/mail_list.htm
List FAQ : http://www.activedir.org/list_faq.htm
List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
