Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

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

kapilKochar
Community Advisor
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
Adhiyan
Correct answer by
Employee
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
wodnicki
Community Advisor
Community Advisor

Hi,

Sessions are tracked in xtksessioninfo.

Thanks,

-Jon

kapilKochar
Community Advisor
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

Adhiyan
Employee
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

kapilKochar
Community Advisor
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?

kapilKochar
Community Advisor
Community Advisor

Hi @adhiyan​,

Can you please advise for this.

Thanks,

Kapil

Adhiyan
Correct answer by
Employee
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

kapilKochar
Community Advisor
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 .