02/14/2023 07:58 PM - edited 02/14/2023 08:29 PM
Hi All,
We want to capture login attempts made to a particular URL and we are referring below query.
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 ='<Sample URL>';
But in data analyzer, there is no userlogin_access table.
Can someone let us know about this?
Thanks!
Sanket Bhandhari
02/14/2023 09:16 PM
The table might be not exposed.
Please validate it via Analytics option.
If required raise FD Ticket for enabling the table via Analyzer
02/14/2023 09:53 PM
Thanks Manu for your reply.
We are aware of some tables being not exposed at UI level.
Can't we enable them on our own from UI?
Thanks!
Sanket Bhandhari
02/15/2023 06:47 AM
Hello,
There is no such config to enable from UI.
Raise an FD
02/15/2023 12:13 PM
Hi @Sanket ,
The best option is to leverage Analytics to achieve it. Please create a analytics control using the query and you can schedule it to run as per your requirements for frequency..
As per the product design, the tables restricted to access from UI wouldn't be exposed on UI.
Thanks,