Current User List

Classic Servoy
1

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.

2

Why not just look at the code underlying the page you want to emulate?

3

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.

4

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.

5

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)

6

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.

7

You can also just create your tracking table - and keep track of whatever information you want… might be simpler…

8

Or read(only!) from the servoy_user_stats table, if a servoy client start it logs all kind of info there for ASP solutions

9

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

10

It’s ment to be an internal table, but you can read from it with getDataSetByQuery

11

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