LastAccessTimeStamp column in DBC.Users

Database
Enthusiast

LastAccessTimeStamp column in DBC.Users

I would like to cleanup users who have not signed onto Teradata in the past 6 months.

I was thinking of using the LastAccessTimeStamp column in DBC.Users however this column is not being populated and displays as a '?'.

1.) How does one turnon the recording of column LastACcessTimeStamp in DBC.Users?

2.) Would the columnn 'LogonDate' in DBC.LogonOff be more appropriate to use for cleanup of obsolete users.

Thanks,
Marius
2 REPLIES
Enthusiast

Re: LastAccessTimeStamp column in DBC.Users

LastAccessTimeStamp is for recording the last access done on the Object and is by default not turned on.

What you should be looking to use is is the Logon/off date in the DBC.LogonOff as you correctly mentioned.
Enthusiast

Re: LastAccessTimeStamp column in DBC.Users

Thnx Joe...Marius