Oracle WebCenter Content Tracking Report Outlines

Install Content tracker in UCM

Data collection: Gathering content access information and writing the information to event log files.
Data reduction: Processing the information from data collection and merging it into a database table.
Data Engine Control Center: The interface that provides access to the user-controlled functions of the Data Engine. It has the following tabs or sub-screens:
Collection: Used to enable data collection.
Reduction: Used to stop and start data reduction (merging data into database tables).
Schedule: Used to enable automatic data reduction.
Snapshot: Used to enable activity metrics. The term snapshot also denotes an information set representing the world at a particular time.
Services: Used to add, configure, and edit service calls to be logged. It is also used to define the specific event details logged for a given service.


Note:- C:\Oracle\Middleware\user_projects\domains\webcenter\ucm\cs\data\components\ContentTracker\config.cfg (SctTrackContentAccessOnly=false)

1. Enable Content Tracker and Content Tracker Report component.

2. we will use three (3) files :
 i - Oracle\Middleware\Oracle_ECM1\ucm\idc\components\ContentTrackerReports\resources\contenttrackerreports_query.htm

3. Add these lines at the end of Oracle\Middleware\Oracle_ECM1\ucm\idc\components\ContentTrackerReports\resources\contenttrackerreports_query.htm
<tr> <td>qCustomusers</td> <td>select dname from users</td> </tr>

4. Add these lines at the end of file Oracle\Middleware\Oracle_ECM1\ucm\idc\components\ContentTrackerReports\resources\contenttrackerreports_template_resource.htm
<@dynamichtml qCustomusers_vars@>
<$reportWidth = "100%"$> <$title = "<i>Users</i>"$> <$reportTitle="Users"$> <$column1Width="35%"$> <$column0Drill="qSctrDocsSeenByUser_Drill"$>
<@end@>


5. Then restart content server.

Some Short notes are :-