We're allowed to bill for requests that take a significant amount of time to respond to. But I can't invoice the requestor until I have an idea of how long it will take, which I can't do until I know how to do it.
I've spent probably 30-45 minutes doing preliminary research. But if the export to CSV or findstr methods work, I think the meat of the work will only take maybe 15 minutes. We might can charge them for an hour of my time. >From what I can tell, they've made this request of multiple Florida districts. >Possibly every district in the state. That has happened before when >organizations wanted to test everyone's compliance with sunshine laws. John From: Jonathan Link [mailto:jonathan.l...@gmail.com] Sent: Tuesday, October 04, 2011 4:34 PM To: MS-Exchange Admin Issues Subject: Re: Listing Senders' E-mail Addresses Do you guys have a mechanism for billing this? Don't forget that this isn't an insubstantial request, and reasonable fees can and should be charged to cover time to do this... Not suggesting $30,000 or something like that... Your daily rate prorated to the time spent should be reasonable... On Tue, Oct 4, 2011 at 4:15 PM, John Hornbuckle <john.hornbuc...@taylor.k12.fl.us<mailto:john.hornbuc...@taylor.k12.fl.us>> wrote: Thanks! I'll give this a shot. Also, someone e-mailed me off the list and said PST's could be exported to CSV's (and then imported into Excel and manipulated from there), so that may be an option as well. John -----Original Message----- From: Kurt Buff [mailto:kurt.b...@gmail.com<mailto:kurt.b...@gmail.com>] Sent: Tuesday, October 04, 2011 3:56 PM To: MS-Exchange Admin Issues Subject: Re: Listing Senders' E-mail Addresses Findstr is the poor equivalent of grep in the Windows world - powershell is much more powerful, but findstr will do what you want. For instance, you could use the following: c:\temp\>findstr /c:"From: " c:\temp\archive.mbox > out.txt to list all of the From: lines in the mbox file. A quick search and replace to get rid of the "From:" on each line, and you're pretty much done. Kurt On Tue, Oct 4, 2011 at 12:36, John Hornbuckle <john.hornbuc...@taylor.k12.fl.us<mailto:john.hornbuc...@taylor.k12.fl.us>> wrote: > No, with Postini you just pick the date range, sender(s), and recipient(s) > and it spits out the list of messages matching the criteria. > > Never used grep before, but I can read directions. :) > > > John > > > > -----Original Message----- > From: Kurt Buff [mailto:kurt.b...@gmail.com<mailto:kurt.b...@gmail.com>] > Sent: Tuesday, October 04, 2011 2:24 PM > To: MS-Exchange Admin Issues > Subject: Re: Listing Senders' E-mail Addresses > > My first thought would be to export the messages to the account in question > to mbox format, then grep/findstr for the "From:" header. > Should take just a few minutes. The constraint that some messages are > confidential makes it more difficult. > > Is there a way to export only the non-confidential emails? > > Kurt > > On Tue, Oct 4, 2011 at 11:18, John Hornbuckle > <john.hornbuc...@taylor.k12.fl.us<mailto:john.hornbuc...@taylor.k12.fl.us>> > wrote: >> We've had a somewhat unusual public records request: Someone has >> asked for a list of e-mail addresses of senders of messages to a >> specific user in our organization. They don't want the actual >> messages-just a list of who sent them. They're requesting this for a period >> covering more than a year. >> >> >> >> We use Postini for archiving, so all of the messages are there. >> However, it doesn't have a mechanism for generating a report that >> only contains the senders of those messages. I can retrieve all of >> the messages themselves in either MBOX or PST format from Postini, but the >> rest is up to me. >> >> >> >> There are somewhere around 10,000 messages. If all of the messages >> were public record, I'd just give them to the requestor and be done. >> But they're not, so we either need to delete all confidential >> messages before providing the rest to the requestor, or go through >> all of the messages ourselves and document the sender of each one. >> >> >> >> If we wanted to do the latter-extract the senders of messages from an >> MBOX or PST file-is there a relatively painless way to do this? >> >> >> >> >> >> >> >> John Hornbuckle, MSMIS, PMP >> >> MIS Department >> >> Taylor County School District >> >> www.taylor.k12.fl.us<http://www.taylor.k12.fl.us> >> >> >> >> >> >> --- >> To manage subscriptions click here: >> http://lyris.sunbelt-software.com/read/my_forums/ >> or send an email to >> listmana...@lyris.sunbeltsoftware.com<mailto:listmana...@lyris.sunbeltsoftware.com> >> with the body: unsubscribe exchangelist > > --- > To manage subscriptions click here: > http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to > listmana...@lyris.sunbeltsoftware.com<mailto:listmana...@lyris.sunbeltsoftware.com> > with the body: unsubscribe exchangelist > > > --- > To manage subscriptions click here: > http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to > listmana...@lyris.sunbeltsoftware.com<mailto:listmana...@lyris.sunbeltsoftware.com> > with the body: unsubscribe exchangelist --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com<mailto:listmana...@lyris.sunbeltsoftware.com> with the body: unsubscribe exchangelist --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com<mailto:listmana...@lyris.sunbeltsoftware.com> with the body: unsubscribe exchangelist --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com<mailto:listmana...@lyris.sunbeltsoftware.com> with the body: unsubscribe exchangelist --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe exchangelist
