Auditing T_CUST_LOGIN activity

You should be able to do this using SQL Auditing.

https://msdn.microsoft.com/en-us/library/cc280505(v=sql.105).aspx

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David Frederick
Sent: Monday, July 20, 2015 5:57 PM
To: Gloria Ormsby
Subject: [Tessitura Technical Forum] Auditing T_CUST_LOGIN activity

Hi all,

We just had a situation where the anonymous web logon for our website ended up locked out, and I actually had to reset its password back to what we typically use before it started to work again. (Just unlocking it didn't work.) While investigating the cause, I realized that there doesn't seem to be much auditing around certain web logon activities, like when password changes occur.

Has anyone implemented anything to provide more robust logging on web logon (t_cust_login) changes? I thought I would see if someone had done this before I create something myself.

Thanks!
David 

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

You should be able to do this using SQL Auditing.

https://msdn.microsoft.com/en-us/library/cc280505(v=sql.105).aspx

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David Frederick
Sent: Monday, July 20, 2015 5:57 PM
To: Gloria Ormsby
Subject: [Tessitura Technical Forum] Auditing T_CUST_LOGIN activity

Hi all,

We just had a situation where the anonymous web logon for our website ended up locked out, and I actually had to reset its password back to what we typically use before it started to work again. (Just unlocking it didn't work.) While investigating the cause, I realized that there doesn't seem to be much auditing around certain web logon activities, like when password changes occur.

Has anyone implemented anything to provide more robust logging on web logon (t_cust_login) changes? I thought I would see if someone had done this before I create something myself.

Thanks!
David 

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!