# Current User List **URL:** \ **Category:** Classic Servoy\ **Created:** [July 14, 2006, 5:21pm UTC](https://forum.servoy.com/t/current-user-list/6234 "2006-07-14T17:21:08Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![rarbuthnot](https://avatars.discourse-cdn.com/v4/letter/r/e9a140/32.png) [@rarbuthnot](https://forum.servoy.com/u/rarbuthnot)\ **Post date:** [July 14, 2006, 5:21pm UTC](https://forum.servoy.com/t/current-user-list/6234/1 "2006-07-14T17:21:08Z")
Hi, I’d like to get a list of all the currently connected users to display on our admin page. I know how to get the client count, but how do I get more information than that? Information similar to the client list in the server admin web pages would be ideal. Thanks. ---
**Author:** ![bcusick](https://avatars.discourse-cdn.com/v4/letter/b/ed8c4c/32.png) [@bcusick](https://forum.servoy.com/u/bcusick)\ **Post date:** [July 17, 2006, 5:50pm UTC](https://forum.servoy.com/t/current-user-list/6234/2 "2006-07-17T17:50:29Z")
Why not just look at the code underlying the page you want to emulate? ---
**Author:** ![rarbuthnot](https://avatars.discourse-cdn.com/v4/letter/r/e9a140/32.png) [@rarbuthnot](https://forum.servoy.com/u/rarbuthnot)\ **Post date:** [July 17, 2006, 6:31pm UTC](https://forum.servoy.com/t/current-user-list/6234/3 "2006-07-17T18:31:49Z")
Hi Bob, Can you tell me where that page might be located on the server and how I could read it so I can emulate it? Thanks. ---
**Author:** ![rarbuthnot](https://avatars.discourse-cdn.com/v4/letter/r/e9a140/32.png) [@rarbuthnot](https://forum.servoy.com/u/rarbuthnot)\ **Post date:** [July 20, 2006, 7:51pm UTC](https://forum.servoy.com/t/current-user-list/6234/4 "2006-07-20T19:51:32Z")
The page in the Servoy Admin web pages is built using compiled Java code. Therefore, I cannot read it. I’ve discoved some tables in the servoy repository that have some relevant information, but it is difficult to interpret. Any information on how to find out which clients are connected, when they connected, how long they have been idle, who is using them, etc. would be greatly appreciated. Thank you. ---
**Author:** ![Jan\_Blok](https://avatars.discourse-cdn.com/v4/letter/j/41988e/32.png) [@Jan\_Blok](https://forum.servoy.com/u/Jan_Blok)\ **Post date:** [July 21, 2006, 8:17am UTC](https://forum.servoy.com/t/current-user-list/6234/5 "2006-07-21T08:17:27Z")
> rarbuthnot: > Hi, > > I’d like to get a list of all the currently connected users to display on our admin page. You can use an inner frame on your admin page showing content from the servoy admin page (just copy the url to the iframe) ---
**Author:** ![rarbuthnot](https://avatars.discourse-cdn.com/v4/letter/r/e9a140/32.png) [@rarbuthnot](https://forum.servoy.com/u/rarbuthnot)\ **Post date:** [July 21, 2006, 1:37pm UTC](https://forum.servoy.com/t/current-user-list/6234/6 "2006-07-21T13:37:31Z")
> Jan Blok: > You can use an inner frame on your admin page showing content from the servoy admin page (just copy the url to the iframe) Thanks for the response Jan. What you’ve suggested is similar to what we are doing now: a button that just opens that page. But there is more info that we would like to show. For example, who has logged in today? The list only shows who is currently logged in. I know the info is in the database… One strange thing is that there is data in the servoy\_client\_stats table which has a client\_id column. This column could link you to the servoy\_clients table which could then link you to the servoy\_users table, but the servoy\_clients table is always empty!?! Yet, the web page is able to show this information. I don’t know what the big secret is. ---
**Author:** ![bcusick](https://avatars.discourse-cdn.com/v4/letter/b/ed8c4c/32.png) [@bcusick](https://forum.servoy.com/u/bcusick)\ **Post date:** [July 21, 2006, 2:39pm UTC](https://forum.servoy.com/t/current-user-list/6234/7 "2006-07-21T14:39:05Z")
You can also just create your tracking table - and keep track of whatever information you want… might be simpler… ---
**Author:** ![Jan\_Blok](https://avatars.discourse-cdn.com/v4/letter/j/41988e/32.png) [@Jan\_Blok](https://forum.servoy.com/u/Jan_Blok)\ **Post date:** [July 21, 2006, 3:30pm UTC](https://forum.servoy.com/t/current-user-list/6234/8 "2006-07-21T15:30:23Z")
Or read(only!) from the servoy\_user\_stats table, if a servoy client start it logs all kind of info there for ASP solutions ---
**Author:** ![Westy](https://avatars.discourse-cdn.com/v4/letter/w/9de053/32.png) [@Westy](https://forum.servoy.com/u/Westy)\ **Post date:** [November 16, 2006, 7:17pm UTC](https://forum.servoy.com/t/current-user-list/6234/9 "2006-11-16T19:17:09Z")
> Jan Blok: > Or read(only!) from the servoy\_user\_stats table, if a servoy client start it logs all kind of info there for ASP solutions Is this referring to the “servoy\_clients\_stats” table in the servoy\_repository? If so, how can this be accessed from within Servoy? I do not see anything about this in the documentation. Dean ---
**Author:** ![Jan\_Blok](https://avatars.discourse-cdn.com/v4/letter/j/41988e/32.png) [@Jan\_Blok](https://forum.servoy.com/u/Jan_Blok)\ **Post date:** [November 16, 2006, 8:07pm UTC](https://forum.servoy.com/t/current-user-list/6234/10 "2006-11-16T20:07:30Z")
It’s ment to be an internal table, but you can read from it with getDataSetByQuery ---
**Author:** ![pbakker](https://avatars.discourse-cdn.com/v4/letter/p/a4c791/32.png) [@pbakker](https://forum.servoy.com/u/pbakker)\ **Post date:** [November 17, 2006, 7:58am UTC](https://forum.servoy.com/t/current-user-list/6234/11 "2006-11-17T07:58:11Z")
If you would like to base a form on this table, you could create a view in your Database. As of Servoy 3.0, you can base forms on views as well. Paul