CA Application Lifecycle Conductor

Expand all | Collapse all

Licensed user count in ALC

Jump to Best Answer
  • 1.  Licensed user count in ALC

    Posted 06-26-2018 02:40 PM

    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? 



  • 2.  Re: Licensed user count in ALC
    Best Answer

    Posted 06-28-2018 10:41 AM

    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



  • 3.  Re: Licensed user count in ALC

    Posted 06-28-2018 05:53 PM

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

    Regards,

    JOHN