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:
<!-- 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>
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.