> Customer Care Interface and Report Engine
> This appendix describes how to use the Content Filtering Customer Care Interface (CF-CCI) to provide customer support, and the Report Engine (RE) to generate subscriber usage reports.
> CF-CCI System Usage with a Client Workstation
> Content Filtering CCI is a Web-based GUI interface to provide information to support staff in the operator’s customer-care support center. Customer care staff can provide support and solutions to subscribers who are having problems with the content filtering results and policies associated with their account.
> IMPORTANT: For information on system requirements for a client workstation to access CF Customer Care Interface server through HTTP, refer to the CF Customer Care Interface Client Recommendations section in the Content Filtering Support Overview chapter.
> Logging on to the CF-CCI Server
> To log on to the CF-CCI server:

> 1 | In a Web browser window, open the following URL:

> https://cci_installation_server or IP_address:HTTPS Port/cci/login.jsp
> Where cci_instalation_server:port is the IP address/host name and port number of the CCI server where the CF-CCI server application is installed. The server IP address must be entered in dotted-decimal notation.
> The Login screen is displayed.

> 2 | In the User Name text box, enter the user name.

> 3 | In the Password text box, enter the password.

> 4 | Click Login.

> The subscriber service management screen is displayed.
> IMPORTANT: The CCI application supports secure access, which displays security alerts when users access the “login.jsp” for the first time. If users accept and install the security certificate on their machines, the security alert message is not displayed the next time they access the “login.jsp” page.
> User Administration
> Adding User Account
> To add a user account:

> 1 | Click the “Add User” link. The “Add User” screen is displayed.

> 2 | In the User Name text box, enter the user’s name.

> 3 | In the Password text box, enter a password for the user.

> 4 | In the Confirm Password text box, re-enter the password.

> 5 | In the Privilege list, select the user’s privilege level.

> 6 | To save the user account, click Add. A confirmation message is displayed.

> 7 | To confirm creation of the user account, click Yes.

> Modifying User’s Password/Privilege
> To modify a user’s password/privilege:

> 1 | In the User Name column, select the user, then click the Modify link for the user. The Modify User screen is displayed.

> 2 | In the Old Password text box, enter the user’s old/current password.

> 3 | In the New Password text box, enter a new password for the user.

> 4 | In the Confirm New Password text box, re-enter the new password for the user.

> 5 | To change the user’s privilege, select the Privilege check box, then in the list, select the privilege.

> 6 | To save the changes, click Modify. A confirmation message is displayed.

> 7 | To confirm changes to the user account, click Yes.

> Deleting User Account
> To delete a user account:

> 1 | In the User Name column, select the user account that you want to delete, and click the Delete link for the user. A confirmation message is displayed.

> 2 | To confirm deletion of the user account, click Yes.

> URL Rating
> To access the URL Rating page, click the URL Rating link available in the left navigation pane of the CF-CCI main page. The following screen is displayed.
> CF-CCI URL Rating Interface
> To view the URL category and rating information through URL Rating interface page:

> 1 | In the URL text box, enter the URL with proper syntax and notations.

> The URL can be a maximum of 4096 alpha and/or numeric characters in length.

> 2 | Click Classify Now button. The CCI system displays the URL category information in the Category field.

> IMPORTANT: If queried URL is not categorized in Optimized Content rating Master Database (OPTCMDB) the CF-CDP server will return “None” as category for the queried URL and in case asked URL is missing from OPTCMDB the CF-CDP will return “Undefined” as category for this.
> URL History
> This section describes how to view the history of a subscriber’s activity for the site requests.
> To access the “URL History” page, click the Site History link available in the left navigation pane of the CF-CCI main page. The following screen is displayed.
> CF-CCI Site History Interface
> This interface allows the user to view the list of URLs accessed by the subscriber. Use the following procedure to access the list of URLs accessed by the subscriber.

> 1 | In the Subscriber ID text box, enter the subscriber’s MN/IMSI/MSID.

> The subscriber ID must be a maximum of 16 characters in length. Additionally, you can enter the network access identifier (NAI) in the Network Access Identifier text box.

> 2 | To select the duration and narrow the search results, select the Date/Time Since check box.

> The Calendar tool is displayed.

> 3 | Select the date and time to display all the URLs accessed by the user in the time range.

> 4 | Select the search criteria in the Search by section of the screen by selecting the check box for each search criteria, and entering/selecting the needed value across the field. The individual search criteria are optional.

> The following is the list of search criteria in the Internet Site Access History section of the screen:

> l | URL: Enter the URL string with maximum allowed length of “URL” in text field of 4096 characters.

> l | Category List: The category list contains multiple elements for URL or content rating. Some of the categories are:

> l | Gambling

> l | Gaming

> l | Child Pornographic

> l | Adult Related Material

> See the Category List appendix for the list of categories and their description.

> l | Action List: The action list contains multiple elements to provide action on content or URL. Following are the available actions for a content or URL providing content on the basis of configurations:

> l | Allowed

> l | Discarded

> l | Re-directed

> l | Blocked with Content Insertion

> l | Blocked

> l | Rating List: The rating list contains two elements, Static or Dynamic.

> 5 | Select the duration by enabling the Date/Time Since check box to narrow the search result. On enabling this check box the Calendar tool is displayed. In the Calendar tool select the date and time to display all the URLs accessed by the user since specified date and time.

> 6 | Click Pick Date/Time button to accept the date and time selected.

> 7 | In the Time Zone combo-box, select the time zone.

