Hello all
Would be grateful if someone could help. Given:
0. I'm just an angry user, no admin rights, no sql access. The only thing I have to solve the problem is Basic Module and faith in bright future.
1. AX2009. For several tables (e.g. VendTable and CustTable) database logs were activated (set up?) by our AX specialists. Everything is ok, logs work perfectly - updates, inserts and annihilations can be seen either through Administration module database log report (hereafter as log report) or via right click in target table -> "Database logs".
2. According to our internal rules we have to generate the log reports quite often. So, someone need to sit and manually generate&save around 30 log reports. It is boring and time consuming.
_____________________________________________________________________________________________________________________
So, my idea was to dig into the log report as much as I can, find a table or tables which contain this database logs data, then though the Basic module put .csv export of these tables on a batch with a given frequency and, finally, write a script in R or VBA which then process all the data.
_____________________________________________________________________________________________________________________
PROBLEM:
For me it looks like the table which the log report relies on is SysDataBaseLog table. However, I do not see any variables like "Current value" or "Previous value". When I just generate the log report manually the interface asks me to provide a table number and dates. So, when one puts 505 (VendTable) he/she will get a nice report where sees what was in a field and for what it was changed. When I export SysDataBaseLog via basic module I see a variable for table name and also a variable for vendor identification. Consequently, what I see is which vendors were changed and how many times. That's it. I do not see which fields/values were changed and how.
The table includes also 2 variables like LogRecId and RecID. I came to the conclusion that LogRecId corresponds with RecId in VendTable, consequently, it reflects current value. But I still do not know from which table (if any) previous value of a given field is taken. And that is the main problem and the main question.
I will be extremely happy if someone could help. Thx in advance!
