Application Lifecycle Conductor

We have a license for 300 users in ALC. How do we know how many of those that we are using? 

Is it simply the number of Active users in the def_person table? 

Hello David,

This query (written for SQL Server) would give you the answer:

SELECT COUNT(*)
FROM DEF_PERSON
WHERE (EXPIRES IS NULL
OR EXPIRES > CURRENT_TIMESTAMP)
AND LEN(LOGONID) > 0

For Oracle it would be a little different, so let me know if you need to see an Oracle version of this query.

Thanks

I think that for license count only users with "ISASSIGNABLE" flag are taken into account.

Regards,

JOHN