Skip to main content
S
SKannapiran12-Amethyst
12-Amethyst
December 20, 2023
Solved

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

  • December 20, 2023
  • 1 reply
  • 1242 views

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.

Best answer by Arun_C

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

1 reply

V
19-Tanzanite
Velkumar19-Tanzanite
19-Tanzanite
December 20, 2023

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

 

Velkumar_0-1703047207940.png

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

 

A
Arun_C16-PearlAnswer
16-Pearl
December 20, 2023

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

    Terms & ConditionsCookie settingsAccessibility statement