Description:
I have installed R12 Report Server and tried to run the report "Administrative Operations by Administrator", but I cannot schedule it because there's no administrator to select:
<Please see attached file for image>
My environment is the following:
Solution:
Information from this report comes from the table smobjlog4.
In the previous version of SiteMinder, all the admin operations were recorded into the table smobjlog4 by default, but now in R12 this is not longer an automatic process since the legacy Admin UI was replaced by the WAM UI.
From SiteMinder Policy Server Administration Guide - Chapter 7: Configuring Policy Server Logging and then try to run a report:
<- Begin
How to Include SiteMinder Administrative Audit Events in Reports
If you already have a SiteMinder report server and an audit database, you can configure your SiteMinder Policy server to collect administrative audit events that you can import one the following report database types:
After the data is imported, you can include it in any reports you generate using the SiteMinder report server.
-> End
Please keep in mind that you may need to modify the following scripts:
Logs will be created using the comma-separated value (CSV) format, and stored as .TMP files in the following directory:
<policy_server_home>\audit_R6tmp
To import the CSV files into the Oracle database you can use sql loader.
This an example of how you can import data using SQL Loader:
sqlldr <username>/<password> control=control.ctl data=<YourCSVFile> log=logfile.txt
Example of control file:
<- Begin
load data
Append
into table smobjlog4
fields terminated by ","
OPTIONALLY ENCLOSED BY '"'
(
sm_timestamp DATE(23) 'mm/dd/yyyy hh:mi:ssam',
sm_categoryid,
sm_eventid,
sm_hostname,
sm_sessionid,
sm_username,
sm_objname,
sm_objoid
)
-> End
Output:
<- Begin
$ sqlldr r12pslmvm05/password control=control.txt data=xps_3508_20090116115.tmp
SQL*Loader: Release 10.2.0.2.0 - Production on Sun Mar 8 01:42:36 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.Commit point reached - logical record count 64Commit point reached - logical record count 131Commit point reached - logical record count 195Commit point reached - logical record count 259Commit point reached - logical record count 323Commit point reached - logical record count 388Commit point reached - logical record count 452Commit point reached - logical record count 516Commit point reached - logical record count 580Commit point reached - logical record count 643
-> end
Now the WAM UI shows the administrators and the report can be created:
<Please see attached file for image>