Symantec Access Management

Expand all | Collapse all

Tech Tip : CA Single Sign-On : Is the Audit Store data structure the same between SiteMinder 12SP3 and 12.6 ?

  • 1.  Tech Tip : CA Single Sign-On : Is the Audit Store data structure the same between SiteMinder 12SP3 and 12.6 ?

    Broadcom Employee
    Posted Aug 31, 2017 07:57 AM

    Question:

     

    Is the Audit Store data structure the same between SiteMinder 12SP3 and 12.6 ?

     

    Answer:

     

    No they are not the same. There are some differences. The 12.6 version

    adds some fields dedicated to assertions, which are not present in

    12SP3 version.

     

    12SP3 brings this structure :

     

    CREATE TABLE smobjlog4 (

    sm_timestamp DATE DEFAULT SYSDATE NOT NULL,

    sm_categoryid INTEGER DEFAULT 0 NOT NULL,

    sm_eventid INTEGER DEFAULT 0 NOT NULL,

    sm_hostname VARCHAR2(255) NULL,

    sm_sessionid VARCHAR2(255) NULL,

    sm_username VARCHAR2(512) NULL,

    sm_objname VARCHAR2(512) NULL,

    sm_objoid VARCHAR2(64) NULL,

    sm_fielddesc VARCHAR2(1024) NULL,

    sm_domainoid VARCHAR2(64) NULL,

    sm_status VARCHAR2(1024) NULL

    )

    CREATE TABLE smaccesslog4 (

    sm_timestamp DATE DEFAULT SYSDATE NOT NULL,

    sm_categoryid INTEGER DEFAULT 0 NOT NULL,

    sm_eventid INTEGER DEFAULT 0 NOT NULL,

    sm_hostname VARCHAR2(255) NULL,

    sm_sessionid VARCHAR2(255) NULL,

    sm_username VARCHAR2(512) NULL,

    sm_agentname VARCHAR2(255) NULL,

    sm_realmname VARCHAR2(255) NULL,

    sm_realmoid VARCHAR2(64) NULL,

    sm_clientip VARCHAR2(255) NULL,

    sm_domainoid VARCHAR2(64) NULL,

    sm_authdirname VARCHAR2(255) NULL,

    sm_authdirserver VARCHAR2(512) NULL,

    sm_authdirnamespace VARCHAR2(255) NULL,

    sm_resource VARCHAR2(3200) NULL,

    sm_action VARCHAR2(255) NULL,

    sm_status VARCHAR2(1024) NULL,

    sm_reason INTEGER DEFAULT 0 NOT NULL,

    sm_transactionid VARCHAR2(255) NULL,

    sm_domainname VARCHAR2(255) NULL,

    sm_impersonatorname VARCHAR2(512) NULL,

    sm_impersonatordirname VARCHAR2(255) NULL

    )

     

    and the 12.6 bring this one :

     

     

    CREATE TABLE smobjlog4 (

    sm_timestamp DATE DEFAULT SYSDATE NOT NULL,

    sm_categoryid INTEGER DEFAULT 0 NOT NULL,

    sm_eventid INTEGER DEFAULT 0 NOT NULL,

    sm_hostname VARCHAR2(255) NULL,

    sm_sessionid VARCHAR2(255) NULL,

    sm_username VARCHAR2(512) NULL,

    sm_objname VARCHAR2(512) NULL,

    sm_objoid VARCHAR2(64) NULL,

    sm_fielddesc VARCHAR2(1024) NULL,

    sm_domainoid VARCHAR2(64) NULL,

    sm_status VARCHAR2(1024) NULL

    )

     

    CREATE TABLE smaccesslog4 (

    sm_timestamp DATE DEFAULT SYSDATE NOT NULL,

    sm_categoryid INTEGER DEFAULT 0 NOT NULL,

    sm_eventid INTEGER DEFAULT 0 NOT NULL,

    sm_hostname VARCHAR2(255) NULL,

    sm_sessionid VARCHAR2(255) NULL,

    sm_username VARCHAR2(512) NULL,

    sm_agentname VARCHAR2(255) NULL,

    sm_realmname VARCHAR2(255) NULL,

    sm_realmoid VARCHAR2(64) NULL,

    sm_clientip VARCHAR2(255) NULL,

    sm_domainoid VARCHAR2(64) NULL,

    sm_authdirname VARCHAR2(255) NULL,

    sm_authdirserver VARCHAR2(512) NULL,

    sm_authdirnamespace VARCHAR2(255) NULL,

    sm_resource VARCHAR2(3200) NULL,

    sm_action VARCHAR2(255) NULL,

    sm_status VARCHAR2(1024) NULL,

    sm_reason INTEGER DEFAULT 0 NOT NULL,

    sm_transactionid VARCHAR2(255) NULL,

    sm_domainname VARCHAR2(255) NULL,

    sm_impersonatorname VARCHAR2(512) NULL,

    sm_impersonatordirname VARCHAR2(255) NULL,

    sm_assertion_id VARCHAR2(1024) NULL,

    sm_assertion_issuerid VARCHAR2(1024) NULL,

    sm_assertion_destinationurl VARCHAR2(4000) NULL,

    sm_assertion_statuscode VARCHAR2(1024) NULL,

    sm_assertion_NotOnBefore DATE,

    sm_assertion_notonorafter DATE,

    sm_assertion_sess_starttime DATE,

    sm_assertion_sess_notonorafter DATE,

    sm_assertion_authcontext VARCHAR2(512) NULL,

    sm_assertion_versionid VARCHAR2(255) NULL,

    sm_assertion_claims VARCHAR2(3200) NULL,

    sm_application_name VARCHAR2(255) NULL,

    sm_tenant_name VARCHAR2(255) NULL,

    sm_authentication_method VARCHAR2(255) NULL,

    sm_devicehash VARCHAR2(255) NULL,

    sm_deviceid VARCHAR2(255) NULL,

    sm_userrefid VARCHAR2(255) NULL

    )

    KB : TEC1729189



  • 2.  Re: Tech Tip : CA Single Sign-On : Is the Audit Store data structure the same between SiteMinder 12SP3 and 12.6 ?

     
    Posted Aug 31, 2017 11:49 AM