Enabling user tracking of OWA 2007 (Logging external IP Address into DB or TXT file)

Hi All,

I'm just wondering and been looking around if there's anyway to get the IP address detail of OWA access (anyone who use OWA, their IP and username is logged) and probably write it down to SQL Server database or even just simple text file will do.

is this something that IIS 6.1 can do or should i do it in ASP 3.0 way ?

the reason I'm doing this is for company compliance policy to trackdown the OWA usage and making sure that certain username that accessing a particular IIS directory is logged properly.

Cheer,

AWT
LVL 1
jjozAsked:
Who is Participating?
 
gurutcConnect With a Mentor Commented:
Hi,

This is easy, you just enable IIS logging.  It'll record the IP, username if not encrypted, remote browser, and tons of other stuff.  Puts it in a subfolder of system32.  Falling off a log easy.  Just set logging enabled in IIS and tell it what you want to log.

Good idea to do this.  It's helped us greatly when troubleshooting.

- gurutc
0
 
jjozAuthor Commented:
Hi Guru TC,
May i know where to activate this feature ?
the idea is to track whose/what IP Address has accessed my web folder to make a statistics.
hopefully it is not just displaying the firewall IP address since this Web Server sits behind my firewall.
Thanks.
0
 
cj_1969Connect With a Mentor Commented:
Here is MS's instructions on enabling logging ... http://support.microsoft.com/kb/300390
0
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

 
cj_1969Connect With a Mentor Commented:
here is another reference on it with screen shots ... http://articles.techrepublic.com.com/5100-10878_11-1051006.html
0
 
gurutcConnect With a Mentor Commented:
Go cj_1969, doh, I sure snoozed.  follow CJ's advice.

- gurutc
0
 
Ted BouskillConnect With a Mentor Senior Software DeveloperCommented:
If you enabled all the advanced logging columns in IIS for the site it will record all the detail you require.  As long as the user isn't spoofing the return IP you will get the client IP's.

You can use LogParser 2.2 (free from Microsoft) to push the data into a SQL database.
0
 
jjozAuthor Commented:
ah yes, that is sooo convincing and usefule mate.
0
 
jjozAuthor Commented:
Thanks man for the help.
0
All Courses

From novice to tech pro — start learning today.