BusinessObjects Board

Concurrent user count past Month

I was able to figure out how to get this through query builder using:

Select count(si_id) from CI_SystemObjects where si_kind = ‘Connection’ and si_failover_available_until = NULL and si_authen_method != ‘server-token’

But this only provides present moment statistics and I need historical usage for the entire month. Our server is hosted by a third party so we do have access to some audit tables for 4.2 SP9. Anyone know a query to run to obtain this information?

This is the base SQL from the query that I use to get user counts. I have some other things in it where I’ve customized the audit universe, but this should help you get the basics. You will need to add filters for the dates you are looking for. This does not differentiate between Concurrent Users and Named Users.

SELECT
Count(dbo.ADS_EVENT.User_Name),
Count(Distinct dbo.ADS_EVENT.User_Name),
dbo.ADS_EVENT.StartTime,
dbo.ADS_CLUSTER_STR.Cluster_Name
FROM
dbo.ADS_EVENT
INNER JOIN dbo.ADS_CLUSTER ON (dbo.ADS_EVENT.Cluster_ID=dbo.ADS_CLUSTER.Cluster_ID)
INNER JOIN dbo.ADS_CLUSTER_STR ON (dbo.ADS_CLUSTER.Cluster_ID=dbo.ADS_CLUSTER_STR.Cluster_ID
And dbo.ADS_CLUSTER_STR.Language = ‘EN’)
WHERE
(
dbo.ADS_EVENT.Event_Type_ID = 1014
AND
dbo.ADS_EVENT.Status_ID <> 1
)
GROUP BY
dbo.ADS_CLUSTER_STR.Cluster_Name