Showing posts with label Reports. Show all posts
Showing posts with label Reports. Show all posts

Thursday, August 20, 2015

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 :-



AWS EC2 - SSH locked with UFW

Need to update the instance's user data: 1. Stop the instance 2. Right click (windows) or ctrl + click (Mac) on the instance to open a c...