Artikelname: How To Get Firebird / Interbase Connected Users
Autor: Michael
Beschreibung: A Delphi Unit
Kategorie: Firebird / Interbase
Typ:
>>Lies den ganzen Artikel
[ KB ] How To Get Firebird / Interbase Connected Users
Moderators: gto, bravecobra
With Firebird 2.1 use:
SELECT a.MON$ATTACHMENT_ID, a.MON$SERVER_PID, a.MON$STATE, a.MON$ATTACHMENT_NAME, a.MON$USER, a.MON$ROLE, a.MON$REMOTE_PROTOCOL, a.MON$REMOTE_ADDRESS, a.MON$REMOTE_PID, a.MON$CHARACTER_SET_ID, a.MON$TIMESTAMP, a.MON$GARBAGE_COLLECTION, a.MON$REMOTE_PROCESS, a.MON$STAT_ID, a.RDB$DB_KEY
FROM MON$ATTACHMENTS a
SELECT a.MON$ATTACHMENT_ID, a.MON$SERVER_PID, a.MON$STATE, a.MON$ATTACHMENT_NAME, a.MON$USER, a.MON$ROLE, a.MON$REMOTE_PROTOCOL, a.MON$REMOTE_ADDRESS, a.MON$REMOTE_PID, a.MON$CHARACTER_SET_ID, a.MON$TIMESTAMP, a.MON$GARBAGE_COLLECTION, a.MON$REMOTE_PROCESS, a.MON$STAT_ID, a.RDB$DB_KEY
FROM MON$ATTACHMENTS a