Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Report from IIS log

Author  Topic 

Shivs
Starting Member

9 Posts
Posted - 2009-04-21 : 05:57:58
Hi friends,

I'm trying to query the IIS log files, you get the data about the users of IIS sites. And I'm stuck in here for a quite a long time, so want your help.

There are many columns in log files. But the columns will be in used are -
[date],[cIp],[csUsername],[csMethod],[csUriStem],[csUriQuery],scStatus]

Data looks like this
2009-03-23 07:45:27.000 || 192.168.1.120||User1||POST|| /_vti_bin/spscrawl.asmx || NULL|| 200

And many more rows. You can also find those log files on your PCs under - C:\Windows\System32\Logfiles\W3SVC1 or something like W3S-----
If you want I can mail you 1 sample excel sheet with some sample data, that excel you can put it in some table.

And here are rules...

I'm trying to find out the Visits by user. For each visit of each user I want the Start Date and End Date.
Output Should be
CsUsername, CiP, StartDate, EndDate

A Visit starts when User gets logged in. There is no way to find out directly.

Visit ends when User sign out of site or User remains Idle on site for more than 30 minutes.
For that we 2 indicators -
1. When we see a %signout% in csUriStem column
OR
2. when we 'loginasanotheruser=true%' in csUriQuery.
For user is Idle or not - we have to check with next row, if the time diff is greater than 30 min then it will count as new visit.

For visit start time, we have to check if the previous row for same User is before 30 mins or contains '%signout%' in csUriStem column or 'loginasanotheruser=true%' in csUriQuery.
And for End Time whatever happens first out of above 3 (30 min, signout, loginsession.).

Sometimes you will get '%signout%' in CsUriStme column for consecutive 3-4 rows, but we should only pick the time from the row where csUriStem column ends with .aspx and not with .gif.

I'm really need help, I can mail you the excel sheet or may be the insert script.
Just let me knoe.

Shivs
Starting Member

9 Posts
Posted - 2009-04-21 : 06:31:27
Ok here is the create script

CREATE TABLE [dbo].[LOGS](
[date] [datetime] NULL,
[cIp] [varchar](8000) NULL,
[csUsername] [varchar](8000) NULL,
[csMethod] [varchar](8000) NULL,
[csUriStem] [varchar](8000) NULL,
[csUriQuery] [varchar](8000) NULL,
[scStatus] [int] NULL
) ON [PRIMARY]

GO
Go to Top of Page

Shivs
Starting Member

