none
Report on searches performed by user (not just search terms) RRS feed

  • Question

  •  

    Hi Guys,

     

    Hoping someone can help me.  We are using Search Server Express and I need to be able to report on who has issued a search (not just the search term used as is standard), are there any report packs available for search server express, or any logging which can be switched on?

     

    I'm hoping there is a standard way to mine this data but if not, anyone know of any 3rd party reports or products which will show this?

     

    TIA

    Thursday, May 15, 2008 8:57 AM

Answers

  • You need to look at a number of things. In addition to the database, some of the usage information is stored here by default:

     

    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Logs

     

    You can also check the IIS Logs at

     

    c:\windows\system32\logfiles\w3svcXXXXX

     

    Naturally, each log location uses a different format, so reconciliation is non-trivial.

    Thursday, May 15, 2008 8:20 PM
  • Hi,

     

    Update for this issue; the IIS logs have all the info I need (see sample below).  I still cannot believe this is not a standard reporting metric from within the product though.  I now have to decode and write a management report from these log files.

     

    Woody, thanks for the info!

    --

     

     

    #Software: Microsoft Internet Information Services 6.0
    #Version: 1.0
    #Date: 2008-05-16 09:36:30
    #Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status

     

    <SNIP>

     

    2008-05-16 09:37:14 W3SVC1739915750 10.0.0.10 GET /results.aspx k=Led%20Zeppelin 80 DOMAIN\MyUser 10.0.0.10 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506.30;+.NET+CLR+3.0.04506.648) 200 0 0

     

    <SNIP>

    Friday, May 16, 2008 10:20 AM

All replies

  •  

    Forgot to mention, am happy to write my own report if anyone can heads up where int he DB this stuff is stored.  Ha da poke about and can see some tables with useful looking stuff, but nothing tying a search back to a user account or similar.

     

    Any ideas??

    Thursday, May 15, 2008 9:04 AM
  • You need to look at a number of things. In addition to the database, some of the usage information is stored here by default:

     

    C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Logs

     

    You can also check the IIS Logs at

     

    c:\windows\system32\logfiles\w3svcXXXXX

     

    Naturally, each log location uses a different format, so reconciliation is non-trivial.

    Thursday, May 15, 2008 8:20 PM
  • Thanks Woody.

     

    Any pointers to which tables in the DB?

     

    I'm quite surprised this is not a standard reporting item from within SS, seems like a fairly standard thing to want to know without having to jump through hoops?!??

     

    Friday, May 16, 2008 9:32 AM
  • Hi,

     

    Update for this issue; the IIS logs have all the info I need (see sample below).  I still cannot believe this is not a standard reporting metric from within the product though.  I now have to decode and write a management report from these log files.

     

    Woody, thanks for the info!

    --

     

     

    #Software: Microsoft Internet Information Services 6.0
    #Version: 1.0
    #Date: 2008-05-16 09:36:30
    #Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status

     

    <SNIP>

     

    2008-05-16 09:37:14 W3SVC1739915750 10.0.0.10 GET /results.aspx k=Led%20Zeppelin 80 DOMAIN\MyUser 10.0.0.10 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506.30;+.NET+CLR+3.0.04506.648) 200 0 0

     

    <SNIP>

    Friday, May 16, 2008 10:20 AM