1. According to the documentation at http://msdn.microsoft.com/en-us/library/hh949577.aspx,
UserAccountControl Data type: UInt32 Access type: Read-only Qualifiers: None User account control value retrieved from Active Directory Find a list of all values at: http://msdn.microsoft.com/en-us/library/windows/desktop/ms680832(v=vs.85).aspx 2. LastLogonTimestamp is from SMS_R_System, not SMS_R_User. However, it might be pretty inaccurate, if your purpose is "real-time" logon tracking: http://support.microsoft.com/kb/2679653/en-us Regards Maik From: [email protected] [mailto:[email protected]] On Behalf Of Marcum, John Sent: Dienstag, 26. November 2013 16:51 To: SMS List ([email protected]) Subject: [mssms] v_R_User Attributes A couple of questions here; 1. Does anyone know what all the possibilities on v_R_User.userAccountControl mean? 2. How accurate is v_R_User.Last_LogonTimestamp0? The reason I ask is this sounds like it may not be very accurate in AD: http://blogs.technet.com/b/askds/archive/2009/04/15/the-lastlogontimestamp-attribute-what-it-was-designed-for-and-how-it-works.aspx ________________________________ John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP ________________________________ ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information of Cameron and its Operating Divisions. Any unauthorized use or disclosure is prohibited. If you are not the intended recipient, please contact the sender by reply email and delete and destroy all copies of the original message inclusive of any attachments. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