9 Posts
Posted - 2009-04-21 : 08:33:28
[code]
INSERT INTO [logs] VALUES('Mar 31 2009 8:26:07:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 8:26:07:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 8:26:07:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 8:26:09:000AM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 8:26:09:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 8:26:09:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 8:26:12:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 8:26:36:000AM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 8:45:56:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 8:45:56:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 8:45:56:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 8:45:56:000AM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 8:45:56:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 8:45:56:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 8:45:56:000AM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:05:56:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:05:56:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:05:56:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:05:56:000AM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:05:56:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:05:56:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:05:56:000AM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:05:56:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:25:56:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:25:56:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:25:56:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:25:56:000AM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:25:56:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 8:45:56:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:25:56:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:25:56:000AM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:25:56:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:45:56:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:45:56:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:45:56:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:45:56:000AM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:45:56:000AM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:45:56:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:45:56:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:45:56:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:50:47:000AM','192.168.1.111','User3','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:25:58:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:50:47:000AM','192.168.1.111','User3','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:50:48:000AM','192.168.1.111','User3','GET','/_layouts/1033/styles/controls.css','rev=EhwiQKSLiI%2F4dGDs6DyUdQ%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:50:48:000AM','192.168.1.111','User3','GET','/_layouts/1033/styles/HtmlEditorCustomStyles.css','rev=8SKxtNx33FmoDhbbfB27UA%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:50:48:000AM','192.168.1.111','User3','GET','/_layouts/1033/styles/HtmlEditorTableFormats.css','rev=guYGdUBUxQit03E2jhSdvA%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:25:58:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:46:12:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:50:48:000AM','192.168.1.111','User3','GET','/_layouts/1033/styles/core.css','rev=5msmprmeONfN6lJ3wtbAlA%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:50:48:000AM','192.168.1.111','User3','GET','/_layouts/1033/init.js','rev=ck%2BHdHQ8ABQHif7kr%2Bj7iQ%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/portal.js','rev=cRI8b5r5N%2BkLhIuWR03ICg%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/1033/ie55up.js','rev=Ni7%2Fj2ZV%2FzCvd09XYSSWvA%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/1033/core.js','rev=S5dt4K8TJGVTYU9HrW6enw%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/1033/EditingMenu.js','rev=O4%2BTJbLGM9Af07theU%2BW6A%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/1033/search.js','rev=yqBjpvg%2Foi3KG5XVf%2FStmA%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/Serialize.js','rev=yoPAvZ5aIeY93U62X8ie%2FQ%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/1033/SpellCheckEntirePage.js','rev=zYQ05cOj5Dk74UkTZzEIRw%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/WebResource.axd','d=fWohqYhDDzsEpGWUnQlNkg2&t=633616811845362613',200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/WebResource.axd','d=22XfSRd6vKE5QoRf1EQoEQ2&t=633616811845362613',200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/menudark.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:46:12:000AM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:46:16:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/blank.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/helpicon.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/titlegraphic.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/gosearch.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/WebResource.axd','d=WkSv3DH08f8UpGexNTegdciW74rKqn5R2rvoWijY1Kc1&t=633616811845362613',200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/WebResource.axd','d=oWbBVRL9UToSEMiDWk39o4utK72YFSC8oSvRQYxcZTU1&t=633616811845362613',200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/edit.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/whitearrow.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/cnspub16.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/wppinval.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/check.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/topnavselected.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:06:07:000AM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:06:12:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:28:17:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:28:17:000AM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/siteTitleBKGD.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/siteactionsmenugrad.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/topnavunselected.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/pageTitleBKGD.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/cnsugrdn.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/qarsgrd.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:50:09:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:50:10:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/recycbin.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/lstbulet.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/Menu1.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/navshape.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/navBullet.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/icongo01.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/pagebackgrad.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/_layouts/images/quickLaunchHeader.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:03:000AM','192.168.1.111','User3','GET','/PublishingImages/newsarticleimage.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:09:000AM','192.168.1.111','User3','GET','/_layouts/images/topnavhover.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:12:000AM','192.168.1.111','User3','GET','/_layouts/images/menubuttonhover.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:12:000AM','192.168.1.111','User3','GET','/_layouts/images/cnsca16.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:05:59:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:05:59:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:06:05:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:06:05:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:12:000AM','192.168.1.111','User3','GET','/_layouts/images/apprj.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:12:000AM','192.168.1.111','User3','GET','/_layouts/images/cnsvt16.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:12:000AM','192.168.1.111','User3','GET','/_layouts/blank.htm',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:21:000AM','192.168.1.109','User5','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:29:000AM','192.168.1.111','User3','POST','/Pages/Default.aspx',NULL,302)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:45:000AM','192.168.1.111','User3','GET','/_layouts/Checkin.aspx','FileName=%2FPages%2FDefault%2Easpx&Publish=true&List=a668dc32-c96a-4303-8554-0614743f992e&Source=%2FPages%2FDefault%2Easpx',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:05:56:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:05:56:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 9:51:45:000AM','192.168.1.111','User3','GET','/_layouts/images/formtitlegrad.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:05:56:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:05:56:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:05:56:000AM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:05:56:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:05:56:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:05:56:000AM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:21:000AM','192.168.1.109','User5','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:22:000AM','192.168.1.109','User5','GET','/PublishingImages/newsarticleimage.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:30:000AM','192.168.1.109','User5','GET','/Reports/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:45:58:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:30:000AM','192.168.1.109','User5','POST','/Reports/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:30:000AM','192.168.1.109','User5','POST','/Reports/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:30:000AM','192.168.1.109','User5','POST','/Reports/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:33:000AM','192.168.1.109','User5','GET','/SearchCenter/Pages/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:33:000AM','192.168.1.109','User5','GET','/WebResource.axd','d=6xDbANXwspIwzJHg8tCMdw2&t=633616811845362613',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:33:000AM','192.168.1.109','User5','GET','/_layouts/images/trans.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:33:000AM','192.168.1.109','User5','GET','/_layouts/images/PortalTabSelected.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:33:000AM','192.168.1.109','User5','GET','/_layouts/images/topnavdivider.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:36:000AM','192.168.1.109','User5','GET','/SiteDirectory/Pages/category.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:36:000AM','192.168.1.109','User5','GET','/_layouts/images/toolgrad.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:36:000AM','192.168.1.109','User5','GET','/_layouts/images/PortalTabHover.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:39:000AM','192.168.1.109','User5','GET','/Docs',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:40:000AM','192.168.1.109','User5','GET','/Docs/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:40:000AM','192.168.1.109','User5','GET','/WebResource.axd','d=rVq0f9SiwWG9OaStrB9yzw2&t=633616811845362613',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:40:000AM','192.168.1.109','User5','GET','/_layouts/images/tvblank.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:40:000AM','192.168.1.109','User5','GET','/_layouts/images/itdl.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:40:000AM','192.168.1.109','User5','GET','/_layouts/images/itann.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:40:000AM','192.168.1.109','User5','GET','/_layouts/images/ittask.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:40:000AM','192.168.1.109','User5','GET','/_layouts/images/tvplus.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:40:000AM','192.168.1.109','User5','GET','/_layouts/images/tvminus.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:43:000AM','192.168.1.109','User5','GET','/Docs/Documents',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:45:000AM','192.168.1.109','User5','GET','/Docs/Documents/Forms/AllItems.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:26:09:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:45:000AM','192.168.1.109','User5','GET','/_layouts/images/dlicon.png',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:45:000AM','192.168.1.109','User5','GET','/_layouts/images/menudarkspaced.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:45:000AM','192.168.1.109','User5','GET','/_layouts/images/icbmp.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:45:000AM','192.168.1.109','User5','GET','/_layouts/images/icgen.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:45:000AM','192.168.1.109','User5','GET','/_layouts/images/checkoutoverlay.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:45:000AM','192.168.1.109','User5','GET','/_layouts/images/icdocx.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:45:000AM','192.168.1.109','User5','GET','/_layouts/images/imnhdr.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:48:000AM','192.168.1.109','User5','GET','/Docs/Documents/logo.bmp',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:59:000AM','192.168.1.109','User5','GET','/Docs/Documents/Tally+Settings+General.odt',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:06:59:000AM','192.168.1.109','User5','GET','/Docs/Documents/Tally+Settings+General.odt',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:07:13:000AM','192.168.1.109','User5','GET','/Docs/Documents/This+is+it.docx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:07:28:000AM','192.168.1.109','User5','GET','/Docs/Lists/Announcements/AllItems.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:07:28:000AM','192.168.1.109','User5','GET','/Docs/Lists/Announcements',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:07:28:000AM','192.168.1.109','User5','GET','/_layouts/images/announce.png',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:07:28:000AM','192.168.1.109','User5','GET','/_layouts/images/attachhd.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:07:30:000AM','192.168.1.109','User5','GET','/Docs/Lists/Tasks/AllItems.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:07:30:000AM','192.168.1.109','User5','GET','/Docs/Lists/Tasks',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:07:30:000AM','192.168.1.109','User5','GET','/_layouts/images/issues.png',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:45:58:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:45:58:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:45:58:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:07:34:000AM','192.168.1.109','User5','GET','/SiteDirectory/Pages/category.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:07:36:000AM','192.168.1.109','User5','GET','/SearchCenter/Pages/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:07:38:000AM','192.168.1.109','User5','GET','/Reports/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:07:38:000AM','192.168.1.109','User5','POST','/Reports/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:07:38:000AM','192.168.1.109','User5','POST','/Reports/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:07:38:000AM','192.168.1.109','User5','POST','/Reports/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:07:42:000AM','192.168.1.109','User5','GET','/Reports/Lists/Sample+KPIs/DispForm.aspx','ID=1&Source=%2FReports%2FPages%2FDefault%2Easpx&IconPrefix=KpiIconChange',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:07:42:000AM','192.168.1.109','User5','GET','/_layouts/1033/form.js','rev=df60y6YolDjUVbi91%2BZw%2Fg%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:07:42:000AM','192.168.1.109','User5','GET','/_layouts/images/delitem.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:07:42:000AM','192.168.1.109','User5','GET','/_layouts/images/edititem.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:25:58:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:25:58:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:07:42:000AM','192.168.1.109','User5','GET','/_layouts/images/manageperm.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:07:42:000AM','192.168.1.109','User5','GET','/_layouts/images/KPIDefaultLarge-0.GIF',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:07:51:000AM','192.168.1.109','User5','GET','/SearchCenter/Pages/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:07:53:000AM','192.168.1.109','User5','GET','/SiteDirectory/Pages/category.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:07:56:000AM','192.168.1.109','User5','GET','/SiteDirectory/Pages/categoryresults.aspx','Column=RegionMulti&ColumnDisplayName=Region&Value=International',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:02:000AM','192.168.1.109','User5','GET','/SiteDirectory/Pages/topsites.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:05:000AM','192.168.1.109','User5','GET','/SiteDirectory/Pages/sitemap.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:09:000AM','192.168.1.109','User5','GET','/Docs/_layouts/viewlsts.aspx','BaseType=0&ListTemplate=108',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:09:000AM','192.168.1.109','User5','GET','/_layouts/images/allcontents.png',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:09:000AM','192.168.1.109','User5','GET','/_layouts/images/createcontent.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:13:000AM','192.168.1.109','User5','GET','/Docs/Lists/Tasks/AllItems.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:13:000AM','192.168.1.109','User5','GET','/Docs/Lists/Tasks',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:15:000AM','192.168.1.109','User5','GET','/Docs/Lists/Announcements/AllItems.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:45:58:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:45:58:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:46:01:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:15:000AM','192.168.1.109','User5','GET','/Docs/Lists/Announcements',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:16:000AM','192.168.1.109','User5','GET','/_layouts/images/siteactionsmenuhovergrad.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:16:000AM','192.168.1.109','User5','GET','/_layouts/images/Actionscreate.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:16:000AM','192.168.1.109','User5','GET','/_layouts/images/ActionsSettings.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:16:000AM','192.168.1.109','User5','GET','/_layouts/images/ActionsEditPage.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:18:000AM','192.168.1.109','User5','GET','/Docs/_layouts/create.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:18:000AM','192.168.1.109','User5','GET','/_layouts/images/setrect.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:18:000AM','192.168.1.109','User5','GET','/_layouts/images/creategraphic.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:18:000AM','192.168.1.109','User5','GET','/_layouts/images/settingsbkg.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:18:000AM','192.168.1.109','User5','GET','/_layouts/images/linksectiongrad.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:26:09:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:21:000AM','192.168.1.109','User5','GET','/_layouts/images/ltann.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:21:000AM','192.168.1.109','User5','GET','/_layouts/images/ltcontct.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:23:000AM','192.168.1.109','User5','GET','/Docs/_layouts/new.aspx','FeatureId={00bfea71-7e6d-4186-9ba8-c047ac750105}&ListTemplate=105',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:23:000AM','192.168.1.109','User5','GET','/Docs/_layouts/new.aspx','FeatureId={00bfea71-7e6d-4186-9ba8-c047ac750105}&ListTemplate=105',200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:50:09:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:50:09:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:23:000AM','192.168.1.109','User5','GET','/_layouts/images/leftnav.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:27:000AM','192.168.1.109','User5','GET','/Docs/_layouts/settings.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:27:000AM','192.168.1.109','User5','GET','/_layouts/images/settingsgraphic.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:30:000AM','192.168.1.109','User5','GET','/Docs/_layouts/mngctype.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:30:000AM','192.168.1.109','User5','GET','/_layouts/images/newitem.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:34:000AM','192.168.1.109','User5','GET','/_layouts/mngctype.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:37:000AM','192.168.1.109','User5','GET','/Docs',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:37:000AM','192.168.1.109','User5','GET','/Docs/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/Docs/Lists/Announcements/NewForm.aspx','Source=http%3A%2F%2Fsv%2Dbic%2D0001%2FDocs%2Fdefault%2Easpx',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/datepicker.js',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rte2spchk.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:50:09:000AM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:50:10:000AM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/images/attachtb.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rtecut.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rtecopy.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rteclear.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/images/undo.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rtepaste.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/images/redo.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rteitbl.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rteirow.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rtescell.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rtedrow.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rtemcell.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:50:17:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:50:17:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rtelnk.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rteimg.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rtefnt.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rtefntsz.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rtebold.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rtesrced.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rteital.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rteundl.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rteltal.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rtertal.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rtectral.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rtenlst.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:25:58:000AM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:25:58:000AM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rteblst.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:50:000PM','192.168.1.109','User2','GET','/_layouts/1033/AssetPickers.js','rev=pwrdokZjl1CAXjNxKmD8Ug%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:50:000PM','192.168.1.109','User2','GET','/_layouts/1033/HtmlEditor.js','rev=AlfjMjrIajl5WJR1Wm1ONQ%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:50:000PM','192.168.1.109','User2','GET','/_layouts/1033/cmssummarylinks.js','rev=oHZct5gJydvs30BSygUf3A%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:50:000PM','192.168.1.109','User2','GET','/_layouts/1033/cmsslwpdragdropvars.js','rev=QiYGgspAifVD2zZ2fBWDqA%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:50:000PM','192.168.1.109','User2','GET','/_layouts/IMAGES/CMSRemoveImage.GIF',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:50:000PM','192.168.1.109','User2','GET','/_layouts/images/RTE2EDIT.GIF',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:50:000PM','192.168.1.109','User2','GET','/_layouts/1033/IMAGES/rteimg.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:50:000PM','192.168.1.109','User2','GET','/_layouts/1033/IMAGES/rtelnk.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:50:000PM','192.168.1.109','User2','GET','/_layouts/IMAGES/SLNewGroup.GIF',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:50:000PM','192.168.1.109','User2','GET','/_layouts/1033/IMAGES/ConfigureStylesLayout.GIF',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:50:000PM','192.168.1.109','User2','GET','/_layouts/IMAGES/Reorder.GIF',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:05:58:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:06:00:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rteuidt.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rteidt.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rtetxclr.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rtebkclr.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rteltr.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/images/rtertl.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/1033/styles/core.css',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:39:000AM','192.168.1.109','User5','GET','/_layouts/images/calendar.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:47:000AM','192.168.1.109','User5','GET','/Docs/Lists/Announcements/AllItems.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:49:000AM','192.168.1.109','User5','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:49:000AM','192.168.1.109','User5','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:08:49:000AM','192.168.1.109','User5','GET','/PublishingImages/newsarticleimage.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:05:59:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:05:59:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:09:04:000AM','192.168.1.109','User5','GET','/News/Pages/newsarchive.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:09:04:000AM','192.168.1.109','User5','GET','/_layouts/images/selectednavbullet.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:09:06:000AM','192.168.1.109','User5','GET','/SearchCenter/Pages/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:09:11:000AM','192.168.1.109','User5','GET','/SearchCenter/Pages/advanced.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:09:16:000AM','192.168.1.109','User5','GET','/News/Pages/newsarchive.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:09:19:000AM','192.168.1.109','User5','GET','/News/_layouts/viewlsts.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:09:19:000AM','192.168.1.109','User5','GET','/_layouts/images/itil.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:09:19:000AM','192.168.1.109','User5','GET','/_layouts/images/itgen.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:09:25:000AM','192.168.1.109','User5','GET','/News/Image+Library/Forms/AllItems.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:09:25:000AM','192.168.1.109','User5','GET','/_layouts/1033/imglib.js','rev=7TuANii0APPawJVVvoP1kA%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:26:09:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:09:25:000AM','192.168.1.109','User5','GET','/_layouts/images/plicon.png',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:09:25:000AM','192.168.1.109','User5','GET','/_layouts/images/preview.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:09:25:000AM','192.168.1.109','User5','GET','/_layouts/1033/imglib.js',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:09:52:000AM','192.168.1.109','User5','GET','/SearchCenter/Pages/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:25:58:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:25:58:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:09:55:000AM','192.168.1.109','User5','POST','/SearchCenter/Pages/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:10:01:000AM','192.168.1.109','User5','GET','/MySite/_layouts/myquicklinks.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:10:01:000AM','192.168.1.109','User5','GET','/MySite/_layouts/HtmlMenus.js',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:10:01:000AM','192.168.1.109','User5','GET','/MySite/_layouts/1033/owsbrows.js',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:10:01:000AM','192.168.1.109','User5','GET','/_layouts/images/mysite_titlegraphic.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:10:01:000AM','192.168.1.109','User5','GET','/_layouts/images/sortup.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:10:01:000AM','192.168.1.109','User5','GET','/_layouts/images/MGrad.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:10:10:000AM','192.168.1.109','User5','GET','/MySite/Person.aspx','accountname=comp\john',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:10:10:000AM','192.168.1.109','User5','GET','/_layouts/images/no_pic.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:10:10:000AM','192.168.1.109','User5','GET','/_layouts/images/portraitbackground.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:10:10:000AM','192.168.1.109','User5','GET','/_layouts/images/hiertop.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:10:10:000AM','192.168.1.109','User5','GET','/_layouts/images/hierbottom.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:46:01:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:25:58:000AM','192.168.1.109','User5','GET','/personal/john/Blog/Lists/Posts/Post.aspx','ID=2',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:25:58:000AM','192.168.1.109','User5','GET','/_layouts/images/navbullet.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:16:000AM','192.168.1.120','User4','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:18:000AM','192.168.1.120','User4','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:18:000AM','192.168.1.120','User4','GET','/_layouts/1033/styles/controls.css','rev=EhwiQKSLiI%2F4dGDs6DyUdQ%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:06:05:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:05:000PM','192.168.1.109','User2','GET','/News/_layouts/AssetPortalBrowser.aspx','APDView=Thumbs&DefaultAssetLocation=&DefaultAssetImageLocation=&DisplayLookInSection=true&DefaultToLastUsedLocation=true&ManageHyperlink=true&DisplayWidth=&DisplayHeight=&AllowExternalUrls=true&OverrideDialogImageUrl=&OverrideDialogTitle=&Filter=1&Target=&ManageLinkDisplayText=true&UseDefaultSize=true&Width=&Height=&Border=0&VSpacing=&HSpacing=&Hyperlink=&Alignment=&AssetText=&AssetUrl=',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:05:000PM','192.168.1.109','User2','GET','/_layouts/1033/CmsSiteManager.js','rev=rEmzwUk5VYSS1Wdm9eq7mA%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:05:000PM','192.168.1.109','User2','GET','/_layouts/1033/msstring.js','rev=fcpiBo%2BQtJqYMECz%2BNiH7Q%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:05:000PM','192.168.1.109','User2','GET','/_layouts/spgridview.js','rev=SPpgeeLAINn%2Fg6H6CStYVA%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:05:000PM','192.168.1.109','User2','GET','/_layouts/IMAGES/ApImagePicker.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:05:000PM','192.168.1.109','User2','GET','/_layouts/IMAGES/CrntImageLib.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:05:000PM','192.168.1.109','User2','GET','/_layouts/IMAGES/RootImageLib.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:06:28:000PM','192.168.1.120','User1','GET','/SiteCollectionImages/Forms/AllItems.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:18:000AM','192.168.1.120','User4','GET','/_layouts/1033/styles/core.css','rev=5msmprmeONfN6lJ3wtbAlA%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:05:000PM','192.168.1.109','User2','GET','/_layouts/Images/refresh.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:05:000PM','192.168.1.109','User2','GET','/_layouts/images/upfolder.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:05:000PM','192.168.1.109','User2','GET','/_layouts/Images/Upload.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:05:000PM','192.168.1.109','User2','GET','/_layouts/IMAGES/ApViewItem.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:09:000PM','192.168.1.109','User2','POST','/News/_layouts/AssetPortalBrowser.aspx','APDView=Thumbs&DefaultAssetLocation=&DefaultAssetImageLocation=&DisplayLookInSection=true&DefaultToLastUsedLocation=true&ManageHyperlink=true&DisplayWidth=&DisplayHeight=&AllowExternalUrls=true&OverrideDialogImageUrl=&OverrideDialogTitle=&Filter=1&Target=&ManageLinkDisplayText=true&UseDefaultSize=true&Width=&Height=&Border=0&VSpacing=&HSpacing=&Hyperlink=&Alignment=&AssetText=&AssetUrl=',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:02:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:18:000AM','192.168.1.120','User4','GET','/_layouts/1033/styles/HtmlEditorTableFormats.css','rev=guYGdUBUxQit03E2jhSdvA%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:10:000PM','192.168.1.109','User2','POST','/News/_layouts/AssetPortalBrowser.aspx','APDView=Thumbs&DefaultAssetLocation=&DefaultAssetImageLocation=&DisplayLookInSection=true&DefaultToLastUsedLocation=true&ManageHyperlink=true&DisplayWidth=&DisplayHeight=&AllowExternalUrls=true&OverrideDialogImageUrl=&OverrideDialogTitle=&Filter=1&Target=&ManageLinkDisplayText=true&UseDefaultSize=true&Width=&Height=&Border=0&VSpacing=&HSpacing=&Hyperlink=&Alignment=&AssetText=&AssetUrl=',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:16:000PM','192.168.1.109','User2','POST','/News/_layouts/AssetPortalBrowser.aspx','APDView=Thumbs&DefaultAssetLocation=&DefaultAssetImageLocation=&DisplayLookInSection=true&DefaultToLastUsedLocation=true&ManageHyperlink=true&DisplayWidth=&DisplayHeight=&AllowExternalUrls=true&OverrideDialogImageUrl=&OverrideDialogTitle=&Filter=1&Target=&ManageLinkDisplayText=true&UseDefaultSize=true&Width=&Height=&Border=0&VSpacing=&HSpacing=&Hyperlink=&Alignment=&AssetText=&AssetUrl=',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:02:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:20:000PM','192.168.1.109','User2','POST','/News/_layouts/AssetPortalBrowser.aspx','APDView=Thumbs&DefaultAssetLocation=&DefaultAssetImageLocation=&DisplayLookInSection=true&DefaultToLastUsedLocation=true&ManageHyperlink=true&DisplayWidth=&DisplayHeight=&AllowExternalUrls=true&OverrideDialogImageUrl=&OverrideDialogTitle=&Filter=1&Target=&ManageLinkDisplayText=true&UseDefaultSize=true&Width=&Height=&Border=0&VSpacing=&HSpacing=&Hyperlink=&Alignment=&AssetText=&AssetUrl=',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:20:000PM','192.168.1.109','User2','GET','/_layouts/images/stsicon.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:20:000PM','192.168.1.109','User2','GET','/_layouts/Images/cat.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:20:000PM','192.168.1.109','User2','GET','/_layouts/1033/images/next.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:20:000PM','192.168.1.109','User2','GET','/_layouts/images/itcontct.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:20:000PM','192.168.1.109','User2','GET','/_layouts/images/itevent.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:25:000PM','192.168.1.120','User1','POST','/compsite/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:24:000PM','192.168.1.109','User2','POST','/News/_layouts/AssetPortalBrowser.aspx','APDView=Thumbs&DefaultAssetLocation=&DefaultAssetImageLocation=&DisplayLookInSection=true&DefaultToLastUsedLocation=true&ManageHyperlink=true&DisplayWidth=&DisplayHeight=&AllowExternalUrls=true&OverrideDialogImageUrl=&OverrideDialogTitle=&Filter=1&Target=&ManageLinkDisplayText=true&UseDefaultSize=true&Width=&Height=&Border=0&VSpacing=&HSpacing=&Hyperlink=&Alignment=&AssetText=&AssetUrl=',200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:26:11:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:29:000PM','192.168.1.109','User2','POST','/News/_layouts/AssetPortalBrowser.aspx','APDView=Thumbs&DefaultAssetLocation=&DefaultAssetImageLocation=&DisplayLookInSection=true&DefaultToLastUsedLocation=true&ManageHyperlink=true&DisplayWidth=&DisplayHeight=&AllowExternalUrls=true&OverrideDialogImageUrl=&OverrideDialogTitle=&Filter=1&Target=&ManageLinkDisplayText=true&UseDefaultSize=true&Width=&Height=&Border=0&VSpacing=&HSpacing=&Hyperlink=&Alignment=&AssetText=&AssetUrl=',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:25:000PM','192.168.1.120','User1','GET','/compsite/Wiki+Pages/Forms/ByAuthor.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:27:000PM','192.168.1.120','User1','POST','/compsite/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:28:000PM','192.168.1.120','User1','GET','/compSite/Wiki+Pages/Home.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:18:000AM','192.168.1.120','User4','GET','/_layouts/1033/styles/HtmlEditorCustomStyles.css','rev=8SKxtNx33FmoDhbbfB27UA%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:42:000PM','192.168.1.109','User5','GET','/_layouts/upload.aspx','RootFolder=%2FSiteCollectionImages&List=16c82ee9%2Dcd28%2D4df3%2D83f4%2D366fd9771eae&',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:00:10:000PM','192.168.1.109','User5','POST','/_layouts/upload.aspx','RootFolder=%2fSiteCollectionImages&List=16c82ee9-cd28-4df3-83f4-366fd9771eae&',302)
INSERT INTO [logs] VALUES('Mar 31 2009 2:00:12:000PM','192.168.1.109','User5','GET','/SiteCollectionImages/Forms/AllItems.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:00:12:000PM','192.168.1.109','User5','GET','/_layouts/images/icjpg.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:00:12:000PM','192.168.1.109','User5','GET','/_layouts/1033/images/new.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:00:14:000PM','192.168.1.109','User5','GET','/_layouts/AssetUploader.aspx','Size=Small&ImageUrl=%2fSiteCollectionImages%2fBankLoan%2ejpg',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:18:000AM','192.168.1.120','User4','GET','/_layouts/1033/init.js','rev=ck%2BHdHQ8ABQHif7kr%2Bj7iQ%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:18:000AM','192.168.1.120','User4','GET','/_layouts/portal.js','rev=cRI8b5r5N%2BkLhIuWR03ICg%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:18:000AM','192.168.1.120','User4','GET','/_layouts/1033/core.js','rev=S5dt4K8TJGVTYU9HrW6enw%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:18:000AM','192.168.1.120','User4','GET','/_layouts/1033/ie55up.js','rev=Ni7%2Fj2ZV%2FzCvd09XYSSWvA%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/1033/search.js','rev=yqBjpvg%2Foi3KG5XVf%2FStmA%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/1033/EditingMenu.js','rev=O4%2BTJbLGM9Af07theU%2BW6A%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/1033/SpellCheckEntirePage.js','rev=zYQ05cOj5Dk74UkTZzEIRw%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/Serialize.js','rev=yoPAvZ5aIeY93U62X8ie%2FQ%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/WebResource.axd','d=fWohqYhDDzsEpGWUnQlNkg2&t=633616811845362613',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/WebResource.axd','d=22XfSRd6vKE5QoRf1EQoEQ2&t=633616811845362613',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/menudark.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:06:06:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:06:06:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/blank.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/helpicon.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/WebResource.axd','d=WkSv3DH08f8UpGexNTegdciW74rKqn5R2rvoWijY1Kc1&t=633616811845362613',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/titlegraphic.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/WebResource.axd','d=oWbBVRL9UToSEMiDWk39o4utK72YFSC8oSvRQYxcZTU1&t=633616811845362613',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/whitearrow.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/gosearch.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/edit.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:26:11:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/cnspub16.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/wppinval.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/check.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/topnavselected.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:05:59:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:05:59:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/siteTitleBKGD.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/topnavunselected.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/siteactionsmenugrad.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/cnsugrdn.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/pageTitleBKGD.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/qarsgrd.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/PublishingImages/newsarticleimage.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/recycbin.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/lstbulet.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/Menu1.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/navBullet.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/navshape.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:06:12:000AM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:06:12:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:06:12:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/pagebackgrad.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/quickLaunchHeader.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:19:000AM','192.168.1.120','User4','GET','/_layouts/images/icongo01.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:26:000AM','192.168.1.120','User4','GET','/_Layouts/CreatePage.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:26:000AM','192.168.1.120','User4','GET','/_layouts/1033/styles/portal.css','rev=YMiIpAiFSDHNa2sUsGbXPA%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:26:000AM','192.168.1.120','User4','GET','/_layouts/1033/commonvalidation.js','rev=spf%2Fq4xG%2F7Q5Z5VBf6Qu0w%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:26:000AM','192.168.1.120','User4','GET','/_layouts/datepicker.js','rev=SyMUjwYFjbxLIeSLuQQeCA%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:26:000AM','192.168.1.120','User4','GET','/_layouts/1033/PickerTreeDialog.js','rev=OX%2FKcOCj4hID5Eg0YSvXWg%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:26:000AM','192.168.1.120','User4','GET','/_layouts/1033/BForm.js','rev=tL%2Bmggx3S50EJH1Ij%2BXl8A%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:26:000AM','192.168.1.120','User4','GET','/_layouts/1033/SelectorControls.js','rev=SyywcXCisJ5e0e2nVtMNEg%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:26:000AM','192.168.1.120','User4','GET','/WebResource.axd','d=LEEA4oZuioTbDne4bix-Cuh8__VBDtwG38Nms-LdwUo1&t=633616811845362613',200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:28:17:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:28:17:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:26:000AM','192.168.1.120','User4','GET','/_layouts/images/formtitlegrad.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:27:000AM','192.168.1.120','User4','GET','/_catalogs/masterpage/en-US/Preview+Images/ArticleBodyOnly.png',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:27:000AM','192.168.1.120','User4','GET','/_layouts/images/topnavhover.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:29:000AM','192.168.1.120','User4','GET','/Reports/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:29:000AM','192.168.1.120','User4','GET','/_layouts/kpilro.js','rev=X6SafBml4uxaGuKY%2BioU8w%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:29:000AM','192.168.1.120','User4','GET','/_layouts/images/topshape.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:29:000AM','192.168.1.120','User4','GET','/_layouts/images/rect.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:29:000AM','192.168.1.120','User4','GET','/_layouts/images/Kpi_ShowProblems.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:29:000AM','192.168.1.120','User4','GET','/_layouts/images/downarrw.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:29:000AM','192.168.1.120','User4','GET','/_layouts/images/kpiprogressbar.GIF',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:29:000AM','192.168.1.120','User4','GET','/_layouts/images/listheadergrad.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:29:000AM','192.168.1.120','User4','GET','/_layouts/images/viewheadergrad.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:28:17:000AM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:29:000AM','192.168.1.120','User4','GET','/_layouts/images/selectednav.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:29:000AM','192.168.1.120','User4','POST','/Reports/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:29:000AM','192.168.1.120','User4','POST','/Reports/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:30:000AM','192.168.1.120','User4','GET','/_layouts/images/KPIDefault-0.GIF',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:30:000AM','192.168.1.120','User4','GET','/_layouts/images/KPIDefault-1.GIF',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:30:000AM','192.168.1.120','User4','POST','/Reports/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:30:000AM','192.168.1.120','User4','GET','/_layouts/images/KPIDefault-2.GIF',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:31:000AM','192.168.1.120','User4','GET','/Reports/Lists/Sample+KPIs/DispForm.aspx','ID=2&Source=%2FReports%2FPages%2FDefault%2Easpx&IconPrefix=KpiIconChange',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:31:000AM','192.168.1.120','User4','GET','/_layouts/1033/form.js','rev=df60y6YolDjUVbi91%2BZw%2Fg%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:46:12:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:31:000AM','192.168.1.120','User4','GET','/_layouts/images/edititem.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:50:000PM','192.168.1.109','User2','GET','/_layouts/images/wpqaicon.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:50:000PM','192.168.1.109','User2','GET','/_layouts/images/globgrad.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:50:000PM','192.168.1.109','User2','GET','/_layouts/images/wpqaM.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:51:000PM','192.168.1.109','User2','GET','/_layouts/images/wpqaMH.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:01:000PM','192.168.1.109','User2','GET','/News/_layouts/AssetImagePicker.aspx','DefaultAssetLocation=&DefaultAssetImageLocation=&DisplayLookInSection=true&DefaultToLastUsedLocation=true&ManageHyperlink=true&DisplayWidth=&DisplayHeight=&AllowExternalUrls=true&OverrideDialogImageUrl=&OverrideDialogTitle=&UseDefaultSize=true&Hyperlink=&AssetUrl=&AssetText=&Height=0&Width=0&Border=0&HSpacing=&VSpacing=&Alignment=&Target=&ManageLinkDisplayText=true',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:01:000PM','192.168.1.109','User2','GET','/_layouts/1033/owsbrows.js','rev=%2FOcWXc03f8AvM0C%2F2LOCjA%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:01:000PM','192.168.1.109','User2','GET','/_layouts/images/dialogTitleBKGD.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:59:01:000PM','192.168.1.109','User2','GET','/_layouts/images/detail.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:05:56:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:05:56:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:05:56:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:31:000AM','192.168.1.120','User4','GET','/_layouts/images/delitem.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:31:000AM','192.168.1.120','User4','GET','/_layouts/images/manageperm.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:31:000AM','192.168.1.120','User4','GET','/_layouts/images/toolgrad.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:31:000AM','192.168.1.120','User4','GET','/_layouts/images/KPIDefaultLarge-1.GIF',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:34:000AM','192.168.1.120','User4','GET','/_layouts/images/menubuttonhover.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:34:000AM','192.168.1.120','User4','GET','/MySite/_layouts/MySite.aspx',NULL,302)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:34:000AM','192.168.1.120','User4','GET','/personal/administrator',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:39:000AM','192.168.1.120','User4','GET','/_layouts/images/menuprofile.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:39:000AM','192.168.1.120','User4','GET','/_layouts/blank.htm',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:46:12:000AM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:39:000AM','192.168.1.120','User4','GET','/Reports/_layouts/SignOut.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:39:000AM','192.168.1.120','User4','GET','/_layouts/images/error.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:37:41:000AM','192.168.1.120','User4','GET','/personal/administrator/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:42:39:000AM','192.168.1.109','User5','GET','/personal/john/Blog/Lists/OtherBlogs/NewForm.aspx','Source=http%3A%2F%2Fsv%2Dbic%2D0001%2Fpersonal%2Fjohn%2FBlog%2FLists%2FPosts%2FPost%2Easpx%3FID%3D2',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:42:42:000AM','192.168.1.109','User5','GET','/personal/john/Blog/Lists/OtherBlogs/AllItems.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:42:42:000AM','192.168.1.109','User5','GET','/_layouts/images/links.png',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:42:46:000AM','192.168.1.109','User5','GET','/personal/john/Blog/Lists/Posts/AllPosts.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:42:46:000AM','192.168.1.109','User5','GET','/_layouts/images/posts.png',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:42:51:000AM','192.168.1.109','User5','GET','/personal/john/Blog/Lists/Categories/AllCategories.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:42:51:000AM','192.168.1.109','User5','GET','/_layouts/images/categories.png',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:28:17:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:28:23:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 11:28:23:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:42:54:000AM','192.168.1.109','User5','GET','/_layouts/images/menudatasheet.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:42:54:000AM','192.168.1.109','User5','GET','/_layouts/images/MenuRSS.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:42:57:000AM','192.168.1.109','User5','GET','/personal/john/Blog/_vti_bin/owssvr.dll','CS=65001&Using=_layouts/query.iqy&List=%7BC2951F7D%2D77F5%2D480C%2DBEE0%2D8C8B87421CB3%7D&View=%7B03B24C3C%2DDCB7%2D406B%2D836B%2D612418F10361%7D&RootFolder=%2Fpersonal%2Fjohn%2FBlog%2FLists%2FCategories&CacheControl=1',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:43:00:000AM','192.168.1.109','User5','GET','/personal/john/Blog/Lists/Comments/AllComments.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:43:02:000AM','192.168.1.109','User5','GET','/_layouts/images/modifyview.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:43:04:000AM','192.168.1.109','User5','GET','/personal/john/Blog/Lists/Comments/MyComments.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:46:12:000AM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:46:12:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:46:16:000AM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:43:09:000AM','192.168.1.109','User5','GET','/personal/john/Blog/_layouts/viewlsts.aspx','BaseType=1&ListTemplate=109',200)
INSERT INTO [logs] VALUES('Mar 31 2009 10:43:13:000AM','192.168.1.109','User5','GET','/personal/john/Blog/Lists/Photos/Forms/AllItems.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:26:09:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:26:09:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 12:26:09:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:06:02:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:06:02:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:06:02:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:06:02:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:06:02:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:06:02:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:06:12:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:06:12:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:12:14:000PM','192.168.1.109','User5','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:12:36:000PM','192.168.1.109','User5','GET','/personal/john/Blog/_layouts/viewlsts.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:12:36:000PM','192.168.1.109','User5','GET','/_layouts/images/itcat.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:12:36:000PM','192.168.1.109','User5','GET','/_layouts/images/itcommnt.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:12:36:000PM','192.168.1.109','User5','GET','/_layouts/images/itlink.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:12:36:000PM','192.168.1.109','User5','GET','/_layouts/images/itposts.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:12:53:000PM','192.168.1.109','User5','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:12:53:000PM','192.168.1.109','User5','GET','/PublishingImages/newsarticleimage.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:13:15:000PM','192.168.1.109','User5','GET','/_layouts/images/qahvgrd.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:13:22:000PM','192.168.1.109','User5','GET','/News/Pages/newsarchive.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:15:10:000PM','192.168.1.109','User5','GET','/SearchCenter/Pages/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:15:36:000PM','192.168.1.109','User5','GET','/SiteDirectory/Pages/category.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:15:38:000PM','192.168.1.109','User5','GET','/_layouts/images/menupersonalize.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:15:40:000PM','192.168.1.109','User5','GET','/SiteDirectory/_layouts/SignOut.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:26:05:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:26:05:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:26:05:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:26:05:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:26:06:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:26:09:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:26:11:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:26:11:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:47:49:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:47:49:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:47:49:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:47:49:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:47:52:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:47:52:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:48:00:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:48:00:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:35:000PM','192.168.1.109','User2','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:35:000PM','192.168.1.109','User2','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:35:000PM','192.168.1.109','User2','GET','/_layouts/1033/styles/controls.css','rev=EhwiQKSLiI%2F4dGDs6DyUdQ%3D%3D',304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:35:000PM','192.168.1.109','User2','GET','/_layouts/1033/styles/HtmlEditorCustomStyles.css','rev=8SKxtNx33FmoDhbbfB27UA%3D%3D',304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:35:000PM','192.168.1.109','User2','GET','/_layouts/1033/styles/HtmlEditorTableFormats.css','rev=guYGdUBUxQit03E2jhSdvA%3D%3D',304)
INSERT INTO [logs] VALUES('Mar 31 2009 3:26:12:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:26:12:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:35:000PM','192.168.1.109','User2','GET','/_layouts/1033/styles/core.css','rev=5msmprmeONfN6lJ3wtbAlA%3D%3D',304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:35:000PM','192.168.1.109','User2','GET','/_layouts/1033/init.js','rev=ck%2BHdHQ8ABQHif7kr%2Bj7iQ%3D%3D',304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:35:000PM','192.168.1.109','User2','GET','/_layouts/1033/core.js','rev=S5dt4K8TJGVTYU9HrW6enw%3D%3D',304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:35:000PM','192.168.1.109','User2','GET','/_layouts/portal.js','rev=cRI8b5r5N%2BkLhIuWR03ICg%3D%3D',304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:35:000PM','192.168.1.109','User2','GET','/_layouts/1033/ie55up.js','rev=Ni7%2Fj2ZV%2FzCvd09XYSSWvA%3D%3D',304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/1033/search.js','rev=yqBjpvg%2Foi3KG5XVf%2FStmA%3D%3D',304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/1033/EditingMenu.js','rev=O4%2BTJbLGM9Af07theU%2BW6A%3D%3D',304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/1033/SpellCheckEntirePage.js','rev=zYQ05cOj5Dk74UkTZzEIRw%3D%3D',304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/WebResource.axd','d=fWohqYhDDzsEpGWUnQlNkg2&t=633616811845362613',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/Serialize.js','rev=yoPAvZ5aIeY93U62X8ie%2FQ%3D%3D',304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/WebResource.axd','d=22XfSRd6vKE5QoRf1EQoEQ2&t=633616811845362613',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/menudark.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 3:45:58:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:45:58:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/blank.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/helpicon.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/gosearch.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/titlegraphic.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/WebResource.axd','d=WkSv3DH08f8UpGexNTegdciW74rKqn5R2rvoWijY1Kc1&t=633616811845362613',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/WebResource.axd','d=oWbBVRL9UToSEMiDWk39o4utK72YFSC8oSvRQYxcZTU1&t=633616811845362613',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/whitearrow.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/edit.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/cnspub16.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/wppinval.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/siteTitleBKGD.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/check.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/topnavselected.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 3:45:59:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:45:59:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/topnavunselected.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/siteactionsmenugrad.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/pageTitleBKGD.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/cnsugrdn.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/qarsgrd.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/recycbin.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/PublishingImages/newsarticleimage.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/lstbulet.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/Menu1.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/navshape.jpg',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/navBullet.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/pagebackgrad.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/icongo01.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 3:26:12:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:36:000PM','192.168.1.109','User2','GET','/_layouts/images/quickLaunchHeader.gif',NULL,304)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:43:000PM','192.168.1.109','User2','GET','/WebResource.axd','d=LEEA4oZuioTbDne4bix-Cuh8__VBDtwG38Nms-LdwUo1&t=633616811845362613',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:43:000PM','192.168.1.109','User2','GET','/_layouts/aclinv.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:43:000PM','192.168.1.109','User2','GET','/_layouts/images/addressbook.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:43:000PM','192.168.1.109','User2','GET','/_layouts/images/checknames.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:48:000PM','192.168.1.109','User2','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:48:000PM','192.168.1.109','User2','GET','/PublishingImages/newsarticleimage.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:55:000PM','192.168.1.109','User2','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:55:000PM','192.168.1.109','User2','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:56:55:000PM','192.168.1.109','User2','GET','/PublishingImages/newsarticleimage.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:57:00:000PM','192.168.1.109','User2','GET','/News',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:57:04:000PM','192.168.1.109','User2','GET','/News/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:06:01:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:06:01:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:06:01:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:57:04:000PM','192.168.1.109','User2','POST','/News/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:57:12:000PM','192.168.1.109','User2','GET','/News/Pages/NewsArchive.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:57:15:000PM','192.168.1.109','User2','GET','/SiteDirectory/Pages/category.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:57:20:000PM','192.168.1.109','User2','GET','/SearchCenter/Pages/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:57:29:000PM','192.168.1.109','User2','GET','/SearchCenter/Pages/results.aspx','k=a',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:57:38:000PM','192.168.1.109','User2','GET','/News/Pages/newsarchive.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:57:46:000PM','192.168.1.109','User2','GET','/_layouts/images/crtpage.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:57:46:000PM','192.168.1.109','User2','GET','/_layouts/images/crtsite.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:57:46:000PM','192.168.1.109','User2','GET','/_layouts/images/vwcntnt.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:57:46:000PM','192.168.1.109','User2','GET','/_layouts/images/MArr.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:57:46:000PM','192.168.1.109','User2','GET','/_layouts/images/smt_small.png',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:57:50:000PM','192.168.1.109','User2','GET','/News/_layouts/CreatePage.aspx','CancelSource=%2FNews%2FPages%2Fnewsarchive%2Easpx',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:57:50:000PM','192.168.1.109','User2','GET','/_layouts/1033/commonvalidation.js','rev=spf%2Fq4xG%2F7Q5Z5VBf6Qu0w%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:26:13:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:26:13:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:57:50:000PM','192.168.1.109','User2','GET','/_layouts/1033/PickerTreeDialog.js','rev=OX%2FKcOCj4hID5Eg0YSvXWg%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:57:50:000PM','192.168.1.109','User2','GET','/_layouts/datepicker.js','rev=SyMUjwYFjbxLIeSLuQQeCA%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:57:50:000PM','192.168.1.109','User2','GET','/_layouts/1033/BForm.js','rev=tL%2Bmggx3S50EJH1Ij%2BXl8A%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:57:50:000PM','192.168.1.109','User2','GET','/_layouts/1033/SelectorControls.js','rev=SyywcXCisJ5e0e2nVtMNEg%3D%3D',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:57:50:000PM','192.168.1.109','User2','GET','/_catalogs/masterpage/en-US/Preview+Images/ArticleBodyOnly.png',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:10:000PM','192.168.1.109','User2','GET','/_catalogs/masterpage/en-US/Preview+Images/ArticleLeft.png',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:11:000PM','192.168.1.109','User2','GET','/_catalogs/masterpage/en-US/Preview+Images/ArticleRight.png',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:13:000PM','192.168.1.109','User2','GET','/_catalogs/masterpage/en-US/Preview+Images/ArticleLinks.png',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:14:000PM','192.168.1.109','User2','GET','/_catalogs/masterpage/en-US/Preview+Images/DefaultPageLayout.png',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:16:000PM','192.168.1.109','User2','GET','/_catalogs/masterpage/Preview+Images/advancedsearch.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:17:000PM','192.168.1.109','User2','GET','/_catalogs/masterpage/en-US/Preview+Images/BlankWebPartPage.png',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:05:56:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:28:000PM','192.168.1.109','User2','GET','/_catalogs/masterpage/Preview+Images/peoplesearchpage.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:30:000PM','192.168.1.109','User2','GET','/_catalogs/masterpage/Preview+Images/searchpage.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:31:000PM','192.168.1.109','User2','GET','/_catalogs/masterpage/Preview+Images/searchresults.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:32:000PM','192.168.1.109','User2','GET','/_catalogs/masterpage/Preview+Images/sitedir_layout.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:34:000PM','192.168.1.109','User2','GET','/_catalogs/masterpage/en-US/Preview+Images/WelcomeLinks.png',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:46:000PM','192.168.1.109','User2','POST','/News/_layouts/CreatePage.aspx','CancelSource=%2fNews%2fPages%2fnewsarchive.aspx',302)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:50:000PM','192.168.1.109','User2','GET','/News/Pages/PageM.aspx','ControlMode=Edit&DisplayMode=Design',200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:50:000PM','192.168.1.109','User2','GET','/Style+Library/en-US/Core+Styles/zz2_editMode.css',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 1:58:50:000PM','192.168.1.109','User2','GET','/Style+Library/en-US/Core+Styles/pageLayouts.css',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:06:16:000PM','192.168.1.120','User1','GET','/SiteCollectionImages/Forms/WebFldr.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:06:16:000PM','192.168.1.120','User1','GET','/News/Pages/PageM.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:00:37:000PM','192.168.1.109','User5','GET','/SiteCollectionImages/BankLoan.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:00:47:000PM','192.168.1.109','User2','POST','/News/_layouts/AssetPortalBrowser.aspx','APDView=Thumbs&DefaultAssetLocation=&DefaultAssetImageLocation=&DisplayLookInSection=true&DefaultToLastUsedLocation=true&ManageHyperlink=true&DisplayWidth=&DisplayHeight=&AllowExternalUrls=true&OverrideDialogImageUrl=&OverrideDialogTitle=&Filter=1&Target=&ManageLinkDisplayText=true&UseDefaultSize=true&Width=&Height=&Border=0&VSpacing=&HSpacing=&Hyperlink=&Alignment=&AssetText=&AssetUrl=',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:00:48:000PM','192.168.1.109','User2','POST','/News/_layouts/AssetPortalBrowser.aspx','APDView=Thumbs&DefaultAssetLocation=&DefaultAssetImageLocation=&DisplayLookInSection=true&DefaultToLastUsedLocation=true&ManageHyperlink=true&DisplayWidth=&DisplayHeight=&AllowExternalUrls=true&OverrideDialogImageUrl=&OverrideDialogTitle=&Filter=1&Target=&ManageLinkDisplayText=true&UseDefaultSize=true&Width=&Height=&Border=0&VSpacing=&HSpacing=&Hyperlink=&Alignment=&AssetText=&AssetUrl=',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:00:51:000PM','192.168.1.109','User2','POST','/News/_layouts/AssetPortalBrowser.aspx','APDView=Thumbs&DefaultAssetLocation=&DefaultAssetImageLocation=&DisplayLookInSection=true&DefaultToLastUsedLocation=true&ManageHyperlink=true&DisplayWidth=&DisplayHeight=&AllowExternalUrls=true&OverrideDialogImageUrl=&OverrideDialogTitle=&Filter=1&Target=&ManageLinkDisplayText=true&UseDefaultSize=true&Width=&Height=&Border=0&VSpacing=&HSpacing=&Hyperlink=&Alignment=&AssetText=&AssetUrl=',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:00:54:000PM','192.168.1.109','User2','POST','/News/_layouts/AssetPortalBrowser.aspx','APDView=Thumbs&DefaultAssetLocation=&DefaultAssetImageLocation=&DisplayLookInSection=true&DefaultToLastUsedLocation=true&ManageHyperlink=true&DisplayWidth=&DisplayHeight=&AllowExternalUrls=true&OverrideDialogImageUrl=&OverrideDialogTitle=&Filter=1&Target=&ManageLinkDisplayText=true&UseDefaultSize=true&Width=&Height=&Border=0&VSpacing=&HSpacing=&Hyperlink=&Alignment=&AssetText=&AssetUrl=',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:00:54:000PM','192.168.1.109','User2','GET','/News/_layouts/AssetUploader.aspx','ImageUrl=%2FSiteCollectionImages%2FBankLoan%2Ejpg',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:03:000PM','192.168.1.109','User2','POST','/News/_layouts/AssetPortalBrowser.aspx','APDView=Thumbs&DefaultAssetLocation=&DefaultAssetImageLocation=&DisplayLookInSection=true&DefaultToLastUsedLocation=true&ManageHyperlink=true&DisplayWidth=&DisplayHeight=&AllowExternalUrls=true&OverrideDialogImageUrl=&OverrideDialogTitle=&Filter=1&Target=&ManageLinkDisplayText=true&UseDefaultSize=true&Width=&Height=&Border=0&VSpacing=&HSpacing=&Hyperlink=&Alignment=&AssetText=&AssetUrl=',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:03:000PM','192.168.1.109','User2','GET','/News/_layouts/AssetUploader.aspx','ImageUrl=%2FSiteCollectionImages%2FBankLoan%2Ejpg',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:10:000PM','192.168.1.109','User2','POST','/News/_layouts/AssetPortalBrowser.aspx','APDView=Thumbs&DefaultAssetLocation=&DefaultAssetImageLocation=&DisplayLookInSection=true&DefaultToLastUsedLocation=true&ManageHyperlink=true&DisplayWidth=&DisplayHeight=&AllowExternalUrls=true&OverrideDialogImageUrl=&OverrideDialogTitle=&Filter=1&Target=&ManageLinkDisplayText=true&UseDefaultSize=true&Width=&Height=&Border=0&VSpacing=&HSpacing=&Hyperlink=&Alignment=&AssetText=&AssetUrl=',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:10:000PM','192.168.1.109','User2','GET','/News/_layouts/AssetUploader.aspx','ImageUrl=%2FSiteCollectionImages%2FBankLoan%2Ejpg',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:25:000PM','192.168.1.109','User2','POST','/News/_layouts/AssetImagePicker.aspx','DefaultAssetLocation=&DefaultAssetImageLocation=&DisplayLookInSection=true&DefaultToLastUsedLocation=true&ManageHyperlink=true&DisplayWidth=&DisplayHeight=&AllowExternalUrls=true&OverrideDialogImageUrl=&OverrideDialogTitle=&UseDefaultSize=true&Hyperlink=&AssetUrl=&AssetText=&Height=0&Width=0&Border=0&HSpacing=&VSpacing=&Alignment=&Target=&ManageLinkDisplayText=true',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:25:000PM','192.168.1.109','User2','GET','/SiteCollectionImages/BankLoan.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:40:000PM','192.168.1.109','User2','GET','/_layouts/images/SMT_GRIPPY.GIF',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:40:000PM','192.168.1.109','User2','GET','/_layouts/images/rte2redo.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:40:000PM','192.168.1.109','User2','GET','/_layouts/images/rte2unlink.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:40:000PM','192.168.1.109','User2','GET','/_layouts/blank.html',NULL,404)
INSERT INTO [logs] VALUES('Mar 31 2009 3:05:56:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:05:56:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:40:000PM','192.168.1.109','User2','GET','/_layouts/1033/images/rte2rstyl.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:40:000PM','192.168.1.109','User2','GET','/_layouts/1033/images/rte2paragraphformat.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:40:000PM','192.168.1.109','User2','GET','/_layouts/images/paste.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:40:000PM','192.168.1.109','User2','GET','/_layouts/images/rtebnsel.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:56:000PM','192.168.1.109','User2','GET','/News/_layouts/webpartgallerypickerpage.aspx','SiteId=e64480d6-28ad-4bab-a870-fb825df7096c&WebId=018a89c9-a0e2-47a2-826f-f1799c07c290&NumberOfWebPartsInZone=0&MaxWebPartsInZone=50&ZoneDisplayName=Left%20Column',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:56:000PM','192.168.1.109','User2','GET','/_layouts/images/minus.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:56:000PM','192.168.1.109','User2','GET','/_layouts/images/search.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:05:56:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:05:56:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:56:000PM','192.168.1.109','User2','GET','/_layouts/images/bizdatawebpart.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:56:000PM','192.168.1.109','User2','GET','/_layouts/images/ewr023.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:56:000PM','192.168.1.109','User2','GET','/_layouts/images/webpart.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:56:000PM','192.168.1.109','User2','GET','/_layouts/images/wp_doc.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:56:000PM','192.168.1.109','User2','GET','/_layouts/images/KpiDetailWP.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:56:000PM','192.168.1.109','User2','GET','/_layouts/images/KpiListWP.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:56:000PM','192.168.1.109','User2','GET','/_layouts/images/wp_Filter.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:56:000PM','192.168.1.109','User2','GET','/_layouts/images/wp_pers.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:56:000PM','192.168.1.109','User2','GET','/_layouts/images/mscontl.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:56:000PM','192.168.1.109','User2','GET','/_layouts/images/mssfwp.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:05:58:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:56:000PM','192.168.1.109','User2','GET','/_layouts/images/msimagel.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:56:000PM','192.168.1.109','User2','GET','/_layouts/images/msusdocs.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:56:000PM','192.168.1.109','User2','GET','/_layouts/images/mscntvwl.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:56:000PM','192.168.1.109','User2','GET','/_layouts/images/msustask.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:56:000PM','192.168.1.109','User2','GET','/_layouts/images/msxmll.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:01:56:000PM','192.168.1.109','User2','GET','/_layouts/images/msmeml.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:02:42:000PM','192.168.1.109','User2','POST','/News/_layouts/webpartgallerypickerpage.aspx','SiteId=e64480d6-28ad-4bab-a870-fb825df7096c&WebId=018a89c9-a0e2-47a2-826f-f1799c07c290&NumberOfWebPartsInZone=0&MaxWebPartsInZone=50&ZoneDisplayName=Left+Column',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:05:58:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:05:58:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:05:58:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:06:00:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:02:44:000PM','192.168.1.109','User2','POST','/News/Pages/PageM.aspx','ControlMode=Edit&DisplayMode=Design',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:02:44:000PM','192.168.1.109','User2','GET','/Style+Library/en-US/Core+Styles/zz2_editMode.css',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:02:44:000PM','192.168.1.109','User2','GET','/Style+Library/en-US/Core+Styles/pageLayouts.css',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:02:44:000PM','192.168.1.109','User2','GET','/SiteCollectionImages/BankLoan.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:02:44:000PM','192.168.1.109','User2','GET','/_layouts/images/ptclose.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:02:44:000PM','192.168.1.109','User2','GET','/_layouts/images/partgrad.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:03:09:000PM','192.168.1.109','User2','GET','/_layouts/images/qahvgrd.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:03:09:000PM','192.168.1.109','User2','GET','/_layouts/images/qahvgrd.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:03:13:000PM','192.168.1.109','User2','POST','/News/Pages/PageM.aspx','ControlMode=Edit&DisplayMode=Design',302)
INSERT INTO [logs] VALUES('Mar 31 2009 2:03:13:000PM','192.168.1.109','User2','GET','/News/Pages/PageM.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:06:13:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:06:13:000PM','192.168.1.120','User1','POST','/news/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:03:13:000PM','192.168.1.109','User2','GET','/Style+Library/en-US/Core+Styles/pageLayouts.css',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:03:13:000PM','192.168.1.109','User2','GET','/SiteCollectionImages/BankLoan.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:04:25:000PM','192.168.1.109','User2','GET','/News/_layouts/newsbweb.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:04:25:000PM','192.168.1.109','User2','GET','/_layouts/images/stsprev.png',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:04:25:000PM','192.168.1.109','User2','GET','/_layouts/images/templatepickerunselected.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:04:32:000PM','192.168.1.109','User2','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:04:32:000PM','192.168.1.109','User2','GET','/PublishingImages/newsarticleimage.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:04:35:000PM','192.168.1.109','User2','GET','/_layouts/newsbweb.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:05:06:000PM','192.168.1.111','User3','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:05:06:000PM','192.168.1.111','User3','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:05:58:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:05:07:000PM','192.168.1.109','User2','GET','/_layouts/images/wikiprev.png',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:05:21:000PM','192.168.1.111','User3','GET','/PublishingImages/newsarticleimage.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:05:48:000PM','192.168.1.111','User3','GET','/_layouts/images/qahvgrd.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:05:49:000PM','192.168.1.109','User2','POST','/_layouts/newsbweb.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:05:51:000PM','192.168.1.111','User3','GET','/_layouts/images/topnavhover.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:06:06:000PM','192.168.1.109','User2','GET','/_layouts/help.aspx','Lcid=1033&Key=troubleshooting',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:06:06:000PM','192.168.1.111','User3','GET','/Docs',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:06:08:000PM','192.168.1.111','User3','GET','/Docs/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:45:58:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:45:58:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:06:08:000PM','192.168.1.111','User3','GET','/WebResource.axd','d=rVq0f9SiwWG9OaStrB9yzw2&t=633616811845362613',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:06:08:000PM','192.168.1.111','User3','GET','/_layouts/images/tvblank.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:06:08:000PM','192.168.1.111','User3','GET','/_layouts/images/itann.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:06:08:000PM','192.168.1.111','User3','GET','/_layouts/images/icgen.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:06:08:000PM','192.168.1.111','User3','GET','/_layouts/images/edititem.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:06:09:000PM','192.168.1.111','User3','GET','/_layouts/images/tvplus.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:06:09:000PM','192.168.1.111','User3','GET','/_layouts/images/tvminus.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:26:12:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:26:12:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:06:28:000PM','192.168.1.111','User3','GET','/Docs/Documents/Tally+Settings+General.odt',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:06:37:000PM','192.168.1.109','User2','POST','/_layouts/newsbweb.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:06:39:000PM','192.168.1.109','User2','GET','/compSite',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:06:42:000PM','192.168.1.109','User2','GET','/compSite/Wiki+Pages/Home.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:06:44:000PM','192.168.1.111','User3','GET','/Docs/Documents/Tally+Settings+General.odt',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:07:04:000PM','192.168.1.109','User2','GET','/compSite/Wiki+Pages/How+To+Use+This+Wiki+Site.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:07:08:000PM','192.168.1.109','User2','GET','/compSite/Wiki+Pages/Forms/AllPages.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:07:14:000PM','192.168.1.109','User2','GET','/compSite/Wiki+Pages/Home.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:07:18:000PM','192.168.1.109','User2','GET','/compSite/Wiki+Pages/Forms/EditForm.aspx','ID=1',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:07:58:000PM','192.168.1.109','User2','GET','/compSite/Wiki+Pages/Home.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:07:58:000PM','192.168.1.109','User2','POST','/compSite/Wiki+Pages/Forms/EditForm.aspx','ID=1',302)
INSERT INTO [logs] VALUES('Mar 31 2009 2:08:13:000PM','192.168.1.109','User2','GET','/compSite/_layouts/AccessDenied.aspx','loginasanotheruser=true&Source=http%3A%2F%2Fsv%2Dbic%2D0001%2FBICSite%2FWiki%2520Pages%2FHome%2Easpx',401)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:27:000PM','192.168.1.120','User1','GET','/compsite/Wiki+Pages/Forms/AllPages.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:27:000PM','192.168.1.120','User1','GET','/compsite/Wiki+Pages/Forms/ByEditor.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:27:000PM','192.168.1.120','User1','GET','/compsite/Wiki+Pages/Forms/CreatedByMe.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:08:13:000PM','192.168.1.109','User2','GET','/compSite/_layouts/AccessDenied.aspx','loginasanotheruser=true&Source=http%3A%2F%2Fsv%2Dbic%2D0001%2FBICSite%2FWiki%2520Pages%2FHome%2Easpx',401)
INSERT INTO [logs] VALUES('Mar 31 2009 2:08:22:000PM','192.168.1.109','User5','GET','/compSite/_layouts/AccessDenied.aspx','loginasanotheruser=true&Source=http%3A%2F%2Fsv%2Dbic%2D0001%2FBICSite%2FWiki%2520Pages%2FHome%2Easpx',302)
INSERT INTO [logs] VALUES('Mar 31 2009 2:08:22:000PM','192.168.1.109','User5','GET','/compSite/Wiki+Pages/Home.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:08:27:000PM','192.168.1.109','User5','GET','/compSite/Wiki+Pages/Forms/EditForm.aspx','ID=1',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:08:39:000PM','192.168.1.109','User5','POST','/compSite/Wiki+Pages/Forms/EditForm.aspx','ID=1',302)
INSERT INTO [logs] VALUES('Mar 31 2009 2:08:40:000PM','192.168.1.109','User5','GET','/compSite/Wiki+Pages/Home.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:08:50:000PM','192.168.1.109','User5','GET','/compSite/Wiki+Pages/How+To+Use+This+Wiki+Site.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:27:000PM','192.168.1.120','User1','GET','/compSite/Wiki+Pages/Report.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:28:000PM','192.168.1.120','User1','GET','/compsite/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:28:000PM','192.168.1.120','User1','GET','/compSite/Wiki+Pages/How+To+Use+This+Wiki+Site.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:09:02:000PM','192.168.1.109','User5','GET','/compSite/Wiki+Pages/Home.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:09:16:000PM','192.168.1.109','User5','GET','/compSite/Wiki+Pages/Forms/EditForm.aspx','ID=1',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:09:29:000PM','192.168.1.109','User5','POST','/compSite/Wiki+Pages/Forms/EditForm.aspx','ID=1',302)
INSERT INTO [logs] VALUES('Mar 31 2009 2:09:29:000PM','192.168.1.109','User5','GET','/compSite/Wiki+Pages/Home.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:09:34:000PM','192.168.1.109','User5','GET','/SITEDIRECTORY/Pages/category.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:09:42:000PM','192.168.1.109','User5','GET','/SiteDirectory/Pages/topsites.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:09:43:000PM','192.168.1.109','User5','GET','/SiteDirectory/Pages/sitemap.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:09:48:000PM','192.168.1.109','User5','GET','/compSite/Wiki+Pages/Home.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:09:52:000PM','192.168.1.109','User5','GET','/compSite/Wiki+Pages/Forms/AllPages.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:09:59:000PM','192.168.1.109','User5','GET','/News/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:09:59:000PM','192.168.1.109','User5','POST','/News/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:10:04:000PM','192.168.1.109','User5','GET','/SearchCenter/Pages/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:10:06:000PM','192.168.1.109','User5','GET','/compSite/Wiki+Pages/Home.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:10:16:000PM','192.168.1.109','User5','GET','/SITEDIRECTORY/Pages/category.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:10:18:000PM','192.168.1.109','User5','GET','/SiteDirectory/Pages/categoryresults.aspx','Column=DivisionMulti&ColumnDisplayName=Division&Value=Information%20Technology',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:10:25:000PM','192.168.1.109','User5','GET','/SiteDirectory/Pages/categoryresults.aspx','Column=DivisionMulti&ColumnDisplayName=Division&Value=Research%20%26%20Development',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:10:29:000PM','192.168.1.109','User5','GET','/SiteDirectory/Pages/categoryresults.aspx','Column=DivisionMulti&ColumnDisplayName=Division&Value=Sales',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:10:34:000PM','192.168.1.109','User5','GET','/SiteDirectory/Pages/categoryresults.aspx','Column=DivisionMulti&ColumnDisplayName=Division&Value=Finance',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:10:41:000PM','192.168.1.109','User5','GET','/SiteDirectory/Pages/categoryresults.aspx','Column=RegionMulti&ColumnDisplayName=Region&Value=Local',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:45:58:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:45:58:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:45:58:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:10:44:000PM','192.168.1.109','User5','GET','/SiteDirectory/Pages/categoryresults.aspx','Column=RegionMulti&ColumnDisplayName=Region&Value=National',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:10:48:000PM','192.168.1.109','User5','GET','/SiteDirectory/Pages/categoryresults.aspx','Column=RegionMulti&ColumnDisplayName=Region&Value=International',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:10:51:000PM','192.168.1.109','User5','GET','/SiteDirectory/Pages/categoryresults.aspx','Column=TasksAndTools&ColumnDisplayName=Tasks%20and%20Tools&Value=Top%20Tasks',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:10:59:000PM','192.168.1.109','User5','GET','/SiteDirectory/_layouts/mysite.aspx','Redirect=1',302)
INSERT INTO [logs] VALUES('Mar 31 2009 2:10:59:000PM','192.168.1.109','User5','GET','/personal/john',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:11:05:000PM','192.168.1.109','User5','GET','/personal/john/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:11:05:000PM','192.168.1.109','User5','GET','/_layouts/images/discbul.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:11:05:000PM','192.168.1.109','User5','POST','/personal/john/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:11:05:000PM','192.168.1.109','User5','POST','/personal/john/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:10:000PM','192.168.1.120','User1','GET','/compsite/Wiki+Pages/Home.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:14:000PM','192.168.1.120','User1','GET','/personal/john/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:11:22:000PM','192.168.1.109','User5','GET','/personal/john/Blog/Lists/Posts/Post.aspx','ID=1',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:11:32:000PM','192.168.1.109','User5','GET','/personal/john/Blog/Lists/OtherBlogs/NewForm.aspx','Source=http%3A%2F%2Fsv%2Dbic%2D0001%2Fpersonal%2Fjohn%2FBlog%2FLists%2FPosts%2FPost%2Easpx%3FID%3D1',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:11:34:000PM','192.168.1.109','User5','GET','/personal/john/Blog/Lists/Posts/Post.aspx','ID=1',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:11:38:000PM','192.168.1.109','User5','GET','/personal/john/Blog/Lists/Posts/Archive.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:11:41:000PM','192.168.1.109','User5','GET','/personal/john/Blog/Lists/Posts/AllPosts.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:11:50:000PM','192.168.1.109','User5','GET','/personal/john/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:11:50:000PM','192.168.1.109','User5','GET','/personal/john',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:11:50:000PM','192.168.1.109','User5','POST','/personal/john/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:11:50:000PM','192.168.1.109','User5','POST','/personal/john/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:45:58:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:45:58:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:45:58:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:11:54:000PM','192.168.1.109','User5','GET','/personal/john/_layouts/EditProfile.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:11:54:000PM','192.168.1.109','User5','GET','/personal/john/_layouts/1033/bform.js',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:11:54:000PM','192.168.1.109','User5','GET','/_layouts/images/save.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:11:54:000PM','192.168.1.109','User5','GET','/_layouts/images/spsmysh.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:11:54:000PM','192.168.1.109','User5','GET','/_layouts/images/empty.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:11:54:000PM','192.168.1.109','User5','GET','/_layouts/images/choicebrowse.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:11:54:000PM','192.168.1.109','User5','GET','/_layouts/images/checkvalues.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:12:00:000PM','192.168.1.109','User5','GET','/personal/john/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:12:00:000PM','192.168.1.109','User5','GET','/personal/john',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:45:59:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:45:59:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:46:11:000PM','192.168.1.120','User1','POST','/docs/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:12:00:000PM','192.168.1.109','User5','POST','/personal/john/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:12:00:000PM','192.168.1.109','User5','POST','/personal/john/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:12:03:000PM','192.168.1.109','User5','POST','/personal/john/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:12:03:000PM','192.168.1.109','User5','GET','/_layouts/images/exitedit.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:12:03:000PM','192.168.1.109','User5','GET','/_layouts/images/tpmax.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:12:03:000PM','192.168.1.109','User5','GET','/_layouts/images/TPMin1.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:12:03:000PM','192.168.1.109','User5','GET','/_layouts/images/TPMax2.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:12:03:000PM','192.168.1.109','User5','GET','/_layouts/images/checkaudience.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:12:03:000PM','192.168.1.109','User5','POST','/personal/john/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:26:12:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:12:03:000PM','192.168.1.109','User5','POST','/personal/john/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:19:28:000PM','192.168.1.109','User5','POST','/personal/john/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:19:28:000PM','192.168.1.109','User5','POST','/personal/john/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:19:28:000PM','192.168.1.109','User5','POST','/personal/john/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:19:38:000PM','192.168.1.109','User5','POST','/personal/john/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:23:000PM','192.168.1.120','User1','GET','/compsite/_layouts/viewlsts.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:19:38:000PM','192.168.1.109','User5','POST','/personal/john/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:19:38:000PM','192.168.1.109','User5','POST','/personal/john/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:19:48:000PM','192.168.1.109','User5','GET','/MySite/Person.aspx','accountname=comp\john',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:20:09:000PM','192.168.1.109','User5','GET','/MySite',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:20:09:000PM','192.168.1.109','User5','GET','/personal/john',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:20:09:000PM','192.168.1.109','User5','GET','/MySite/default.aspx',NULL,302)
INSERT INTO [logs] VALUES('Mar 31 2009 2:20:09:000PM','192.168.1.109','User5','GET','/personal/john/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:20:09:000PM','192.168.1.109','User5','POST','/personal/john/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:20:09:000PM','192.168.1.109','User5','POST','/personal/john/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:02:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:20:20:000PM','192.168.1.109','User5','GET','/SearchCenter/Pages/Results.aspx','k=author%3A%22SV%2DBIC%2D0001%5Cjohn%22',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:20:20:000PM','192.168.1.109','User5','GET','/_layouts/images/bell.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:20:20:000PM','192.168.1.109','User5','GET','/_layouts/images/STS_List16.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:20:20:000PM','192.168.1.109','User5','GET','/_layouts/images/STS_Web16.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:20:36:000PM','192.168.1.109','User5','POST','/SearchCenter/Pages/Results.aspx','k=author%3A%22SV%2DBIC%2D0001%5Cjohn%22&start1=21',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:20:36:000PM','192.168.1.109','User5','GET','/_layouts/images/STS_ListItem16.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:20:36:000PM','192.168.1.109','User5','GET','/_layouts/images/html16.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:20:40:000PM','192.168.1.109','User5','POST','/SearchCenter/_vti_bin/search.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:25:000PM','192.168.1.120','User1','POST','/compsite/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:25:000PM','192.168.1.120','User1','POST','/compsite/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:20:40:000PM','192.168.1.109','User5','POST','/SearchCenter/_vti_bin/search.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:20:40:000PM','192.168.1.109','User5','GET','/SiteCollectionImages/Forms/DispForm.aspx','ID=1',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:20:40:000PM','192.168.1.109','User5','GET','/_layouts/images/manageCopies.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:20:40:000PM','192.168.1.109','User5','GET','/_layouts/images/checkout.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:20:40:000PM','192.168.1.109','User5','GET','/_layouts/images/versions.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:20:40:000PM','192.168.1.109','User5','GET','/_layouts/images/workflows.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:20:40:000PM','192.168.1.109','User5','GET','/_layouts/AssetUploader.aspx','Size=Small&ImageUrl=%2fSiteCollectionImages%2fBankLoan%2ejpg',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:20:44:000PM','192.168.1.109','User5','GET','/compSite/Wiki+Pages/Home.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:20:52:000PM','192.168.1.109','User5','GET','/compSite/Wiki+Pages/Forms/EditForm.aspx','ID=1',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:21:33:000PM','192.168.1.109','User5','GET','/compSite/Wiki+Pages/Forms/AllPages.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:21:37:000PM','192.168.1.109','User5','GET','/_layouts/images/MenuNewItem.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:02:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:21:42:000PM','192.168.1.109','User5','GET','/compSite/_layouts/CreateWebPage.aspx','List=%7BFEF7F74F%2DA240%2D4BFE%2DB7FB%2DAD99BE01C481%7D&RootFolderUrl=%2FBICSite%2FWiki%20Pages',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:21:48:000PM','192.168.1.109','User5','GET','/compSite/_layouts/zoombldr.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:22:04:000PM','192.168.1.109','User5','GET','/compSite/_layouts/zoombldr.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:22:20:000PM','192.168.1.109','User5','POST','/compSite/_layouts/CreateWebPage.aspx','List=%7bFEF7F74F-A240-4BFE-B7FB-AD99BE01C481%7d&RootFolderUrl=%2fBICSite%2fWiki+Pages',302)
INSERT INTO [logs] VALUES('Mar 31 2009 2:22:20:000PM','192.168.1.109','User5','GET','/compSite/Wiki+Pages/Report.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:22:34:000PM','192.168.1.109','User5','GET','/compSite/Wiki+Pages/Forms/AllPages.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:22:42:000PM','192.168.1.109','User5','GET','/compSite/Wiki+Pages/How+To+Use+This+Wiki+Site.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:22:48:000PM','192.168.1.109','User5','GET','/compSite/Wiki+Pages/Home.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:02:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:02:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:03:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:05:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:23:20:000PM','192.168.1.109','User5','GET','/compSite/Wiki+Pages/Report.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:25:16:000PM','192.168.1.109','User5','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:25:16:000PM','192.168.1.109','User5','GET','/PublishingImages/newsarticleimage.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:25:33:000PM','192.168.1.109','User5','GET','/Docs',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:25:33:000PM','192.168.1.109','User5','GET','/Docs/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:25:35:000PM','192.168.1.109','User5','GET','/Docs/Documents',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:25:35:000PM','192.168.1.109','User5','GET','/Docs/Documents/Forms/AllItems.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:25:38:000PM','192.168.1.109','User5','GET','/_layouts/images/MenuUploadDocument.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:25:38:000PM','192.168.1.109','User5','GET','/Docs/_layouts/Upload.aspx','List=%7B9F7C575E%2D5236%2D47F1%2DA014%2D6FA210C5F5DF%7D&RootFolder=%2FDocs%2FDocuments&Source=http%3A%2F%2Fsv%2Dbic%2D0001%2FDocs%2FDocuments%2FForms%2FAllItems%2Easpx',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:10:000PM','192.168.1.120','User1','POST','/compsite/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:25:56:000PM','192.168.1.109','User5','POST','/Docs/_layouts/Upload.aspx','List=%7b9F7C575E-5236-47F1-A014-6FA210C5F5DF%7d&RootFolder=%2fDocs%2fDocuments&Source=http%3a%2f%2fcomp%2fDocs%2fDocuments%2fForms%2fAllItems.aspx',302)
INSERT INTO [logs] VALUES('Mar 31 2009 2:25:56:000PM','192.168.1.109','User5','GET','/Docs/Documents/Forms/EditForm.aspx','Mode=Upload&CheckInComment=GIF%20picture&ID=4&RootFolder=%2FDocs%2FDocuments&Source=http%3A%2F%2Fsv%2Dbic%2D0001%2FDocs%2FDocuments%2FForms%2FAllItems%2Easpx',200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:25:56:000PM','192.168.1.109','User5','GET','/_layouts/images/exclaim.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:08:000PM','192.168.1.109','User5','POST','/Docs/Documents/Forms/EditForm.aspx','Mode=Upload&CheckInComment=GIF+picture&ID=4&RootFolder=%2fDocs%2fDocuments&Source=http%3a%2f%2fcomp%2fDocs%2fDocuments%2fForms%2fAllItems.aspx',302)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:08:000PM','192.168.1.109','User5','GET','/Docs/Documents/Forms/AllItems.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:08:000PM','192.168.1.109','User5','GET','/_layouts/images/icgif.gif',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:12:000PM','192.168.1.109','User5','GET','/Docs/Documents/Sunset.GIF',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:25:000PM','192.168.1.120','User1','GET','/compsite/Wiki+Pages/Forms/RecentChanges.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:32:000PM','192.168.1.109','User5','GET','/Docs/Documents/logo.bmp',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:36:000PM','192.168.1.109','User5','GET','/Docs/Documents/Tally+Settings+General.odt',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 2:26:36:000PM','192.168.1.109','User5','GET','/Docs/Documents/Tally+Settings+General.odt',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:11:38:000PM','192.168.1.109','User5','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:11:38:000PM','192.168.1.109','User5','GET','/PublishingImages/newsarticleimage.jpg',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:28:41:000PM','192.168.1.109','User5','GET','/SearchCenter/Pages/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:29:22:000PM','192.168.1.109','User5','GET','/Docs',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:29:22:000PM','192.168.1.109','User5','GET','/Docs/default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:45:58:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 3:45:58:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:06:01:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:06:01:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:06:01:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:06:01:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:06:01:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:25:58:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:25:58:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:25:58:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:25:58:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:26:00:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:26:00:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:26:00:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:26:00:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:45:59:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:45:59:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:46:09:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:46:09:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:46:09:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:46:09:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:46:11:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 4:46:11:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:05:59:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:05:59:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:05:59:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:05:59:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:05:59:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:05:59:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:06:04:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:06:04:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:26:00:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:26:00:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:26:00:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:26:00:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:26:01:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:26:05:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:26:06:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:26:06:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:26:06:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:45:39:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:45:39:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:45:39:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:45:41:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:45:41:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:45:41:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:45:46:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 5:46:09:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:05:17:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:05:17:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:05:17:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:05:17:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:05:17:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:05:17:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:05:17:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:05:17:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:25:24:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:25:24:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:25:24:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:25:24:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:25:24:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:25:24:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:25:47:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:25:47:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:45:16:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:45:16:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:45:16:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:45:16:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:45:16:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:45:16:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:45:16:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 6:45:16:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:05:16:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:05:16:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:05:16:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:05:16:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:05:16:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:05:16:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:05:16:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:05:16:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:25:16:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:25:16:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:25:16:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:25:16:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:25:16:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:25:16:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:25:16:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:25:16:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:45:17:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:45:17:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:45:28:000PM','192.168.1.120','User1','GET','/',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:45:28:000PM','192.168.1.120','User1','GET','/Pages/Default.aspx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:45:28:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:45:46:000PM','192.168.1.120','User1','POST','/_vti_bin/spscrawl.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:45:52:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
INSERT INTO [logs] VALUES('Mar 31 2009 7:46:10:000PM','192.168.1.120','User1','POST','/_vti_bin/sitedata.asmx',NULL,200)
[/code]
Go to Top of Page

Shivs
Starting Member

9 Posts
Posted - 2009-04-21 : 08:50:59
And here is the outout

CsUername | Cip | StartTime | Endtime

User2 | 192.168.1.109 | 03/31/09 01:56 PM | 03/31/09 02:08 PM
User3 | 192.168.1.111 | 03/31/09 09:50 AM | 03/31/09 09:51 AM
User3 | 192.168.1.111 | 03/31/09 02:05 PM | 03/31/09 02:06 PM
User4 | 192.168.1.120 | 03/31/09 10:37 AM | 03/31/09 10:37 AM
User5 | 192.168.1.109 | 03/31/09 10:06 AM | 03/31/09 10:43 AM
User5 | 193.168.1.109 | 03/31/09 01:12 PM | 03/31/09 01:15 PM
User5 | 194.168.1.109 | 03/31/09 01:59 PM | 03/31/09 02:08 PM
User5 | 194.168.1.109 | 03/31/09 02:08 PM | 03/31/09 03:29 PM
Go to Top of Page

Shivs
Starting Member

9 Posts
Posted - 2009-04-24 : 01:21:05
bump
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site