I am running the following query on the QSP_Repository Table
SELECT QSPSUsersTrends.TrendTime, QSPSUsersTrends.ID, QSPSUsersTrends.UserCount, QSPSUsersTrends.FlagID, QSPSWebs.FullUrl as [Sub Site], QSPSWebs.Title as [Sub Site Title], QSPSSites.FullUrl AS [Site Collection], QSPSVirtualServers.Name As [Web Application]FROMQSPSUsersTrends LEFT OUTER JOIN QSPSWebs ON QSPSUsersTrends.ID = QSPSWebs.ID LEFT OUTER JOIN QSPSVirtualServers ON QSPSUsersTrends.ID = QSPSVirtualServers.ID LEFT OUTER JOINQSPSSites ON QSPSUsersTrends.ID = QSPSSites.IDWhere FlagID = 'VirtualServerID' and TrendTime > '2009-08-13 06:38:36.240' ORDER BY [Web Application] Desc , TrendTime Desc
I am trying to understand where the user count is being pulled from; from the results below you can see that every min apart the user count is changing..Is this because I have multiple front ends?
This is the bug of Site Admin 3.5 and previous versions (for web app with more than one database). You need to upgrade to 3.5.1.User count trend looked like a saw before this fix.
Hi Grigory,
Does upgrade to 3.5.1 require re-gathering of all the data?
Regards, Mike
Yes.
The issue was in the collector. Unfortunately all previous user count trends aren't correct. The new trends will be accurate. You may remove old trends (manually) to get clear report.
I am on the Quest Support Site; Under Downloads and Updates, I cannot see this 3.5.1 to download. If this release available yet or do I need to request for it?
I've started to upload the build to ftp://QuestPreview:PreviewQuest1@ftp.quest.com/SA
Will be uploaded in 1-1.5 hour.
It's available now.
I've deleted all rows from the QSPUsersTrends
Rerun the Gatherer QSPSCollector Util and still find that with the report User Count Trend displays incorrectly. Your right about the fact that I have more than one contentdatabase atttached to the web application, most of my web applications are configured with multiple content databases.
So what did you change in 3.5.1 because I still see the following
See how WebApp4 appears 4 times. there are 4 content databases mapped to this in central admin
Ok I reran the Collector again and noticed something new; the count is now a sum of where web applications have multiple contentdatabases...
I will be using other tools and check with MSDN as well. This User Count is really object in the contentdatabase table; it is indicative of how many users may possibley part of a site collection; I noticed this filters users that have been deleted from the site collection.
Great work.. I will press on my work with developing some custom reports for our management teams
To be 100% accurate - we don't just sum users - we merge equal and then sum. We also skip groups and deleted.
We count number of unique users across all content databases of a web application