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