Thread: Exclude IP From Summary

We were looking at the order reports, the summary. However it includes our actions. So when we process orders or add items to the basket for price inquiries. This throws off our stats.

Is there anyway we can exclude our IP from the recording?

Thanks in advance.

You'll have to modify the sql in the orders.aspx.cs file. Find the summary sql that executes when the summary radio button is checked and add

Code:

and LastIPAddress <> 'xxx.xxx.xxx.xxx'

to it, where xxx.xxx.xxx.xxx is the IP address you want to filter out.

I have added this code to
rpt_stats.aspx.cs
for all of the queries (7 of them)

C#/VB.NET Code:

int NumCustomers = DB.GetSqlN("select count(CustomerID) as N from customer   with (NOLOCK)  where " + WhereClause.Replace("OrderDate", "CreatedOn") + CommonLogic.IIF(AffiliateID.Length != 0, " and affiliateid=" + AffiliateID + " and LastIPAddress <> '81.134.8.182'", "")); 


however I have had no luck it does not exclude our IP (81.134.8.182) I have tried the query in SQL and it works any ideas?

Thanks in advance.

That was meant for the orders.aspx.cs file (as mentioned in the post) for summary reports ran from the orders page. Which admin menu item are you running the reports from so I can tell you which files/queries you need to change?

It is the order > reports > summary stats.
Where you see the statistics.

I have ran the code in sql and it worked fine.