Hello, 

I would like to save datetime value when a user modifies some of the profile properties for e.g. DateOfBirth. The main aim as per the nature of my app here is just to audit modification date and time for certain properties and not for the whole user profile entity. 

I've two options for audit purpose for these particular properties:

1. To audit only the last modification date and time. For this, I've created a new user profile property and this is not visible to users on UI.
2. To audit all of them. For this, I guess I'll have to create a new table in the database for audit purpose.

How can I hook this additional modification date time save feature in the database for both of the options above? As I need to know when a User modifies their user profile to save this additional information. Can I still reuse the Edit Profile feature available in DNN and save this information OR do I need to create a new module just to modify those profile properties for which I need to audit?

Hi Sebastian, 

Thanks for pointing out the built-in property level auditing in UserProfile table.

I access this using: 

ModuleContext.PortalSettings.UserInfo.Profile.ProfileProperties.GetByName("FirstName").LastModifiedOnDate

In return what I see is the default datetime value that is "1/1/0001 12:00:00 AM". Although I can see the actual correct value in the database. I use the above statement in my custom module that inherits "ModuleUserControlBase". 

Is this something you told me already that it may not check whether a value has changed ? when you mentioned: " the Users module might not check, whether a value has changed, when hitting update, i.e. updating each property."

Is there any other way to access the last updated datetime information? Or do I just need to just query the table manually with where clause including portal id, user id, etc. ?

GetUserProfile retrieves property values with lastModifiedOnDate and lastModifiedByUser from UserProfile table in the database. If the value is properly stored but you are getting a null date, there must be an issue in DNN API.