Re: How/Where do I check the most frequently used Search words?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Hi David , From my experience one way to get good info on search results and
queries is indeed to use the IIS logs from the web front end server ,
getting a decent Log viewer tool can be useful :
http://www.iisfaq.com/Default.aspx?tabid=2550
Or getting the logs into SQL using log parser for example.
http://www.microsoft.com/technet/scriptcenter/tools/logparser/default.mspx
Once the info is in QL you can use any decent query and filter tool such as
Crystal reports or SQL reporting services.

I do not recommend you try and extract the IIS logs straight into a SQL
dbase from the WFE server , this will actually have a performance hit on the
server. Get the IIS logs created on the WFE server and then use Log Parser
to get them into SQL.

Cheers for Now

Steve Smith

UK Sharepoint Training
http://www.combined-knowledge.com/sharepoint_knowledge_tracks.htm


<davidg@xxxxxxxxxxxx> wrote in message
news:1118679037.819709.125980@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>I want to see what the most popular used search terms are on the portal
> (and least used)... where/how do I do this?
>
> I have seen some threads that talk about looking at the IIS default web
> site logs, but I have no idea on how to read this beast of a file
> (200mg+). I am in the process of trying to improve the information
> architecture and usability of the portal.
>
> Any advice out there from the peanut gallery?
>
> Thanks.
>
> David Goebel
>


.



Relevant Pages

  • Re: Hacking attempts?
    ... Windows logs logon type 3 in most cases when you access a computer from elsewhere on the network. ... One of the most common sources of logon events with logon type 3 is connections to shared folders or printers. ... You can use the IIS logs to track down the ip addressthat are attempting unauthorized login. ...
    (microsoft.public.windows.server.sbs)
  • Selecting rows from a distinct selection of one field
    ... I'm not that new to SQL, but still I can't figure this out. ... I'm writing some routines to check through IIS logs. ... After batch importing the logs I end up with 16 fields. ...
    (microsoft.public.sqlserver.programming)
  • Re: hack attempts howto find ip
    ... IP logging is not offered until Windows XP with ICF firewall ... logs if you have, say, an FTP or NetBIOS attack. ... show up in the IIS logs. ...
    (microsoft.public.inetserver.iis.security)
  • Re: Out of Office Not working - BUG???
    ... This shows up in my IIS Logs: ... ConfigExceptionInfo ... ErrorCode The operation completed successfully. ...
    (microsoft.public.exchange.setup)
  • Out of Office Not working - BUG???
    ... This shows up in my IIS Logs: ... ConfigExceptionInfo ... ErrorCode The operation completed successfully. ...
    (microsoft.public.exchange.setup)