> -----Original Message-----
> From: IB-Conversions@yahoogroups.com
> [mailto:IB-Conversions@yahoogroups.com]On Behalf Of MuraliM
> Sent: Miercoles, 19 de Septiembre de 2007 7:52
> To: IB-Conversions1
>
>
>  
>           We are
> migrating from Interbase 5.6 to firebird 1.5.4. Relating to
> migration work we need to find the number of active users
> currently logged into the database (Interbase 5.6). if there
> is any queries to fetch the list of active users please let me
> know.Thanks in advance

Read the API Guide and look for the isc_database_info() call and the
isc_info_user_names item for IB5.6. You will get only yourself if you aren't
administrator or if you use the Classic architecture. When you are sysdba
and are running SuperServer, you'll get a list of all users, per database.
Same for FB.

From FB1 onwards, you can also use the Services API to get the number of
attachments on the server (isc_spb_num_att) and the number of databases
currently in use (isc_spb_num_db).

The number of attachments and the number of databases are available for
quick viewing in Windows if you run FB as an application and double click
the icon in the tray.

C.