> -----Original Message-----
> Looking for a way to get a list of all users currently using
> a given database at each location (over 200 sites). Prefer
> to do it programmatically so we can provide a "management
> report" without having to give access to non-dba guys. Would
> like to get as much info about each user (IP address, etc.)
> if possible.

On your superserver installations you could use TIBStatisticalService, which
should give you the number of attached databases and connected users. I
don't think its possible to retrieve ip info on 1.5x versions, but could be
wrong.

For now you might be better served by creating a table which you use to log
user activity from your client app, this will be made easier if/when you
switch to V2 as you could use the new get/set context functions with the
predefined namespaces (CURRENT_USER, CLIENT_ADDRESS and NETWORK_PROTOCOL).

Hih

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://sourceforge.net/projects/fbutils - FBUtils
http://www.tectsoft.net/ - Homepage