Users Login Standard Reports

[nimitdave]

Use Case

This document will provide the consolidated list of some of the frequently used User Login Standard Reports. This can be lifted and shifted at any customer environment.

This  will cover the following scenarios:

• Users Login History

• Number of User Logins - Past 30 days.

• Users Access Report

Pre-requisites

• Analytics module is working.

• User has access to create new analytics.

Applicable Version(s)

ALL

Solution

User Login History

This report displays the history of the User Logins. Filter this query with respect to the necessary userkey

select u.username,u.firstname,u.lastname,ul.logintime from userlogins ul,users u where ul.USERKEY=u.userkey

Number of Logins - Past 30 Days

This reports provides the number of login happened on daily basis for the past 30 days.

select DATE_FORMAT(LOGINTIME, "%Y%m%d"), count(LOGINKEY) from userlogins where datediff(curdate(),LOGINTIME) < 30 group by DATE_FORMAT(LOGINTIME, "%Y%m%d")

User Access Report

This report provides the users access history. This will give a clear picture of which page has been accessed by which user. This will help in debugging many incidents.

select u.username,u.firstname,u.lastname,ula.accesstime,ula.access_url from userlogin_access ula, userlogins ul,users u where ula.LOGINKEY=ul.LOGINKEY and ul.USERKEY=u.userkey 

and ula.access_url = '/analyticsConfigES/runAllActiveControl';  /* Mention the access URL here */

References

https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter17-EIC-Analytics/Managing-An...