Hi all,   I've changed the logconfig.xml to this, as per other thread similar to this on this site:   <appender name="AuditLibraryFile" class="FileAppender"> <param name="Append" value="true"/> <param name="ImmediateFlush" value="true"/> <param name="FilePermissions" value="A::u::rw-,A::g::rw-,A::o::rw-"/> <param name="fileNamePattern" value="somepath/slogs/audit.dataset_%d_%S{hostname}_%S{pid}.log"/> <layout> <param name="ConversionPattern" value="%d!%c!%u!jobid=%S{jobid} Action=%E{Audit.Dataset.Action} Status=%E{Audit.Dataset.Status} Libref=%E{Audit.Dataset.Libref} Engine=%E{Audit.Dataset.Engine} Member=%E{Audit.Dataset.Member} MemberType=%E{Audit.Dataset.Memtype} Openmode=%E{Audit.Dataset.Openmode} Path=%E{Audit.Dataset.Path} Sysrc=%E{Audit.Dataset.Sysrc} Sysmsg=%E{Audit.Dataset.Sysmsg} username=%S{user_name} " /> </layout> </appender>   <!-- Audit.Data.Dataset.Open logger definition --> <logger name="Audit.Data.Dataset.Open" additivity="false"> <appender-ref ref="AuditLibraryFile"/> <level value="Trace"/> </logger> <!-- Audit.Data.Dataset.Delete logger definition --> <logger name="Audit.Data.Dataset.Delete" additivity="false"> <appender-ref ref="AuditLibraryFile"/> <level value="Trace"/> </logger> <!-- Audit.Data.Dataset.Rename logger definition --> <logger name="Audit.Data.Dataset.Rename" additivity="false"> <appender-ref ref="AuditLibraryFile"/> <level value="Trace"/> </logger>   One good news is that the logs are being generated and with the message translated from the string above. But it is recording ONLY when i expand the SASAPP server and not when I expand the library (that is the objective here). It prints like this:   2019-07-24T11:46:17,472!Audit.Data.Dataset.Open!xaccc44!jobid=20230 Action=OPEN Status=SUCCESS Libref=WORK Engine=V9 Member=_PRODSAVAIL MemberType=DATA Openmode=OUTPUT Path=/saswork/sas02/SAS_work7A3400004F06.xxxx.xxxx.xx/SAS_work083C00004F06_xxxxx.xxxxx.xx Sysrc=0 Sysmsg= username=xaccc44   I guess that this ouput would be enough if instead of libref=WORK it printed the libref=library_libref.   It's probably just a "technicality" that i'm missing, but it's the first time with this kind of configurations and your help would be hugely appreciated.   Best Regards, Daniel ... View more

Hi Kurt,   I had to undo that because i simply couldn't make it work. And i don't know XML or sintaxes to being able to insert only N lines each time...   I've opened a ticket to SAS support.   Thanks for your help!   Best regards ... View more

ownership is sas:sas_adm  and permissions where -rw-r--r-- 1   changed it to 777 and didn't work 😞 ... View more

Hi again,   So, i've tried to add this to the file logconfig.xml (it's this one that is eing called on sasv9)   <appender class="RollingFileAppender" name="TimeBasedRollingFile"> <param name="Append" value="false"/> <param name="Unique" value="true"/> <param name="ImmediateFlush" value="true"/> <rollingPolicy class="TimeBasedRollingPolicy"> <param name="FileNamePattern" value="/opt/sas/sasconfig/sasappdv/Lev1/SASAppDV/WorkspaceServer/slogs/sasappdv_%u_%S{hostname}_%S{pid}.log"/> </rollingPolicy> <layout> <param name="ConversionPattern" value="%d %-5p [%t] %X{Client.ID}:%u - %m"/> </layout> </appender>       <logger name="Audit.Data.Dataset.Open" additivity="false"> <appender-ref ref="TimeBasedRollingFile"/> <level value="Trace"/> </logger>   And i keep getting the error on ObjectSpawner_console.log: ERROR: Invalid option value "/opt/sas/sasconfig/sasappdv/Lev1/SASAppDV/WorkspaceServer/logconfig.xml" for SAS option LOGCONFIGLOC. ERROR: (SASXKRIN): KERNEL RESOURCE INITIALIZATION FAILED. ERROR: Unable to initialize the SAS kernel.   and this one on the daily server log: The launch of the server (SASAppDV - Workspace Server) process failed due to a problem with the processing of the SAS Logging Facility configuration file (LOGCONFIGLOC).     I gave chmod 777 to the 'slogs' folder and 'setfacl rwx' to all parties.   any tip about this??   Best Regards, Daniel   ... View more

I'm a (new) sas Admin in a Telecom Company. I have access to the SAS server but every user has its SAS EG installed in the desktop.   I would want to have that config on the server side. We have one physical server with 7 App servers inside (sasapp, sasapp01, .... , sasapp06).   As per the help page https://blogs.sas.com/content/sgf/2015/09/30/part-1-auditing-data-access-who-did-what-and-when/  I do have a logconfig.apm.xml on each app server, folder /opt/sas/sasconfig/SASAPP/Lev1/SASAPP/WorkspaceServer/ but no 'Audit.Data.Dataset' logger specified.   Best Regards and thanks in advance, Daniel ... View more

Hi SAS Kiwi,   Thank you for your answer. One question: You mention a RDB but i use a ODBC Class to create such libs... DOes it make any difference?   I've changed the AssignMode to 2 but the problem mantains... If it's yellow, doesn't expand, if it's white, can expand and shows tables... 😞   Best Regards ... View more