Knowledge Base

Count Number Of Licences In Use

Hint Ref: 021611160006
Hint Date: 16/11/2016

Hint Details: To count the number of licences in use withint Sybase 10, (and hopefully above) the following code can be run:

 

SELECT COUNT( * ) FROM sa_conn_info( ) WHERE number < 100000000;


(Please Note: This Procedure can be destructive and should only be used by Advanced Users.  RADical Systems (UK) Limited or its Partners cannot be held responsible, in anyway, for any consequence of using this or any other Database Function, Procedure, XML Script or SQL command.  Responsibility resides solely with the user.  

IT IS HIGHLY RECOMMENDED THAT A FULL AND VALID SPACE MANAGER DATABASE BACKUP IS TAKEN AND VERIFIED AS VALID BEFORE MAKING ANY CHANGES TO THE DATABASE.)