If we have a patron with an existing account who creates a new account through the website, we merge the two records. This leads to patrons with multiple active logins of the same type. Is there a query that can tell me which specific login_no (or web username) was used for a particular web session? I see LoginID in t_web_session_session but it appears to be deprecated.
Thanks!
- Levi
The closest I could get was with:
select *
FROM dbo.t_web_session_Session s
Join t_web_session_Variable v on s.SessionKey = v.SessionKey and Name = 'UID'
Join T_CUST_LOGIN cl on v.Value = cl.[login]
Hopefully that's helpful.
I think that is exactly it! Thank you :) Hadn't thought to use the variable table.