Hi,

Is there any easy way to see what people have searched for on a website using the DNN search tool built into the framework? Is there a module you can buy which does this?

Cheers

MARK.

Login as Host or Superuser and go to Host/SQL.  Copy the following SQL code from SQL Code Section 1 into the SQL screen and then click Execute (leave Run as Script unchecked).  There should be no error message from this step.  Copy and execute SQL Code Section 2.  There should be no error message from this operation.

SQL Code Section 1:

if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}GetSiteLog88') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}GetSiteLog88


SQL Code Section 2:

create procedure {databaseOwner}{objectQualifier}GetSiteLog88

@PortalId int,
@PortalAlias nvarchar(50),
@StartDate datetime,
@EndDate datetime

as

SELECT     sl.DateTime, --Portals.PortalName,
                u.Username, sl.UserHostAddress,
                sl.Referrer, SUBSTRING(sl.Url, PATINDEX('%Search=%', sl.Url),
                      LEN(RTRIM(sl.Url)) - PATINDEX('%Search=%', sl.Url)+1) AS SearchString
FROM         {objectQualifier}SiteLog sl INNER JOIN
                     {objectQualifier}Portals p ON sl.PortalId = p.PortalID LEFT JOIN
                     {objectQualifier}Users u ON sl.UserId = u.UserID
WHERE    
sl.PortalId = @PortalId
and sl.DateTime between @StartDate and @EndDate
and (sl.Url LIKE '%search=%')
ORDER BY sl.DateTime DESC

 

The following procedure will register the newly created stored procedure from step 1 as a new DNN Site Log Report.

    * Go to Host/Lists
    * Select Site Log Reports
    * Click Add Entry
    * Enter Entry Text as "Search History"
    * Enter Entry Value as "88"
    * Click Save

At this point the DNN Search Report has been installed and is ready to use.  To view the search history for a given portal:

    * Login as admin or host
    * Go to Admin/Site Log

On the Site Log page, if you see the following message:
    Your Hosting Provider Has Disabled the Site Log History Feature For Your Portal.

You must first enable the Site Log History for this portal.

    * Login as host
    * Go to Admin/Site Settings
    * Expand Advanced Settings section
    * Expand Host Settings section
    * In Site Log History (Days), enter a number (60 for example)
    * Click Update

Go back to Admin/Site Log and you should see the following message:
    Your Hosting Provider Has Limited Your Portal To 60 Days Of Site Log History.

    * In the Report Type dropdown box, select Search Report
    * Select the Start and End dates
    * Click Display

You should now be viewing the history of searches during the selected period.  If you've just enabled Site Log History, you can expect the history to be blank.

 

Hi Eck Two, Thanks for the input. This looks good.

I have carried out all steps and activited my site log and set to 7 days but when I go into site log under Admin, I get :

Your Hosting Provider Has Disabled the Site Log Viewer Feature For Your Portal. The Logs can be viewed offline and are available in the \Logs\ subfolder of your Portal's Home Directory.

Is there another step I need or could this just be the website is still caching an old value before I entered the 7 for days history?

Thanks in advance

Regards

MARK.