BookmarkSubscribeRSS Feed
Quartz | Level 8



I'm looking to re-enable auditing on our VA server, and working out the best way to do this without causing performance issues or the server crashing (this happened last time as the VA Audit entry tables in postgres grew too big).


I've been reading a bunch of documentation on it and what to do, as I feel like last time it was settings that caused issues, and I'm thinking the following is the correct path. If anyone suggests something different, let me know.


1. Purge everything from SASAudit and SASAuditArchive

2. Change the Archiving rules from monthly to weekly in Audit_archive_rule through pgAdmin

3. Change the jvm options for how often the audit archive runs from weekly to daily (Where do I do this btw)

4.On the autoload host, start the scheduled task that deletes old records from the full AUDIT_VISUALANALYTICS table

5. Set the property va.AuditingEnabled to true

6. Restart server

7. Monitor the hell out of it, and manually purge the tables. Plan is to run it for one week once a month and purge after the week once I've got the information I'm looking for.


Few questions though that I can't find in documentation.


1. Where do I change the jvm options for changing the archiving to happen from weekly to daily. Only thing I can in documentation is


To control the archive job schedule, you can add a JVM option to SAS Web Application Server


but is that on 1_1,2_1 etc on the middle tier server, or just one of them. I couldn't find the -Dsas.audit.archive.cron already specified so not sure what to do here.


2. Is there a way to limit what actions are audited (show what reports are viewed for example instead of when everyone logs on and off), or is that just at default and can't change.




Amethyst | Level 16

Hello @titan31,


could we know the current SAS VA version you have, and the hotfix level?

Newer versions do manage better audit data and processes.


Thank you in advance,

Kind regards,


Quartz | Level 8



The VA version is 7.4, and I'm not sure on the hotfix level, but the build date is November 2, 2017 if that helps. We reinstalled back in December and hotfixes haven't been applied since then.


On the about for VA Designer, it says Version is 7.4 Hotfix 05 if that helps.




Amethyst | Level 16

@titan31, and


For the rest, you are right in general. The web application server modification, would it be only in SASServer1_1 (unless you have a cluster), since here is where the WIP is located.


For your last question, please see (see Configuring Auditing for SAS Web Applications)

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 2 in conversation