> 8 | After entering the search criteria, click the Search button. If the site history is present for the entered Subscriber ID with matching search criteria, the CF-CCI system displays the list of URLs accessed. See the following figure for a sample.

> CF-CCI Subscriber Site Access History
> The following table describes the fields in the “List of URLs Accessed” table of the CCI subscriber site history page.

> Keyword | Description
> Subscriber ID | This label specifies the CF subscriber’s identification or NAI whose list of visited URLs is queried.
> Max. URLs to be displayed | Specifies the maximum number of URLs can be displayed in one page of “List of URLs Accessed” table.
> No. of URLs displayed | Specifies the number of URLs displayed in “List of URLs Accessed” table for this Subscriber ID.
> Time Zone | Indicates the time zone selected by the CCI user on the “Site History” screen.
> URL | Represent the URL name accessed by the subscriber.
> Action | Represent the action performed on the URL.
> Rating | Represent whether the URL was rated statically or dynamically.
> Category | Represent the category of the URL.
> Date | Represent the date when the URL was accessed by the subscriber.
> Time | Represent the time the URL was accessed by the subscriber on the date specified by the Date column.

> Generating EDR Reports through Report Generator
> This section describes how to generate the reports using the Report Generator tool.
> Report Generation
> The Report Generator utility in CF-CDP is a script based tool responsible for report generation and EDR parsing. A script-based utility generates reports in XML format for content filtering subscribers and report engine server takes care of EDR parsing.
> The Report Generator provides the following types of reports:

> l | Overall Summary Report

> l | Subscriber Detail Report

> l | URL Summary Report

> These reports can also be generated from the WEM GUI. For more information, refer to WEM Online Help.
> IMPORTANT: Data from CF-System in the form of EDR files are fetched, parsed, and stored in database at CF-CDP server. It is mandatory that EDR files must contain following fields to generate EDR reports through Report Generator:
> sn-start-time
> radius-calling-station-id OR radius-user-name
> sn-cf-category-rating-type
> sn-cf-category-classification-used
> sn-cf-category-flow-action
> sn-cf-category-policy
> sn-cf-category-unknown-url
> If these mentioned fields are missing from the header of EDR file, Report Generator will skip those EDR files for report generation purpose.
> The usage format of the command used to generate the EDR reports is as follows:
> xmlGenerator --s <StartDate> --e <EndDate> --t <1|2|3> --i <IMG-Name> --n <NAI> --d <SCBRID> --u <URL-Path>
> –or–
> xmlGenerator -startdate <StartDate> -enddate <EndDate> -reporttype <1|2|3> -img <IMG-Name> -nai <NAI> -scbrid <SCBRID> -url <URL-Path>

> Keyword | Description
> -startdate|--s | Specify the start date of report. This is a mandatory parameter. Format: MM/DD/YYYY HH:MM:SS
> -enddate|--e | Specify the end date of report. This is a mandatory parameter. Format: MM/DD/YYYY HH:MM:SS
> -reporttype|--t | Specify the report type. The possible values are 1, 2 or 3 indicating three types of reports:
> n | 1: Overall Summary Report
> Description: This is a short summary of all the transactions done so far. Selection Criteria: Timeframe (startdate, enddate) Refer to Figure C-4 for a sample of Overall Summary Report.
> n | 2: Subscriber Detail Report
> Description: This is a very fine level of reporting in which you will get detailed information about each URL, when it was visited, etc. Selection Criteria: Timeframe, Report schema fields and nai/scbrid Refer to Figure C-5 for a sample of Subscriber Detail Report.
> n | 3: URL Summary Report
> Description: This is a higher level of report which will show how many times the URL was visited. This is a mandatory parameter. Selection Criteria: Timeframe and Filename containing list of URLs Refer to Figure C-6 for a sample of URL Summary Report.
> -nai|--n | Specify the NAI (radius-user-name).
> -scbrid|--d | Specify the Subscriber Identifier (radius-calling-station-id). Either nai or scbrid is mandatory for Subscriber Detail Report.
> -img|--i | Specify the name of STxx. This is optional.
> -url|--u | Specify the absolute path of file containing list of URLs. This is mandatory for URL Summary Report.

> The following figure shows a sample Overall Summary Report generated using the Report Generator tool.
> Sample Overall Summary Report
> The following figure shows a sample of the Subscriber Detailed Report generated using the Report Generator tool.
> Sample Subscriber Detailed Report
> The following figure displays a sample URL Summary Report generated using the Report Generator tool.
> Sample URL Summary Report
> For descriptions of these reports, see the Report Engine (RE) section in the Content Filtering Support Overview chapter.
> File Naming Convention and Report Storage
> The Report Generator stores the generated reports in the /report directory of the cdp_base_directory with the following naming convention:
> ReportType_ReportGenerationDate_ReportGenerationTime.xml
> The following is the convention for naming variables:

> l | ReportType: This report type can be any one of the following:

> l | OverallSummary: For Overall Summary Report

> l | SubscriberDetail: For Subscriber Detailed Report

> l | URLSummary: For URL Summary Report

> l | ReportGenerationDate: Report generation date in UNIX or POSIX format.

> l | ReportGenerationTime: Report generation time in UNIX or POSIX format, i.e. in hr:min:sec.millilsec format.

> The following are examples of report file names:
> OverallSummary_20081014_102522.xml
> SubscriberDetail_20081014_103343.xml
> URLSummary_20081014_103421.xml

Cisco Systems Inc.
Tel: 408-526-4000
Fax: 408-527-0883