RE: Last Web log in

Anne,

We have a view just for Primary logins
Select      a.*, b.edit_ind

From  [dbo].t_cust_login a

      JOIN [dbo].vrs_login_type b ON a.login_type = b.id

where a.primary_ind = 'Y'

and then you can reference last_login_dt from there or directly from T_CUST_LOGIN table.

Sabina

From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Anne Chao
Sent: Tuesday, September 20, 2011 6:26 PM
To: Sabina Spilkin
Subject: RE: [Tessitura Web Forum] Last Web log in

Hi AIl,

I would like to add "Last Web Login" as one of the attribute that I can pull from the Out put set.

Could someone show me how to do so? I am not a DBA, but trying to figure out what would be the best way/place for me to see information that I need stored in what table and best guess of the name of the colunm?  for instance, what would be the reference table for Last Web Login? and select data !.last_web_login?

Hope this make sense..

Thanks!!

-Anne

--
View this message online at http://www.tessituranetwork.com/COMMUNITY/forums/p/5524/17663.aspx#17663 or reply to this message
--
You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!