January 2017 Email Metadata (Information Technology, Florida)

Matt Chapman - Free Our Info, NFP filed this request with the City of Jacksonville of Jacksonville, FL.
Est. Completion None
Awaiting Response


From: Matt Chapman - Free Our Info, NFP

To Whom It May Concern:

Pursuant to the Florida Sunshine Law, I hereby request the following records:

For all accounts managed by your department, please provide me the following information for all emails sent during January, 2017:

1. From address
2. To address
3. bcc addresses
4. cc addresses
5. Time
6. Date

Please note that I am not requesting the contents of each email.

I am more than happy to provide documentation or tips for extracting this information from your mail server if needed. Documentation that I have available include methods using excel, powershell, msaccess, Office 365 eDiscovery tools, and the direct extraction from an exchange database using forensic analysis tools.

The requested documents will be made available to the general public, and this request is not being made for commercial purposes.

In the event that there are fees, I would be grateful if you would inform me of the total charges in advance of fulfilling my request. I would prefer the request filled electronically, by e-mail attachment if available or CD-ROM if not.

Thank you in advance for your anticipated cooperation in this matter. I look forward to receiving your response to this request within 10 business days.


Matt Chapman

From: City of Jacksonville

To Whom it May Concern,

The Office of the City Council is in receipt of your request. As an initial matter, please note that that City does not have to extract emails and then create a document, as Florida's Public Records law only requires the City to produce records as they currently exist.

If you are seeking all emails from this time period, that will likely produce a large amount of information and could be a costly request as all emails will have to be reviewed and redacted for possible exempt information. We would provide you with an invoice for charges before any review of emails. However, would you like to narrow or further clarify your request to possibly reduce the number of emails?

Thank you.

Paige H. Johnston
Chief of Legislative Affairs
Office of General Counsel
117 W. Duval Street, Suite 480
Jacksonville, FL 32202
(904) 630-3671 - direct
(904) 630-1731 - fax
E-mail - Pjohnston@coj.net<mailto:Pjohnston@coj.net>

From: Matt Chapman - Free Our Info, NFP

Thank you for your response.

The requested information can be extracted from the email server directly. Within the email database itself, and for the same reason that an email body is considered public record, so are the metadata records that are responsive to this request. In other words, there is no need to extract the information from any emails to the extent that would create new records, as those records already exist.

Here are two methods using powershell which can be used to extract the information.

get-messagetrackinglog -Start "1/1/2017 00:00:00 AM" -End "2/1/2017 00:00:00 AM" | select timestamp, sender, {$_.recipients} | export-csv c:\results.csv`
- Should Transaction logs not go back to Jan 1 2017, the following can be used instead:
`Get-Mailbox | Search-Mailbox -SearchQuery "(received>=01/01/2017 AND received>=01/02/2017) OR (sent>=01/01/2017 AND sent>=01/02/2017)" -LogOnly -LogLevel Full`

If you would prefer a method of retrieving the records directly from within excel, I can provide documentation for that as well.

Regards -


There are no files associated with this request.