January 2017 Email Metadata (Information Technology, Nevada)
| Tracking # |
W011804-072418 |
| Multi Request | January 2017 Email Metadata |
| Submitted | July 4, 2018 |
| Est. Completion | None |
MuckRock users can file, duplicate, track, and share public records requests like this one. Learn more.
Communications
From: Matt Chapman
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
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
Thank you for letting me know. I will look into this and let you know sometime over the next couple days.
From: Matt Chapman
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
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
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.
-
EmailSearch.csv
From: Matt Chapman
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.
From: Matt Chapman
Hi - I'm reviewing this request. The request doesn't look like it was completed properly. The information attached is in the format of:
"93795039,2017-01-02 15:29:42.803,JGuinn@ncenet.com,To"
The last column is a direction of the email, but it should instead be the email addresses of the opposite side. The columns should be "to, from, cc, bcc, time" instead of what it currently is. As it stands, the only way to associate each line would be by timestamp, but that is bound to have time collisions.
Could this please be reviewed again, and resent to me ASAP?
Thank you in advance -
Matt Chapman
From: Information Technology, Nevada
Dear Matt Chapman:
Please be advised that if you wish to submit a new request or check on the status of an already submitted request, you should visit the Open Records Center by clicking here. (https://u8387795.ct.sendgrid.net/wf/click?upn=W-2BWpAXBSSNXCLahAo5HYFcVWcxx4-2Bd8gSzEtJkIynmV4fhkk7R4yEulLbq3v8Hul_eoPk8Bin-2FGTcwqpTmQomGESn02UcZARRIr0An2ie3raBT-2BRwPYc5ORMVP9hHB6ZXeKjwz0OzUDxExHEBdcE9YFiZ8TwiuOxbAy4HXshHqfoppT69ieTF1AtQitdGH16k-2BENP-2FXmasKV0iFujmIkFd-2Fs0uSsLrRFRPObaLH66iTK1414ACCjhIL0Oi0xqrxgVbQ2Z-2BniXevifS7SZ8e-2FLJYRIxzCOA2iZowhkUthbB-2FFj1jcMm7vT67fMpbY9M3d9mYv5GFBquvbiB4qhf4ZPu-2BSJ62QDWPhdmJqrFPSWsCDTQFm4CCN-2FL2ONHFka8lnfPEZq9zd18X9qpJSL-2FqFGHA9ROSUg5vHCuDUOLmPm3ZYPHB-2FvJA5KfBDcxOjVV6dT-2BhZjfZET6fy6vrQVybmcZw-3D-3D)
Description: TO: [LasVegasNV@mycusthelp.net]Information Technology, NevadaNevada Public Records Act Office495 S. Main StreetLas Vegas, NV 89101April 8, 2019This is a follow up to request number W011804-072418:Hi - I'm reviewing this request. The request doesn't look like it was completed properly. The information attached is in the format of:"93795039,2017-01-02 15:29:42.803,JGuinn@ncenet.com,To"The last column is a direction of the email, but it should instead be the email addresses of the opposite side. The columns should be "to, from, cc, bcc, time" instead of what it currently is. As it stands, the only way to associate each line would be by timestamp, but that is bound to have time collisions. Could this please be reviewed again, and resent to me ASAP?Thank you in advance -Matt ChapmanFiled via MuckRock.comE-mail (Preferred): 57483-74318902@requests.muckrock.comUpload documents directly: https://www.muckrock.comhttps://www.muckrock.com/ 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 NewsDEPT MR 57483411A Highland AveSomerville, MA 02144-2516PLEASE 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 Aug. 3, 2018: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.---On Aug. 3, 2018: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.---On July 24, 2018:
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 Chapman:
Please be advised that if you wish to submit a new request or check on the status of an already submitted request, you should visit the Open Records Center by clicking here. (https://u8387795.ct.sendgrid.net/wf/click?upn=W-2BWpAXBSSNXCLahAo5HYFcVWcxx4-2Bd8gSzEtJkIynmV4fhkk7R4yEulLbq3v8Hul_eoPk8Bin-2FGTcwqpTmQomGESn02UcZARRIr0An2ie3raBT-2BRwPYc5ORMVP9hHB6ZXeKjwz0OzUDxExHEBdcE9YFiZ8TwiuOxbAy4HXshHqfoppT69ieTF1AtQitdGH16k-2BENP-2FXmasKV0iFujmIkFd-2Fs0uSsLrRFRPObaLH66iTK1414ACCjhIL0Oi0xqrxgVbQ2Z-2BniXevifS7SZ8e-2FLJYRIxzCOA2iZowhkUthbB-2FFj1jcMm7vT67fMpbY9M3d9mYv5GFBquvbiB4qhf4ZPu-2BSJ62QDWPhdmJqrFPSWsCDTQFm4CCN-2FL2ONHFka8lnfPEZq9zd18X9qpJSL-2FqFGHA9ROSUg5vHCuDUOLmPm3ZYPHB-2FvJA5KfBDcxOjVV6dT-2BhZjfZET6fy6vrQVybmcZw-3D-3D)
Description: TO: [LasVegasNV@mycusthelp.net]Information Technology, NevadaNevada Public Records Act Office495 S. Main StreetLas Vegas, NV 89101April 8, 2019This is a follow up to request number W011804-072418:Hi - I'm reviewing this request. The request doesn't look like it was completed properly. The information attached is in the format of:"93795039,2017-01-02 15:29:42.803,JGuinn@ncenet.com,To"The last column is a direction of the email, but it should instead be the email addresses of the opposite side. The columns should be "to, from, cc, bcc, time" instead of what it currently is. As it stands, the only way to associate each line would be by timestamp, but that is bound to have time collisions. Could this please be reviewed again, and resent to me ASAP?Thank you in advance -Matt ChapmanFiled via MuckRock.comE-mail (Preferred): 57483-74318902@requests.muckrock.comUpload documents directly: https://www.muckrock.comhttps://www.muckrock.com/ 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 NewsDEPT MR 57483411A Highland AveSomerville, MA 02144-2516PLEASE 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 Aug. 3, 2018: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.---On Aug. 3, 2018: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.---On July 24, 2018:
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,
We received your request for password assistance on 04/08/2019. 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: 9703e49066
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.