January 2017 Email Metadata (Information Technology, South Carolina)

Matt Chapman - Free Our Info, NFP filed this request with the Information Technology, South Carolina of Charleston, SC.
Due July 25, 2018
Est. Completion None
Status
Awaiting Response

Communications

From: Matt Chapman - Free Our Info, NFP


To Whom It May Concern:

Pursuant to the South Carolina Public Records 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 15 business days, as the statute requires.

Sincerely,

Matt Chapman

From: Information Technology, South Carolina

Good Morning,

Please be advised that I have received your request and The City is working on processing it. If you should have any questions, please feel free to contact me.

Thank you,

Sam Kernodle|Paralegal
City of Charleston|Legal Department
50 Broad Street|Charleston, SC 29401
T:(843) 724-3730| kernodles@charleston-sc.gov | www.charleston-sc.gov<http://www.charleston-sc.gov/>
[SealCOCSignature]

From: Information Technology, South Carolina

Good Morning,

Please be advised that I have received your Freedom of Information Act ("FOIA") request and the City is working to gather any responsive information to your request.

The City of Charleston adheres to the South Carolina Freedom of Information Act, and we will provide you with responsive documents, if any, as soon as they are available but no later than 30 days from this date. If you should have any questions, please feel free to contact me.

Thank you,

Kelsey Sanna|Paralegal
City of Charleston|Legal Department
50 Broad Street|Charleston, SC 29401
T:(843) 727-4622| sannak@charleston-sc.gov<mailto:sannak@charleston-sc.gov> | www.charleston-sc.gov<http://www.charleston-sc.gov/>
[SealCOCSignature]

Information Technology, South Carolina
South Carolina Public Records Law Office
2 George Street Ste. 2800
Charleston, SC 29403

August 6, 2018

This is a follow up to a previous request:

To Whom It May Concern:

I wanted to follow up on the following South Carolina Public Records Law request, copied below, and originally submitted on July 18, 2018. Please let me know when I can expect to receive a response, or if further clarification is needed.

Thanks for your help, and let me know if further clarification is needed.

Filed via MuckRock.com
E-mail (Preferred): requests@muckrock.com<mailto:requests@muckrock.com>
Upload documents directly: https://www.muckrock.com/accounts/agency_login/information-technology-south-carolina-14849/information-wrt-dbmss-information-technology-south-carolina-58488/?uuid-login=79619ea7-8874-4e68-b0e1-ff922cb6301c&email=ratterreew%40charleston-sc.gov#agency-reply
Is this email coming to the wrong contact? Something else wrong? Use the above link to let us know.

For mailed responses, please address (see note):
MuckRock News
DEPT MR 58488
411A Highland Ave
Somerville, MA 02144-2516

PLEASE NOTE: This request is not filed by a MuckRock staff member, but is being sent through MuckRock by the above in order to better track, share, and manage public records requests. Also note that improperly addressed (i.e., with the requester's name rather than "MuckRock News" and the department number) requests might be returned as undeliverable.

---

On July 18, 2018:
To Whom It May Concern:

Pursuant to the South Carolina Public Records Law, I hereby request the following records:

For all DBMSs owned, maintained, operated, contracted with/through, or supported by the Information Technology - or similar - department(s) within your city, please provide me with the following information:

-Underlying engine (eg, postgres, mysql, mariadb, cockroachdb, Mongodb, Oracle database, sybase, MSAccess, SQL Server, VoltDB, RethinkDB, Chronos, Elasticsearch, etcd, cassandra, etc)
-Names of software that connect to each DBMS
-Names of departments that use information within the DBMS
-Schema of database (preferably, with granularity down to column names)
-Contract identifier for each database, if relevant

I understand that the information respondent to this request may require the creation of new documents - if that will be the case, then please provide me with documents that may contain the information (eg, documentation, contracts, etc). I am also happy to narrow the scope of my request if necessary.

Please also let me know if any help is needed with discovering any DBMS services. My background is in distributed systems systems administration and I can offer technical tips or advice if it would be helpful in any way.

The requested documents will be made available to the general public, and this request is not being made for commercial purposes. As I believe the information respondent to this request outweighs the costs and burden, I would like to kindly request a fee waiver.

I look forward to receiving your response to this request within 15 business days, as the statute requires.

With gratitude,
Matt Chapman,
Free Our Info, NFP

Filed via MuckRock.com
E-mail (Preferred): requests@muckrock.com<mailto:requests@muckrock.com>
Upload documents directly: https://www.muckrock.com/accounts/agency_login/information-technology-south-carolina-14849/information-wrt-dbmss-information-technology-south-carolina-58488/?uuid-login=79619ea7-8874-4e68-b0e1-ff922cb6301c&email=ratterreew%40charleston-sc.gov#agency-reply
Is this email coming to the wrong contact? Something else wrong? Use the above link to let us know.

For mailed responses, please address (see note):
MuckRock News
DEPT MR 58488
411A Highland Ave
Somerville, MA 02144-2516

PLEASE NOTE: This request is not filed by a MuckRock staff member, but is being sent through MuckRock by the above in order to better track, share, and manage public records requests. Also note that improperly addressed (i.e., with the requester's name rather than "MuckRock News" and the department number) requests might be returned as undeliverable.
[http://email.requests.muckrock.com/o/eJwNzEEOgyAQAMDXlFvJgrDCgYvRfqOhsFajSLpq-_06D5gcrEUxBw3KgQMEDwa0VFJpax69HboBu753eDPA9DlpP3ZZzrRwTYtMtYgp-OwgG_PC3HoYPcXsFRnAJtrW46gElTivzzmHFnXTaMGB43EQM9HvetMUeb3iut33JN_1-wcR3Sy4]

Files