License-at-capacity logging?
I've had several people on my program tell me they were unable to log into ALM Complete because the amount of existing users in the system was at the maximum capacity for the amount of licenses we hav...
Forum Discussion
This can be accomplished by the following database query:
SELECT PersonLogins.PersonLoginId, Persons.FirstName + ' ' + Persons.LastName AS Name, PersonLogins.DeptId, PersonLogins.DateLogin, PersonLogins.DateLogout,
PersonLogins.Machine, PersonLogins.IsLockedOut, PersonLogins.NbrConcurrentUsersLoggedIn, PersonLogins.LoggedOutBy
FROM PersonLogins LEFT OUTER JOIN
Persons ON PersonLogins.UserId = Persons.UserId
WHERE (PersonLogins.IsLockedOut = 'Y')
SELECT PersonLogins.PersonLoginId, Persons.FirstName + ' ' + Persons.LastName AS Name, PersonLogins.DeptId, PersonLogins.DateLogin, PersonLogins.DateLogout,
PersonLogins.Machine, PersonLogins.IsLockedOut, PersonLogins.NbrConcurrentUsersLoggedIn, PersonLogins.LoggedOutBy
FROM PersonLogins LEFT OUTER JOIN
Persons ON PersonLogins.UserId = Persons.UserId
WHERE (PersonLogins.IsLockedOut = 'Y')
