Filtering log file data with report filters

About report and time filters

With Report filters, you can filter log file data based on time, site names, IP addresses, or file types. You enter data filter information in the Data tab of the Report Definition Properties window.

About the Report Definitions Data tab

All Report and Time filters are entered on the Report Definitions Data tab.[add pix]

About Report Filter conventions

You can enter two or more filters separated by "," (commas) in the three Report Filter fields. You can also use the * (asterisk) wildcard character in filter names.

Caution
If your enter a value in a filter for which no database records exist, the resulting report's tables and graphs will have no any information. For example, if you misspell a clip name, enter the wrong IP address, or specify a time range for which no data exists, the report will be blank.

About Site Name conventions

By entering filters in the Site Name field, you can generate a report on one or more specific site names.

Note
If this field appears as drop-down box, the ContentReporter administration has limted you to running reports on only the entries listed.

Understanding the difference between host name and site name

In ContentReporter, a Site name is the first or only domain name (with its extension) in a URL string. When one web site hosts another web site, the first domain name (with its extension) is the "site name," and the last domain name (with its extension) is the "host name."

The following table provides examples of Site Names and Host Name and in ContentReporter.

Log file entry	Site Name	Host Name
www.netapp.com/newproducts/index.html	www.netapp.com	none
www.netapp.com/aaa/www.webmanage.com/home.htm	www.netapp.com	www.webmanage.com

Filtering report information on hosted sites, IP addresses, and files and clips

Using the following steps to filter report information on the Data tab of the Report Definition Properties window.

Step	Action
1	Generate one or more reports on a specific site name, enter the site name or names in the Site Name field on the Data tab of the Report Definition Properties window. This tab gives you the ability to create report definitions based on Hosted Sites, URLs, files, and Client IPs for a specified interval of time for one or more caches.
1	For example, Enter www.netapp.com to generate reports based only on log file data related to www.netapp.com. Enter *.net to generate reports based only on log file data related to site names ending with .net.
2	To generate reports on specific files or file types, enter the file names and/or types in the File / Clip field. For example, Enter bill.jpg to generate reports based only on log file data related to the bill.jpg file. Enter .gif to generate reports based only on log file data related to .gif files. Enter /images/* to generate reports on all files in images folders.
3	To generate reports on a specific client IP address or several IP addresses, enter the address or address in the Client IP field. For example, Enter 12.34.56.78 to generate reports based only on log file data related to the 12.34.56.78 address. Enter 12.34.56.* to generate reports based only on log file data related to the 12.34.56 subnet.

Filtering report information on a specific time range

Using the following steps to filter report information on the Data tab of the Report Definition Properties window.

Step	Action
1	In the Report Time Range field, specify the time range of log file data on which to generate a report with this filter. You can choose one of the following "Specify date," "Today," "Yesterday," "Last 7 days," "This Week," "Last 15 days," Last Month," "This month," "Last quarter," "Last 6 months, or " Last year."
2	In the Start Date drop-down, specify the first day of a period of log file data on which to generate a report. For example, if you want to generate a report on log file data from January 1, 2001 through January 31, 2001, you select 1/1/2001 in the Start Date Field.
3	In the End Date field specify the last day of a period of log file data on which to generate a report. For example, if you want to generate a report on log file data from January 1, 2001 through January 31, 2001, you select 1/31/2001 in the End Date Field

Step

Action

In the Report Time Range field, specify the time range of log file data on which to generate a report with this filter.

You can choose one of the following "Specify date," "Today," "Yesterday," "Last 7 days," "This Week," "Last 15 days," Last Month," "This month," "Last quarter," "Last 6 months, or " Last year."

In the Start Date drop-down, specify the first day of a period of log file data on which to generate a report.

For example, if you want to generate a report on log file data from January 1, 2001 through January 31, 2001, you select 1/1/2001 in the Start Date Field.

In the End Date field specify the last day of a period of log file data on which to generate a report.

For example, if you want to generate a report on log file data from January 1, 2001 through January 31, 2001, you select 1/31/2001 in the End Date Field