Track change log with Host name /IP address ?

[Former Member]

Is it possible to track  modification /Update details in SAP b1 8.82 PL 11 by combining  the document table  with USR5?What i need is to track the user name  and host name /Ip address who modifies a specific document like Business Prtner master data, Item master,all sales /Purchase /Inventory related documents .Is it possible without using any addons but  through a query report?

[kothandaraman_nagarajan]

Hi,

Try to  link tables OITM, OUSR and USR5 to get updated details.

Thanks & Regards,

Nagarajan

[former_member203899]

Hi Nabil,

Yes It is possible.

I will tell you one example.

If you want to find GRN data that enter user details and enter data client IP.

then

just find out GRN record.

select * from OPDN where DocNum = 42867

then use another Query for retrive User Details.

select * from USR5 where ActionBy = 'STR1' and Date = '2014-06-19'

I think you understand my concept.

Regards,

Nishit Makadia

[Former Member]

Nishit ,

But  need to write two queries for that .I need something like the following query ,But the output contains duplicate values  so that i cant track the specific user/host name. I need to track  the change log of all the documents  like this query .

SELECT T1.[CardCode], T1.[CardName],T1.[UpdateDate], T1.[CreateDate], T2.[UserCode], T2.[ClientIP], T2.[ClientName], T2.[Date], T2.[Time] FROM [dbo].[ACRD]  T1, USR5 T2 WHERE T1.[CardCode] = 'C-AP-HYD-1931'