topic Re: Audit Trail in Administration and Deployment

Audit Trail

Asmam — Thu, 19 Oct 2017 16:49:31 GMT

Hi, I am trying to know the user ID and the code that is associated with a modification so I ran this code , but nothing is displayed

proc sql;
  select
         reason_code,
         _atopcode_,
         _atuserid_ format=$6.,
         _atdatetime_
         from la_prod.ADM_GLOBAL_VARS (type=audit);
quit;

someone can help me please.

Re: Audit Trail

LinusH — Fri, 20 Oct 2017 14:59:53 GMT

Are your sure that audit is activated for this table, and that has been changes since that time?
Please provide the log.

Re: Audit Trail

Asmam — Mon, 23 Oct 2017 09:23:08 GMT

@LinusH thanks for answering me !
Well I activated the audit and I made some changes and I add the variables _ATRETURNCODE_ , _ATMESSAGE_ .

it works for the datetime and the user name ! but i got nothing for _ATRETURNCODE_ and _ATMESSAGE_ .

Re: Audit Trail

LinusH — Mon, 23 Oct 2017 12:51:46 GMT

I can't test it right now, but my guess is that those are only populated when there is an issue, like a violated constraint or similar.