cancel
Showing results for 
Search instead for 
Did you mean: 

Get current number of users on server

flaenen
Discoverer
0 Kudos

Hi,

With Data Architect I can get the number of users by:

Remote Server Info, Database Information and Current Users.

I want to get the numner of current users with Delphi.

How can I do this.

sp_mgGetConnectedUsers gives the wrong number

Accepted Solutions (0)

Answers (2)

Answers (2)

joachim_drr
Contributor
0 Kudos

select InUse from (EXECUTE PROCEDURE sp_mgGetUsageInfo()) a
where Item like 'Users'

jhoehne
Participant
0 Kudos

This is done without SQL, by calling "ACE.AdsMgGetUserNames" (see ADS help file)