Julien_Nitot

Does CA provide any procedure backup SiteMinder SMAUDIT tables ?

Discussion created by Julien_Nitot Employee on Oct 15, 2014
Latest reply on Oct 15, 2014 by Ujwol Shrestha

There is no specific procedure at CA Support to backup your old data.

 

You can check the DB structure in the policy server administration guide :

https://support.ca.com/cadocs/0/CA%20SiteMinder%2012%2052-ENU/Bookshelf_Files/HTML/idocs/238767.html

 

There are basically 2 tables :

 

smaccesslog4   

The following table describes the logging that appears in smaccesslog4,

which logs authentication and authorization activity

It contains an sm_timestamp column.

 

smobjlog4    

The following table describes the logging that appears in smobjlog4,

which logs administrative events.

It contains a sm_timestamp column.

 

You should involve your DBA to do the appropriate queries to extract the Data to prevent the impact on the running environment.

 

Hope it helps, Julien.

Outcomes