Where is Audit Info Store
-
caseywhite
- Posts: 192
- Joined: Thu May 26, 2016 1:17 am
Where is Audit Info Store
Does anyone know which file either on IBM i or Windows that the audit info about a function source is stored. On green screen you can see the user, date, time and task by pressing F9 when a function is open. On Windows you can see this beside each line of code by enabling the audit info. I want to query this table to verify what lines of code were changed in which functions for a certain task. I can't seem to find where this is stored. I see some cryptic data in DC@F85 but can't seem to sort out how to read it or if that is even it.
Re: Where is Audit Info Store
Hi Casey,
If its lansa function source,
IBMi - the line source is in DC@F29 (command) and there are multiple DC@F30 records for each line. I think the audit info is appended to the end of the value in F30PRM on the last DC@F30 for the source line.
Windows - I think LXXF29 has all the source for a line of source.
(Thats assuming it is lansa function source you want. Component source (reusable parts etc) is in DC@FRD / LXXFRD)
(I think thats right, though I don't have a lansa installation to check)
If its lansa function source,
IBMi - the line source is in DC@F29 (command) and there are multiple DC@F30 records for each line. I think the audit info is appended to the end of the value in F30PRM on the last DC@F30 for the source line.
Windows - I think LXXF29 has all the source for a line of source.
(Thats assuming it is lansa function source you want. Component source (reusable parts etc) is in DC@FRD / LXXFRD)
(I think thats right, though I don't have a lansa installation to check)
-
René Houba
- Posts: 220
- Joined: Thu Nov 26, 2015 7:03 am
Re: Where is Audit Info Store
Hi Casey,
Do you want to see this information on the iSeries or Windows?
Do you want to see this information on the iSeries or Windows?
-
caseywhite
- Posts: 192
- Joined: Thu May 26, 2016 1:17 am
Re: Where is Audit Info Store
Thanks Mark.
Windows was much easier to read. I found it as you said in LXX29 in the column X29PRM. Below are the positions of the values I was looking for. Seems like the audit info is at the start.
Date: 10
User: 18
Task: 28
I only needed function source for now but I checked LX_FRD and see that it stores the info at the end of the line rather than at the start.
With this info in hand I have what I need.
Thanks again.
Windows was much easier to read. I found it as you said in LXX29 in the column X29PRM. Below are the positions of the values I was looking for. Seems like the audit info is at the start.
Date: 10
User: 18
Task: 28
I only needed function source for now but I checked LX_FRD and see that it stores the info at the end of the line rather than at the start.
With this info in hand I have what I need.
Thanks again.
-
caseywhite
- Posts: 192
- Joined: Thu May 26, 2016 1:17 am
Re: Where is Audit Info Store
Hi Renee. IBMi or Windows is fine. Based on the info from Mark it appears that it is easier to read it in Windows from what I can see, but if you have some tips on reading it on IBMi I would appreciate the tips.
Thanks.
Thanks.
-
René Houba
- Posts: 220
- Joined: Thu Nov 26, 2015 7:03 am
Re: Where is Audit Info Store
Hi Casey,
I was thinking about the iSeries Impact List option, but I just checked: you can't check for task details there!!
I was thinking about the iSeries Impact List option, but I just checked: you can't check for task details there!!