How can we calculate number of user logged for a particular Instance in AC? | Community
Skip to main content
kapilKochar
kapilKochar
Level 6
Aug 20, 2019 1:49 AM UTC
Solved

How can we calculate number of user logged for a particular Instance in AC?

Hi ,

I wanted to make a report hourly bases to calculate no of User logged in and working. Please let me know any efficient way.

Thanks,

Kapil

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Adhiyan
    AdhiyanAccepted solution
    Employee
    Aug 27, 2019 10:35 PM UTC

    Hi Kapil,

    This is from my local instance with internal login

    I can see the stored session information from the schema.

    My sysfilter in schema definition for xtk:sessionInfo is :

    If this is the same as yours , then the alternate process can be to simply run a JS code to query the information from the database directly

    var cnx = application.getConnection()

    var stmt = cnx.query("select * from xtksessioninfo;")

    for each(var row in stmt)

    logInfo(row);

    cnx.dispose();

    and then manipulate the logs to extract information required and create the report

    Regards,
    Adhiyan

    View reply

    7 replies

    kapilKochar
    kapilKocharAuthor
    Level 6
    Aug 28, 2019 12:26 AM UTC

    Thanks Adhiyan.

    Using JS  I am able to check the records. Just one more question, As you can see in your screenshot shared above. There are multiple admin Session records in this schema is it means this schema store all the connection even if that account is not login currently?

    As I wanted to check who all logged in when my reports Run.

    Thanks a lot for your help so far .

    Translate
    Adhiyan
    AdhiyanAccepted solution
    Employee
    Aug 27, 2019 10:35 PM UTC

    Hi Kapil,

    This is from my local instance with internal login

    I can see the stored session information from the schema.

    My sysfilter in schema definition for xtk:sessionInfo is :

    If this is the same as yours , then the alternate process can be to simply run a JS code to query the information from the database directly

    var cnx = application.getConnection()

    var stmt = cnx.query("select * from xtksessioninfo;")

    for each(var row in stmt)

    logInfo(row);

    cnx.dispose();

    and then manipulate the logs to extract information required and create the report

    Regards,
    Adhiyan

    Translate
      kapilKochar
      kapilKocharAuthor
      Level 6
      Aug 26, 2019 11:26 PM UTC

      Hi @adhiyan​,

      Can you please advise for this.

      Thanks,

      Kapil

      Translate
      kapilKochar
      kapilKocharAuthor
      Level 6
      Aug 22, 2019 3:10 AM UTC

      Hi Adhiyan,

      Thanks for your reply.

      I Tried with internal as well but same result. Is there any particular operator group i should assign to user for this?

      Translate
      Adhiyan
      Adhiyan
      Employee
      Aug 21, 2019 10:36 AM UTC

      Hi Kapscool,

      You are probably logging in as the 'admin' user . Try logging in with the 'internal' user instead.

      This schema has restrictions based on the login to view the data.


      Regards,

      Adhiyan

      Translate
        kapilKochar
        kapilKocharAuthor
        Level 6
        Aug 21, 2019 5:31 AM UTC

        Thanks Jon for your response.

        I have checked this Schema and there are no records present. I logged in and checked it to my local instance.

        Do I need to enable something in config file to have records in this schema?

        Thanks,

        Kapil

        Translate
        Jonathon_wodnicki
        Jonathon_wodnicki
        New Participant
        Aug 20, 2019 2:50 PM UTC

        Hi,

        Sessions are tracked in xtksessioninfo.

        Thanks,

        -Jon

        Translate
          Terms & ConditionsAccessibility statement

          Loading footer...