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

(0) Share

Report

Posted on by Vishu Beniwal

143

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

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

nmaenpaa 101,166 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Martin Dráb 238,858 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Another possible solution is using SysUserInfo table instead of UserInfo.

Was this reply helpful? Yes No
Vishu Beniwal 143 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Vishu Beniwal 143 on at

Like (0)

Report
Copy link

Link copied!

Thanks Nikolaos

Was this reply helpful? Yes No