BookmarkSubscribeRSS Feed
Y_S
Calcite | Level 5 Y_S
Calcite | Level 5

For getting the Audit trail details of SAS datasets, followed the below steps :

1/ Back up the SAS Config folder

2/ Run "emi_init.bat -i"

3/ Run "apm_init.bat --hostAlias hkw00107113c01.hk.hibm.hsbc"

4/ Run configureAPMlocal_hkw00107113c01.hk.hibm.hsbc.bat

5/ Restart OLAP, Object Spawner & Metadata Services

6/ Update "levRoot" in E:\SAS\Config\Lev1\Web\SASEnvironmentManager\emi-framework\Conf\log_definitions.json

7/ Run "emi_init.bat --enable APM"

8/ Configure APM ETL Processing in Environment Manager console (:7080).

There's a script to manually run the APM job to populate the tables:

<Config>\Lev1\Web\SASEnvironmentManager\emi-framework\bin\master_apm_etl.bat - executed the same

All the expected datasets were populated except below 2:

AUDITACCESSCONTROLDETAIL.

AUDITIM

 

Can anyone help me understand what should be done to get mentioned datasets populated.

 

1 REPLY 1
Mark_sas
SAS Employee

In many cases, the absence of tables or data in the set of Environment Manager data sets is due to there not being corresponding activity.  

ARTIFACT.AUDITACCESSCONTROLDETAIL tracks activity related to modifying access control information in metadata.  If no such activity has occurred, it wouldn't be surprising for this data set to be missing.  Similarly, AUDIT.AUDITIM is intended to capture Information Map activity (or at least it was in earlier versions).

 

Did you receive any errors when you attempted to run emi_init or master_apm_etl scripts?

 

If you *did* receive errors, or you continue to have an empty ARTIFACT.AUDITACCESSCONTROLDETAIL data set after access control info is modified in your environment (and the subsequent EV APM job is run by hand or automatically overnight), it would be good to give Tech Support a call to investigate further.


Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users

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
  • 1 reply
  • 1063 views
  • 0 likes
  • 2 in conversation