Query connected users

[Segi]

I want to run a query against the UFS DB to get the IP address of connected users (The same info available under Help->View Connected Users)

I went to create a resource against the UFS connection but am not sure which table under the UFS schema to reference).

Where would I find this ?

[Jon]

We don't store this information in the database so I'm afraid there isn't a table that you can query. You can get the IP address of the current session using:

Code: Select all

var ipAddress = client.request.remoteAddr;

Perhaps you could use this to construct your own table, but you would also need to intercept the end of each session to remove completed sessions.

[Segi]

So when I go to View Connected Users, where is this information pulled from ?

[Jon]

It's held in memory - the licensing module within the Ebase server is responsible for this.