Confirm

SQL and Report - Count User Logins Confirm OnDemand and ConfirmConnect

  • 1.  SQL and Report - Count User Logins Confirm OnDemand and ConfirmConnect

    Posted 5 days ago
    Is there are available SQL already writen to Count the number of times people have logged in using Confirm on a pc and a mobile device?

    I have tried with this code below but it shows thousands of "logins" for some people and the user_log.source_flag shows either A,C or is blank.  I cannot find any details of what A and C represent.  Probably C = ConfirmConnect and A is a Web based login.

    You could of course add an extra line to view details of a specific work Group should you require :
      eg. work_group.work_group_code = 'STR' AND

    It would be very nice if this was made available in a Report in ADManagerPlus along with all the other reports similar to "Recently Logged On Users" where you can select the desired time period.

    Thanks for any information.
    ======================================================================
    Code I currently use is :
    SELECT
    user_login.login_name,
    user_login.first_name,
    user_login.surname,
    count ( user_login.login_name ) as Quantity_Of_Logins,
    work_group.work_group_name,
    user_log.source_flag
    FROM
    user_login, user_log,
    work_group
    WHERE
    user_login.login_name = user_log.login_name AND
    work_group.work_group_code = user_login.work_group_code AND
    user_log.source_flag IS NULL AND
    user_login.surname IS NOT NULL AND
    user_log.login_time >= '01-SEP-2019'
    GROUP BY
    user_login.login_name,
    user_login.first_name,
    user_login.surname,
    work_group.work_group_name,
    user_log.source_flag
    ORDER BY
    Quantity_Of_Logins DESC,
    user_login.surname,
    user_login.first_name


    ------------------------------
    Barry Jones
    Cheshire West and Cheshire
    Chester
    ------------------------------