Dear Friends,
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:
![Amitkmr1979_0-1678096572009.png Amitkmr1979_0-1678096572009.png](https://communities.sas.com/t5/image/serverpage/image-id/81100iC9B1B35773761FDC/image-size/medium?v=v2&px=400)
<!-- 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;
schema=(name=mywork;primarypath='C:\temp');" />
<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" />
</appender>
Logger
<logger name="Audit.Data.DB" additivity="false">
<appender-ref ref="dblog"/>
<level value="Info"/>
</logger>