cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

SKannapiran
12-Amethyst

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

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.

ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

3 REPLIES 3
Velkumar
19-Tanzanite
(To:SKannapiran)

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

 

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

Thank you @Velkumar for your response.

Announcements


Top Tags