Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X
The audit log use case requires capturing login and logout information (user and timestamp) in an external MSSQL database. Our FormLogin.jsp page in ThingWorx handles user authentication using ThingWorx Users. However, we need to capture login and logout events that occur on the ThingWorx page, which must be stored in an external MSSQL database. Please assist with the steps, sharing a code snippet would be greatly appreciated.
Solved! Go to Solution.
Hi @SKannapiran ,
You can use the Events of SecurityMonitor Thing with any of Ext DB thing subscription to log the events.
Kindly refer this article for your refernence. It may helps you.
Simple User Login / Logout Audit Logger for ThingWorx
Thanks & Regards,
Arun C
Hi @SKannapiran
I don't know if there is any other better way. But you can use AuditLogSubsystem to get Login and Logout events with timestamp
You can use Scheduler to push this to external DB. For instance, every day at 12:00 AM (assuming user activity will be low during that time) you can query the previous day data from AuditSubsystem and insert them into an external database.
/VR
Hi @SKannapiran ,
You can use the Events of SecurityMonitor Thing with any of Ext DB thing subscription to log the events.
Kindly refer this article for your refernence. It may helps you.
Simple User Login / Logout Audit Logger for ThingWorx
Thanks & Regards,
Arun C