Hi We currently are looking at the site usage report on one of our SharePoint sites. The site uses forms based authentication. When we look at the report based on users, some users are shown twice. Once as the ldapmembershippprovider user and another with just with the windows login. For example you in the report you may see: 1)ldapmembershipprovider:tshaw 1000 hits and 2)tshaw 500 hits both users have different hit counts even though they are the same user. Any thoughts to why this is happening? Thanks

Berket, SP site usage report related info stores in corresponding SSP Database, since you activated Report Analysis feature. Please check query following Tables in SSP Database for specific users so that you looking for. AnlDay - Table that stores each day and its ID. AnlUser - Table that stores users. AnlHits - Table that stores User, Web, Site, Page, Day level info. You need to make a equi join with above three tables. So that you will know what date, what hit append by which user. Also in same SSP database there are couple of Views are there related to Usage Reports. You can have quick look those for any other hints. Hope this helps. /best regards

Hi LAX-K Thanks for the reply. The issue this data is required by some users who are in customer service. I really do not want to give them access to the database. It's much easier for them to click on site usage report which does a really good job of displaying the stats for the site. But the questions revolves around why a user is showing up twice. Here is a sample output from the user stats: esildapmembershipprovider:temarchese 13 4 6/1/2010 4 esildapmembershipprovider:v29 1 1 6/1/2010 1 esildapmembershipprovider:v81 6 6 5/25/2010 2 v81 26 26 5/25/2010 13 As you can see user v81 shows up twice with different stats and the “most recent date” is also different. This is the part we need clarification on. Why users are shown twice?

Berket, Got your point, my above comments are for troubleshooting purpose for you so you can explain end users. You can see each user hit day, login credentials and page. With data that you provided looks lime some authentication type changes (domain, sso) not sure. Hope it makes sense. /best regards

Do you know how can I get it in MOSS2010? In 2010 we don't have SSP DB, I am wondering which tables I have to join in 2010. Thank you