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:
My environment is the following:
- SiteMinder Policy Servrer R12 SP1 CR02.
- Oracle 10g as Audit Store.
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:
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:
- Oracle database
- Microsoft SQL Server database
After the data is imported, you can include it in any reports you generate using the SiteMinder report server.
Please keep in mind that you may need to modify the following scripts:
- Harvest.bat (for Windows)
- Harvest.sh (for UNIX, Linux)
Logs will be created using the comma-separated value (CSV) format, and stored as .TMP files in the following directory:
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:
into table smobjlog4
fields terminated by ","
OPTIONALLY ENCLOSED BY '"'
sm_timestamp DATE(23) 'mm/dd/yyyy hh:mi:ssam',
$ 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
Now the WAM UI shows the administrators and the report can be created: