Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Web CMS (TeamSite)
reporting on concurrent usage?
smm
Has anyone figured out a way to get stats on concurrent usage? I know that you can see the number of concurrent users at any given time via Enterprise Manager, but is there a way to see the highest number of concurrent users ever reached? We're using 4.6.1.
Find more posts tagged with
Comments
Migrateduser
I don't have an answer for that but, I would like to know it too.
Also, is there a way to programmatically identify the concurrent users?
lyman
If you enable Net.log it reports all connections and disconnections. A script could parse the file to keep track.
Cheers,
Lyman Hurd
Migrateduser
There is a MediaBin report view (ReportUserLogins) which contains the times which users have logged into the server. This would be a much easier method to obtain the information.
Beth Smith
__________________
MediaBin Server Team
Interwoven, Inc.
Migrateduser
Here's a query to determine for each user login how many concurrent logins happened at the same time:
select a.user_name,
a.login_start,
a.login_end,
(select count(*) from ReportUserLogins b
where NOT (a.login_start > b.login_end
OR a.login_end < b.login_start))
from ReportUserLogins a
order by a.login_start
As this involved joins into a view, it may take awhile to generate the results.