Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

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

Avatar

Community Advisor

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

1 Accepted Solution

Avatar

Correct answer by
Employee

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

View solution in original post

7 Replies

Avatar

Community Advisor

Hi,

Sessions are tracked in xtksessioninfo.

Thanks,

-Jon

Avatar

Community Advisor

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

Avatar

Employee

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

Avatar

Community Advisor

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?

Avatar

Community Advisor

Hi @adhiyan​,

Can you please advise for this.

Thanks,

Kapil

Avatar

Correct answer by
Employee

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

Avatar

Community Advisor

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 .