I am trying to find which user accessed which dataset in past or create a trace for coming days where I can have a script which gathers this information.
I cam across a topic where it says to add the logger and appender xml.
I added the 'logger' and 'appender' to capture it in a SAS Dataset and restarted the dev server.
And ran the below SAS code in DEV Server, but the log dataset I created is empty.
Also, when I try to test logical stored process server connection it fails with below message:
<!-- Caution: Do NOT edit or change this appender configuration (DB Appender changes delete this and logger if issues) -->
<appender name="dblog" class="DBAppender">
<param name="ConnectionString" value="DRIVER=base;CATALOG=base;
<param name="MaxBufferedEvents" value="300" />
<param name="TableName" value="LOG" />
<!-- The column parameters must be specified in exactly the same order that the columns occur in the table. -->
<param name="column" value="sn" />
<param name="column" value="d" />
<param name="column" value="c" />
<param name="column" value="u" />
<param name="column" value="m" />
<logger name="Audit.Data.DB" additivity="false">
I did in the same sequence for column parameters, when I spoke to SAS Support they advised stored process is bunch of concurrent processes and assigning a single dataset for all sessions won't help. Awaiting resolution.