reporting on concurrent usage?

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. Smiley Wink

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.