Using FB 1.5.2; mostly SS but have a couple of Classic locations.
Using Delphi 5 and IBX applications. Running on W2K3 Servers.

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.

How?

Thanks!

-Eduardo