Unable to run the "Administrative Operations by Administrator" report SiteMinder R12 Report Server

Document ID : KB000053679
Last Modified Date : 14/02/2018
Show Technical Document Details

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:

Figure 1

My environment is the following:

  • SiteMinder Policy Servrer R12 SP1 CR02.

  • Oracle 10g as Audit Store.

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:

  • 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.

-> End

Please keep in mind that you may need to modify the following scripts:

  • Harvest.bat (for Windows)

  • Harvest.sh (for UNIX, Linux)

  • ProcessAudit.pl

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:

Figure 2