January 2017 Email Metadata (Information Technology, Nevada)

Matt Chapman - Free Our Info, NFP filed this request with the Information Technology, Nevada of Las Vegas, NV.
Tracking #

W011804-072418

Multi Request January 2017 Email Metadata
Status
Completed

Communications

From: Matt Chapman - Free Our Info, NFP


To Whom It May Concern:

Pursuant to the Nevada Public Records Act, 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 5 business days, as the statute requires.

Sincerely,

Matt Chapman

From: Information Technology, Nevada

Dear Matt Chapman,

Thank you for your interest in public records of the City of Las Vegas. Your request was received on 7/11/2018 and is being processed. We will respond within five business days by providing one of the following:

1. We will complete the request by providing the requested records,
2. We will provide you with the estimated date of completion of your request,
3. We will provide a partial installment and inform you of the schedule of future installments,
4. We will ask for clarification if your request is unclear,
5. We will direct you to the City's website to access the records requested, or
6. We may deny the request because no responsive records exist.

Record Requested: 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.

Matt we are looking into your request. You do mention that you are willing to provide documentation or tips for extracting this information. We would be interested in these documents and/or tips you are referring to. Can you please provide them please?

Thank you.

Tyler Gutierrez
Legal Records Specialist
City Attorney's Office - Civil
(702) 229 - 6926
495 South Main Street, 6th Floor | Las Vegas, NV 89101
[cid:image001.png@01D34D8E.A1C84DB0]
lasvegasnevada.gov<https://www.lasvegasnevada.gov/>
[cid:image002.png@01D34D8E.A1C84DB0]<https://www.facebook.com/CityOfLasvegas>[cid:image003.png@01D34D8E.A1C84DB0]<https://twitter.com/cityoflasvegas>[cid:image004.png@01D34D8E.A1C84DB0]<https://www.instagram.com/cityoflasvegas>[cid:image005.png@01D34D8E.A1C84DB0]<https://www.snapchat.com/cityoflasvegas>

From: Matt Chapman - Free Our Info, NFP

Absolutely!

From your email headers, it looks like your office is using Office 365. The below documentation was recently helpful for another agency that also uses Office 365.

Let me know if this documentation isn't fully helpful, or is unclear in any way. I am more than happy to provide further documentation where necessary.

0. Username must have access to search and export eDiscovery reports. If not, your IT department should have access to either grant the required permissions, or run through these steps themselves.
1. From Internet Explorer, log into https://protection.office.com/.
2. Navigate to "Search & Investigation" -> "eDiscovery" and create a new case.
3. Open the case, then create a new search through "Search" -> "New search"
4. Add a "Type" condition and select, "E-mail messages".
5. Under "Locations" -> "Specific locations" -> "Modify...".
6. Toggle the location that includes "Exchange email" and click "Save".
7. Click "Save & run" and give the search a name.
8. Navigate to "More" -> "Export results", then select the following options:
-Output options: "All items, excluding [...]"
-Export Exchange content as: "Individual messages"
9. Navigate to Export -> "[Name of export]_Export".
10. Click "Download results" and launch the "Unified Export Tool".
11. Paste the export page's "Export key" into the tool's key field.
12. Choose a save location and click "Start"
13. Open "results.csv" from the saved location.
14. Delete all columns that are not the requested metadata and save.

From: Information Technology, Nevada

Thank you Matt. I have forwarded this to our IT department. I will let you know if they find the information beneficial or need any clarification.

Tyler Gutierrez
Legal Records Specialist
City Attorney's Office - Civil
(702) 229 - 6926
495 South Main Street, 6th Floor | Las Vegas, NV 89101
[cid:image001.png@01D34D8E.A1C84DB0]
lasvegasnevada.gov<https://www.lasvegasnevada.gov/>
[cid:image002.png@01D34D8E.A1C84DB0]<https://www.facebook.com/CityOfLasvegas>[cid:image003.png@01D34D8E.A1C84DB0]<https://twitter.com/cityoflasvegas>[cid:image004.png@01D34D8E.A1C84DB0]<https://www.instagram.com/cityoflasvegas>[cid:image005.png@01D34D8E.A1C84DB0]<https://www.snapchat.com/cityoflasvegas>

From: Information Technology, Nevada

Good morning Matt,

I have spoken with IT. In January 2017 we were not using Office 365, so the instructions given to us of no use unfortunately. Do you have any other tips that may work? In specific, we may have to pull this information from the Archive Manager since it is so old. Are you familiar with Archive Manager?

Look forward to hearing from you.

Thank you.

Tyler Gutierrez
Legal Records Specialist
City Attorney's Office - Civil
(702) 229 - 6926
495 South Main Street, 6th Floor | Las Vegas, NV 89101
[cid:image001.png@01D34D8E.A1C84DB0]
lasvegasnevada.gov<https://www.lasvegasnevada.gov/>
[cid:image002.png@01D34D8E.A1C84DB0]<https://www.facebook.com/CityOfLasvegas>[cid:image003.png@01D34D8E.A1C84DB0]<https://twitter.com/cityoflasvegas>[cid:image004.png@01D34D8E.A1C84DB0]<https://www.instagram.com/cityoflasvegas>[cid:image005.png@01D34D8E.A1C84DB0]<https://www.snapchat.com/cityoflasvegas>

