Capture login and logout events that occur on the ThingWorx page in an external MSSQL DB.

[SKannapiran]

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.

[Velkumar]

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

[Arun_C · Accepted 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

[SKannapiran]

Thank you @Velkumar for your response.