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.
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’)
dbo.ADS_EVENT.Event_Type_ID = 1014
dbo.ADS_EVENT.Status_ID <> 1