How to add modifield by and modified date time in userinfo table

(0) Share

Report

Posted on by Vishu Beniwal

135

Hello everyone,

I have a requirement in which I have to add field in userInfo table but it's a system table so how can I achieve this. Can I achieve this by using map? If yes than how to use map please help!I

All responses (4)

Answers (1)

Vishu Beniwal 135 on at

Like (0)

Report

RE: How to add modifield by and modified date time in userinfo table

Thanks Nikolaos
Vishu Beniwal 135 on at

Like (0)

Report

RE: How to add modifield by and modified date time in userinfo table

Hi Martin I'm already using sysUserInfo table it's working fine in case of created by and created date time but modified by and modified datetime isn't updating.
Martin Dráb 230,149 Most Valuable Professional on at

Like (0)

Report

RE: How to add modifield by and modified date time in userinfo table

Another possible solution is using SysUserInfo table instead of UserInfo.
Verified answer

nmaenpaa 101,156 on at

Like (0)

Report

RE: How to add modifield by and modified date time in userinfo table

You can't do it because it's a system table.

A map will not help here, either.

Is your business requirement: "I want to track who created and modified AX users?"

That requirement is possible to resolve by using Database log functionality. You can find this table in Database log setup when you navigate to Not specified - User Info Management.