[trsixie]

Hi, Just a question about doing an SQL query on our BES database.

What I am trying to accomplish is to get a notification when we have less than 10 licenses left.

If I use the following query, I can get the current total number of users:
Select COUNT(*) as TOTAL_USERS
FROM UserStats

And I can get the License Keys, but not the total number of Licenses.

Where can I find the total number of licenses in the BES database? Right now we have 737 Licenses and 717 users, therefore 20 free licenses.

Or should I not be doing it this way and there is some built in tool for License notification.

Thanks
Z