Life Saver Tool: Log Parser Studio 2.2

Life Saver Tool: Log Parser Studio 2.2

Graphical tool for analyzing IIS logs. No need to keep your queries in text files and command line commands. Many predefined queries are ready for you and you can create and save your own queries.

Download and more info: http://blogs.technet.com/b/exchange/archive/2012/03/07/introducing-log-parser-studio.aspx

Note: don’t trust %100 to predifened queries for instance I need to create my own query for unique user OWA usage:

Query: List unique OWA users in a certain period of time. Exchange 2010

List Unique OWA users, don’t show lines with empty userid, case-insensitive for userid field and lists as 1 line:

SELECT DISTINCT To_Lowercase(cs-username) AS UserID,

Count(*)

FROM ‘[LOGFILEPATH]’

WHERE cs-uri-stem LIKE ‘%OWA%’

AND cs-username IS NOT NULL

GROUP BY UserID

ORDER BY COUNT(*) DESC

 

 

Advertisements
Gallery | This entry was posted in Exchange Server, Life Saver Tools Tested and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s