I must trace the history of changes to each data (modification date, user ID, IP address of the workstation) ?

Finance and Operations/AX Developer Forum
1

Hi All,

Greetings for the day!!

I must trace the history of changes to each data (modification date, user ID, IP address of the workstation) , I got the information from the sysdateabaselog but I need IP address along with the each record.

Regards,

GVK.

2

What difference does it make whether the user changes the data from this or that machine? What business requirement is behind this technical requirement?
If you really need it, you’ll have to customize AX.

3

Hi martin,
Thanks for giving replay,

thing is one user created some operations like SO, using another user credentials, through his system . That’s why I need to track the IP address.

Regards,
GVk

4

But he/she can also use somebody else’s machine, a terminal server or who knows what. Shouldn’t you rather make sure that your users stop throwing the whole security policy out of the window? Ask them why they use somebody else’s credentials - maybe some users don’t have permissions they need. You should make sure that stop sharing credentials with others; it’s a huge security problem.

5

Hi Martin,

I tried like this,

static void GI_Ipaddress(Args _args)
{
UserInfo userInfo;
SysUserLog sysUserLog;
System.String hostName ;//System.Net.Dns::GetHostName();
System.Net.IPHostEntry hostEntry; // = System.Net.Dns::GetHostEntry(hostName);
System.Net.IPAddress[] address ; // = hostEntry.get_AddressList();
System.Net.IPAddress adress ;
System.Net.Sockets.AddressFamily adressFamily;
System.Collections.IEnumerator enumerator;
;
while select * from sysUserLog join userInfo where userInfo.id == SysUserLog.UserId
{
hostName = sysUserLog.Computername;
hostEntry = System.Net.Dns::GetHostEntry(hostName);
if(hostEntry)
{
address = hostEntry.get_AddressList();
enumerator = address.GetEnumerator();
while(enumerator.MoveNext())
{
adress = enumerator.get_Current();
adressFamily = adress.get_AddressFamily();
if(adressFamily == System.Net.Sockets.AddressFamily::InterNetwork)
{
info(adress.ToString());
}
}
}

}
}

Regards,
GVK

6

and , collected the information form UserLog Form.