Custom report for unique visits RRS feed

  • Question

  • User1921168890 posted

    Is  it possible to create a custom report that displays information like the Site Traffic report, but counts unique visits instead of total visits?

    Monday, January 12, 2009 1:18 PM

All replies

  • User295225836 posted

    Can you elaborate on this? Unique visits based on the users?

    Is it not similar to what Report "Users Accessed" does?


    Monday, January 12, 2009 2:46 PM
  • User1921168890 posted

    I don't think so, because Users Accessed reports the same numbers that the Site Traffic reports for my website; and i'm pretty sure that Site Traffic is purely hits, and i know that i have visited the site multiple times a couple days to make sure that i haven't broken it with the changes i've made.

    The report i have in mind is a count of the distinct client IP address from the IIS logs for each date in the specified range. There would only be 2 columns of data produced by the report, one for the date, one for a count of the unique IP address that accessed the web site that date.

    Monday, January 12, 2009 4:49 PM
  • User295225836 posted

    There is an article present on how to build your custom report at


    It makes use of the Logparser for processing of the files. You can write your custom query as

    logparser "Select top 25 c-ip as IP_Address,count(*) from 'C:\inetpub\logs\LogFiles\W3SVC1\u_ex*.log' where date=TO_TIMESTAMP('2007-07-27','yyyy-MM-dd') group by c-ip order by c-ip"

    Let me know if it helps.




    Wednesday, January 14, 2009 1:34 PM