From: Matt Chapman - Free Our Info, NFP

Thank you for letting me know. I will look into this and let you know sometime over the next couple days.

From: Matt Chapman - Free Our Info, NFP

I'm not very familiar with Archive Manager, but through research it looks like there are two pieces of software with the same names: one from Metalogix and one from Quest. Which one is Las Vegas using?

Both of them appear to have backends that support SQL, though. Perhaps the IT department can look into the database schemas and see if the tables include the metadata responsive to this request. I can help write the query, but neither software companies release information about their database schemas, so I'd likely have to work with someone over email/phone if help's needed there. That said, working directly with the company that provides the software may ultimately be the better route.

From: Information Technology, Nevada

Thanks for the response Matt. It is the Archive Manager by Quest that the city is using. I have copied Scott into the chain, who is our email guy. With my limited knowledge, We may have to pull the emails and manually redact the contents of the emails?

Tyler Gutierrez
Legal Records Specialist
City Attorney's Office - Civil
(702) 229 - 6926
495 South Main Street, 6th Floor | Las Vegas, NV 89101
[cid:image001.png@01D34D8E.A1C84DB0]
lasvegasnevada.gov<https://www.lasvegasnevada.gov/>
[cid:image002.png@01D34D8E.A1C84DB0]<https://www.facebook.com/CityOfLasvegas>[cid:image003.png@01D34D8E.A1C84DB0]<https://twitter.com/cityoflasvegas>[cid:image004.png@01D34D8E.A1C84DB0]<https://www.instagram.com/cityoflasvegas>[cid:image005.png@01D34D8E.A1C84DB0]<https://www.snapchat.com/cityoflasvegas>

From: Information Technology, Nevada

Matt just for clarification. Are you asking for emails for our IT department or the whole data base for the January 2017 timeframe?

Tyler Gutierrez
Legal Records Specialist
City Attorney's Office - Civil
(702) 229 - 6926
495 South Main Street, 6th Floor | Las Vegas, NV 89101
[cid:image001.png@01D34D8E.A1C84DB0]
lasvegasnevada.gov<https://www.lasvegasnevada.gov/>
[cid:image002.png@01D34D8E.A1C84DB0]<https://www.facebook.com/CityOfLasvegas>[cid:image003.png@01D34D8E.A1C84DB0]<https://twitter.com/cityoflasvegas>[cid:image004.png@01D34D8E.A1C84DB0]<https://www.instagram.com/cityoflasvegas>[cid:image005.png@01D34D8E.A1C84DB0]<https://www.snapchat.com/cityoflasvegas>

From: Matt Chapman - Free Our Info, NFP

Nope - I'm only looking for the email metadata (to/from/cc/bcc/times) and NOT the contents (subject/body) of the emails themselves. As such, the redaction process - if any - should keep that in mind.

Matt

From: Information Technology, Nevada

Correct I understand that part of the request. My question is this: for the email metadata do you want the data solely from our IT employees or the metadata for the entire data base (all employees).

Tyler Gutierrez
Legal Records Specialist
City Attorney's Office - Civil
(702) 229 - 6926
495 South Main Street, 6th Floor | Las Vegas, NV 89101
[cid:image001.png@01D34D8E.A1C84DB0]
lasvegasnevada.gov<https://www.lasvegasnevada.gov/>
[cid:image002.png@01D34D8E.A1C84DB0]<https://www.facebook.com/CityOfLasvegas>[cid:image003.png@01D34D8E.A1C84DB0]<https://twitter.com/cityoflasvegas>[cid:image004.png@01D34D8E.A1C84DB0]<https://www.instagram.com/cityoflasvegas>[cid:image005.png@01D34D8E.A1C84DB0]<https://www.snapchat.com/cityoflasvegas>

From: Matt Chapman - Free Our Info, NFP

Gotcha. For all, please. If that's too much, let me know what the redaction process looks like and I will narrow down from there.

From: Information Technology, Nevada

Good Afternoon Matt,

I just wanted to update you and let you know we are working this request. I am hopeful to have it to you by Thursday 7/26/18. If not I will provide another update for an expected time.

Thank you.

Tyler Gutierrez
Legal Records Specialist
City Attorney's Office - Civil
(702) 229 - 6926
495 South Main Street, 6th Floor | Las Vegas, NV 89101
[cid:image001.png@01D34D8E.A1C84DB0]
lasvegasnevada.gov<https://www.lasvegasnevada.gov/>
[cid:image002.png@01D34D8E.A1C84DB0]<https://www.facebook.com/CityOfLasvegas>[cid:image003.png@01D34D8E.A1C84DB0]<https://twitter.com/cityoflasvegas>[cid:image004.png@01D34D8E.A1C84DB0]<https://www.instagram.com/cityoflasvegas>[cid:image005.png@01D34D8E.A1C84DB0]<https://www.snapchat.com/cityoflasvegas>

