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

Accepted Solutions (1)

Accepted Solutions (1)

Adhiyan

Employee

27-08-2019

Hi Kapil,

This is from my local instance with internal login

1822307_pastedImage_0.png

I can see the stored session information from the schema.

My sysfilter in schema definition for xtk:sessionInfo is :

1822308_pastedImage_1.png

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

Answers (6)

Answers (6)

Adhiyan

Employee

21-08-2019

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

kapilKochar

MVP

27-08-2019

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 .

kapilKochar

MVP

21-08-2019

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?

kapilKochar

MVP

20-08-2019

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