In the same place you can go under licensing; right click on your active license then properties. You can see how many in use and available at any give time. Also limit your users to Allow one session
I am using Visual Cut to run a Crystal Report that exports the active users to an Access Database.
Active users are captured every 15 minutes.
Then I have another Crystal Report that I used to analyze usage over a period of time.
JOE ROJAS
Epicor Applications Manager
VENTION MEDICAL + DESIGN & DEVELOPMENT
DIRECT: 508.597.1392 x1625 | MOBILE: 774.826.9245
And I always go into detail (and add picts) when explaining things. It’s not meant to imply you (or whomever I communication with) need hand holding. It’s just to reduce potential miscommunication.
I appreciate that but I thought he was referring to Epicor Admin Console. I didn’t think queries can be run in the Epicor Administration Console and that’s why I asked. I had already checked all tables in SQL and didn’t find it.
Michel, do you have REST enabled? If you don’t have rest, try to query SELECT * from ice.sessionstate. The rest call gives more info. I don’t know what table they join to sessionstate to get that info though.
If you run that and save output as json file you can connect to it from excel and use the query editor to expand it into tables. I think the result set is a list of sessions I just don’t know the time period it looks at.
I tried to log the system DB hits and the SQL queries when I was in the admin console refreshing those views but I couldn’t make anything of the queries to help you out.