We are currently experiencing intermittent login issues on Community.  The team is actively working on a fix.

create a report for the users login history to servicenow

ahatem
Mega Expert

how to create a report for the users login history to service-now?

 

 

1 ACCEPTED SOLUTION

Omkar Joshi
Giga Guru

Hi,

You can use 'syslog_transaction' table.And while creating  report use 'syslog_transaction' table.

 

For the report generation you can refer given attachment,

 

Mark Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.

 

Regards,

Omkar

View solution in original post

5 REPLIES 5

Omkar Joshi
Giga Guru

Hi,

You can use 'syslog_transaction' table.And while creating  report use 'syslog_transaction' table.

 

For the report generation you can refer given attachment,

 

Mark Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.

 

Regards,

Omkar

Login events are tracked in sysevent table.  This system table is not available for reporting.  As a workaround, check out this KB article from ServiceNow:

User login-logout statistics/report for an instance

This was very helpful, thank you!

JennyHu
Tera Guru

Login events are tracked in sysevent table.  This system table is not available for reporting.  As a workaround, check out this KB article from ServiceNow:

User login-logout statistics/report for an instance