topic Audit trail details in Administration and Deployment

Audit trail details

Y_S — Thu, 05 May 2016 11:52:03 GMT

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.

Re: Audit trail details

Mark_sas — Mon, 09 May 2016 18:19:05 GMT

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.