In Loving Memory

Hit the Tip Jar?

Get Social

I wanted to share this in case it’s helpful to someone else. I had been tasked with finding out what was the last date and time a user had logged into our Connections environment. I was already familiar with the EMPLOYEE table, but I knew I would need a way to cross reference with the other tables to find the information I needed. With the help of a LOT of Googling, and this blog post by Ben Williams, I was able to piece together the following information. Keep in mind that login/access information is stored for each Connections application independently, so you’ll have to find this information for each app …

Using the mangled table above as a reference, you’ll need to find the user’s PROF_KEY from the EMPLOYEE table. Once you have that, use it in the following query:

Not very elegant, I know, but got the job done. Later, when I get more time to play around with it, I will write a script to do all of this for me. This is the quick and dirty method to find what I needed at the time.