From: Information Technology, Nevada

Matt I actually just received the information and the o.k. to release. The file is too big to send via email. Would you be opposed to receiving the document thru our public records portal? It would just be a simple download. Let me know.

Tyler Gutierrez
Legal Records Specialist
City Attorney's Office - Civil
(702) 229 - 6926
495 South Main Street, 6th Floor | Las Vegas, NV 89101
[cid:image001.png@01D34D8E.A1C84DB0]
lasvegasnevada.gov<https://www.lasvegasnevada.gov/>
[cid:image002.png@01D34D8E.A1C84DB0]<https://www.facebook.com/CityOfLasvegas>[cid:image003.png@01D34D8E.A1C84DB0]<https://twitter.com/cityoflasvegas>[cid:image004.png@01D34D8E.A1C84DB0]<https://www.instagram.com/cityoflasvegas>[cid:image005.png@01D34D8E.A1C84DB0]<https://www.snapchat.com/cityoflasvegas>

From: Information Technology, Nevada

A copy of documents responsive to the request.

From: Matt Chapman - Free Our Info, NFP

Please do!

Much appreciated -
Matt Chapman
Free Our Info, NFP

From: Information Technology, Nevada

Working on it now. You should receive an email from our portal shortly.

Tyler Gutierrez
Legal Records Specialist
City Attorney's Office - Civil
(702) 229 - 6926
495 South Main Street, 6th Floor | Las Vegas, NV 89101
[cid:image001.png@01D34D8E.A1C84DB0]
lasvegasnevada.gov<https://www.lasvegasnevada.gov/>
[cid:image002.png@01D34D8E.A1C84DB0]<https://www.facebook.com/CityOfLasvegas>[cid:image003.png@01D34D8E.A1C84DB0]<https://twitter.com/cityoflasvegas>[cid:image004.png@01D34D8E.A1C84DB0]<https://www.instagram.com/cityoflasvegas>[cid:image005.png@01D34D8E.A1C84DB0]<https://www.snapchat.com/cityoflasvegas>

From: Information Technology, Nevada

Dear Matt Chapman,
Thank you for registering with the City of Las Vegas Open Records Center. Below you will find your login information. Please log in to the Open Records Center to update any contact or password information and to track the progress of your request.
Login: requests@muckrock.com

If you have never used this system or cannot remember your password, you may request a temporary password here: Request Temporary Password (https://lasvegasnv.mycusthelp.com/WEBAPP/_rs/ForgotPassword.aspx)
This is an auto-generated email and has originated from an unmonitored email account. Please DO NOT REPLY.

From: Information Technology, Nevada

Dear Matt Chapman:

Thank you for your interest in public records of the City of Las Vegas. Your request was received on 7/24/2018 and is being processed. We will respond within five business days by providing one of the following:

Record Requested: To Whom It May Concern:Pursuant to the Nevada Public Records Act, 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 address2. To address3. bcc addresses4. cc addresses5. Time6. DatePlease 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 5 business days, as the statute requires.Sincerely,Matt Chapman

You can monitor the progress of your request at the link below. Again, you will receive an official response within five business days and an additional notification when your request has been completed. Thank you for submitting a Public Records Request. Your request was given the reference number W011804-072418 for tracking purposes.

City of Las Vegas
Please note: There is a charge for copies of public records. If the estimated cost of the copies requested is $25.00 or more, the requestor will be required to pay in full prior to reproduction. Materials will be held for 14 days. If not retrieved, the requestor will be charged in full for a second reproduction in addition to any unpaid original charges. Advance payment will be forfeited if material is not retrieved. To monitor the progress or update this request please log into the
Public Records Center. (https://lasvegasnv.mycusthelp.com/WEBAPP/_rs/RequestEdit.aspx?rid=11804&coid=)
Track the issue status and respond at:
https://lasvegasnv.mycusthelp.com/WEBAPP//_rs/RequestEdit.aspx?rid=11804 (https://lasvegasnv.mycusthelp.com/WEBAPP//_rs/RequestEdit.aspx?rid=11804)

From: Information Technology, Nevada

--- Please respond above this line ---

Hey Matt,
I have uploaded the spreadsheet. Please login to retrieve it.
Let me know if you need anything else.
Thank you.
-Tyler Gutierrez To monitor the progress or update this request please log into the
Public Records Center. (https://lasvegasnv.mycusthelp.com/WEBAPP/_rs/RequestEdit.aspx?rid=11804&coid=)

From: Information Technology, Nevada

Dear Matt,
We received your request for password assistance on 08/03/2018. Below is your temporary password. Please use it to access your City of Las Vegas Open Records Center account. When you access your account, please create a permanent password that only you can remember.
Login: requests@muckrock.com
Password: 1bfa93208d
City of Las Vegas
This is an auto-generated email and has originated from an unmonitored email account. Please DO NOT REPLY.

From: Information Technology, Nevada

Dear Matt,
This message is to notify you that your password has changed.

City of Las Vegas

This is an auto-generated email and has originated from an unmonitored email account. Please DO NOT REPLY.

Files