Solved

logparser command to export user from pop3 log (Exchange 2007)

Posted on 2014-11-05
4
581 Views
Last Modified: 2015-02-04
hello,

i have activated pop3 log on my exchange 2007 cas and i need to export all user on this log.

can you help me plz with the good logparser command?

thank you
0
Comment
Question by:cawasaki
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 64

Expert Comment

by:btan
ID: 40428398
probably can check out the use of this command to check for POP3 logs:
 
Logparser –i:csv –o: DATAGRID “SELECT dataTime, user, command FROM C:\pop3logfolder\*log”
 
Note: C:\pop3logfolder is the path to save the pop3 logs.

Some good tips on other stats to grab out from log can come in handy  http://technet.microsoft.com/en-us/library/ee692659.aspx

... and esp for troubleshooting http://blogs.technet.com/b/mscom/archive/2005/10/19/412745.aspx
0
 

Author Comment

by:cawasaki
ID: 40464056
hello,

command not work
0
 
LVL 64

Accepted Solution

by:
btan earned 500 total points
ID: 40464298
What is the error shown ... it was tested as in forum sharing using logparser 2.2 but may not necessary be 2007.

Separately In article below, it stated IMAP/POP3 connections create events with ID 1010 in the Application event log so maybe we cab grab it from there instead.

http://windowsitpro.com/systems-management/combining-logparser-and-sed
logparser -i evt "select TimeGenerated, SourceName, Event ID, Message FROM application  where EventID=1010 OR EventID=101 7" -q | grep 1010

I also suspecting if the field name may differs. There are other examples (though not specific to POP3) to see if they are viable on the Exchg 2007
http://www.msexchange.org/articles-tutorials/exchange-server-2007/monitoring-operations/creating-graphical-reports-exchange-2007-part3.html

In the above ExInsight is highlighted that may be of interest (http://bitrunes.com/)
ExInsight is a free monitoring and statistics tool that provides a real-time view of the internals of Exchange Server transactions and allows you to evaluate individual user's usage of Exchange Server.
This tool is especially useful for Exchange administrators and developers. By using this tool, you can gather real-time data about the users in an Exchange environment and learn more about the inner workings of MAPI, OWA, POP3, IMAP4, NNTP and other protocols.
0
 

Author Closing Comment

by:cawasaki
ID: 40588312
thanks
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
In previous parts of this Nano Server deployment series, we learned how to create, deploy and configure Nano Server as a Hyper-V host. In this part, we will look for a clustering option. We will create a Hyper-V cluster of 3 Nano Server host nodes w…
The viewer will learn how to dynamically set the form action using jQuery.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question