Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Using Modules a...Using Modules a...Dispay the Number of user who visited my website?Dispay the Number of user who visited my website?
Previous
 
Next
New Post
2/1/2011 11:11 AM
 
Hello,
How can i Dispay the Number of user   WHO VISITED    my website (in the first time) ?
AND
Number of user / BY COUNTRY WHO VISITED  my website (in second time) ???

Does anyone can give me an idea ?
please

divide reign
 
New Post
2/1/2011 2:11 PM
 

If you are just interested in a report, there are some limited report available under the Admin menu - Site Log.

Alternatively, you can use the report module (or similar)  to report this information.   You will need to create the appropriate SQL query to match your requirement.   You will need to determine the what a "user" is and what a "visit" is ...  I use

select
 convert(varchar,DateTime,102) as [Date],
 count(SiteLogID) as [Views],
 count(distinct dbo.SiteLog.UserHostAddress) as [Visitors]
from dbo.SiteLog
where
  PortalId = [DNN:portalID]
  and dbo.SiteLog.DateTime
    between convert(varchar, dateadd(d, -29, getdate()), 102)
        and convert(varchar, dateadd(d, -1, getdate()), 102) + ' 23:59'
group by convert(varchar,DateTime,102)
order by Date desc

The above select return a list of dates with the number of users and Views.  I graph the results  - see here 

I consider for this report -- a user is a unique ip address, and a view as a page request.

Hope this helps
Paul.

 
New Post
2/2/2011 1:47 PM
 
Hello,
Thank you Mister Paul for your reply,
Yes, it s helps me
But i m not  yet  reached the goal, My realy task is : to display in the website something like:
* Visitors:

-USA:7
-France:3
-Italy:5

ect.

Mister Paul , i want to try your Select in my web site , but i don t know how ?
I went to Host/ SQL , and i put all the Select code but it didn t display a graphic (as the link you sent me)
Should i modify : [DNN:portalID]  by something ? or ?

Help pls.

divide reign
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Using Modules a...Using Modules a...Dispay the Number of user who visited my website?Dispay the Number of user who visited my website?


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out