[SOLVED] How to Find Your iPod Touch When Find My iPhone Does Not Work

My son has a 4th Generation iPod Touch. He’s 5 years old. He loves the damn thing…but he loses it all the time because he’s so careful to “pack it away” and make sure it’s “safe”.

Fast forward 2 hours, and my 5 year old can’t remember where he left it and super-daddy needs to fire up his “Find My iPhone” so I he can locate it.

I log in and Find My iPhone says it cannot be located.
I try again. Nothing.
Again…nothing.
WTF?
Continue reading “[SOLVED] How to Find Your iPod Touch When Find My iPhone Does Not Work”

Advertisements

LogParser Query for Exchange – Find Inbound & Outbound Emails for a Specific User

Scenario: You’re managing an Exchange server and your Director just asked you the following:

“I want a full list of all the emails John has sent outside the company. I also want to see a list of incoming emails from outside the company.”

You nod and carry on. A few days later, you realize they actually want the report. Here’s the query to run in LogParser:

In this example, I’m assuming the following:

  • The user is called John Doe (jdoe@abcwidgets.com) and he works at ABCWidgets.com.
  • You’re running the Command Line query from the same directory that LogParser is located in.
  • Your Exchange Files are located in C:Program FilesExchsrvrLogs.
  • You need a CSV File for easy opening and formatting in Excel.
  • You want to parse and plunder the entire Log folder in Exchange in one shot.
  • You want to save the CSV file to the same directory as LogParser.

Here are the queries. Replace variables as needed.

LogParser Query for All Inbound Emails (Not Received From ABCWidgets.com)


"LogParser.exe" -i:W3C -o:CSV "select TO_Timestamp(REPLACE_STR(STRCAT(STRCAT(date,' '), time),' GMT',''),'yyyy-M-d h:m:s') as DateTime, Recipient-Address AS RcptAddress, Number-Recipients AS NumRcpts, Message-Subject AS Subject, Sender-Address AS Sender from 'C:Program FilesExchsrvrLogs*.log' to jdoe-inbound-external.csv WHERE Recipient-Address LIKE '%jdoe@%' GROUP BY DateTime, Recipient-Address, Number-Recipients, Message-Subject, Sender-Address HAVING Sender-Address NOT LIKE '%abcwidgets%'" -filemode:0

LogParser Query for All Outbound Emails (Not Sent To ABCWidgets.com)


"LogParser.exe" -i:W3C -o:CSV "select TO_Timestamp(REPLACE_STR(STRCAT(STRCAT(date,' '), time),' GMT',''),'yyyy-M-d h:m:s') as DateTime, Recipient-Address AS RcptAddress, Number-Recipients AS NumRcpts, Message-Subject AS Subject, Sender-Address AS Sender from 'C:Program FilesExchsrvrLogs*.log' to jdoe-outbound-external.csv WHERE Sender-Address LIKE '%jdoe@%' GROUP BY DateTime, Recipient-Address, Number-Recipients, Message-Subject, Sender-Address HAVING Recipient-Address NOT LIKE '%abcwidgets%'" -filemode:0

You turn the report in and your Director says, “You know what, you haven’t plundered enough, today. I want to see all his incoming and outgoing emails within the company only, too.”
With a smack to your forehead, you trod off back to your dusty server room. Here’s the queries:

LogParser Query for All Inbound Emails (Received From ABCWidgets.com Employees)


"LogParser.exe" -i:W3C -o:CSV "select TO_Timestamp(REPLACE_STR(STRCAT(STRCAT(date,' '), time),' GMT',''),'yyyy-M-d h:m:s') as DateTime, Recipient-Address AS RcptAddress, Number-Recipients AS NumRcpts, Message-Subject AS Subject, Sender-Address AS Sender from 'C:Program FilesExchsrvrLogs*.log' to jdoe-inbound-internal.csv WHERE Recipient-Address LIKE '%jdoe@%' GROUP BY DateTime, Recipient-Address, Number-Recipients, Message-Subject, Sender-Address HAVING Sender-Address LIKE '%abcwidgets%'" -filemode:0

LogParser Query for All Outbound Emails (Sent To ABCWidgets.com Employees)


"LogParser.exe" -i:W3C -o:CSV "select TO_Timestamp(REPLACE_STR(STRCAT(STRCAT(date,' '), time),' GMT',''),'yyyy-M-d h:m:s') as DateTime, Recipient-Address AS RcptAddress, Number-Recipients AS NumRcpts, Message-Subject AS Subject, Sender-Address AS Sender from 'C:Program FilesExchsrvrLogs*.log' to jdoe-outbound-internal.csv WHERE Sender-Address LIKE '%jdoe@%' GROUP BY DateTime, Recipient-Address, Number-Recipients, Message-Subject, Sender-Address HAVING Recipient-Address LIKE '%abcwidgets%'" -filemode:0

Mission accomplished.