NEW: View the total number of active users (for customers with a perpetual license).

A perpetual license of UserLock counts the number of concurrent user sessions. To find the number of active users that this represents, you can use the following methods, depending on the version of the software:

For versions 11.1 and newer, launch the diagnostic tool by pressing F12 in the UserLock console to generate file logs. Open the file diagnostic.txt and scroll down to the table of the session count. Underneath, you will see two entries for number of active users in the last 30 and 365 days. The number of active users in 30 days is what would be counted in the license.

For versions older than 11.1, you can use one of the below queries to get a list of the number of Active users in the last 30 days directly from your database.

Here is a list of the different queries based on the database that you have configured for UserLock events. By default, the software comes with an Access database.

ACCESS

SELECT COUNT(*)
FROM
(
SELECT DISTINCT UserAccount, UserDomain
FROM UserLogonEvents
WHERE EventTime >= DATEADD("d", -30, DATE())
AND ComputerName <> UserDomain
) as result

SQL

SELECT COUNT(*)
FROM
(
SELECT DISTINCT UserAccount, UserDomain
FROM UserLogonEvents
WHERE EventTime >= DATEADD(DAY, -30, GETDATE())
AND ComputerName <> UserDomain
) as result

MySql

SELECT COUNT(*)
FROM
(
SELECT DISTINCT UserAccount, UserDomain
FROM UserLogonEvents
WHERE EventTime >= DATE_SUB(CURDATE(),INTERVAL 30 DAY)
AND ComputerName <> UserDomain
) as result

You can run these queries directly in the UserLock console by selecting SQL Query from the sidebar menu and entering the query as shown below:

The results will give you the number of active users in UserLock:

For further assistance on how to count your active users, please contact our sales team.