Cisco BBSM 5.1 Software Configuration Guide - 7 - Viewing and Printing BBSM Reports [Cisco Building Broadband Service Manager]

Table Of Contents

Viewing and Printing BBSM Reports

Accessing the Reporting Pages Interface

Usage Reports

Usage Reports Calendar Day Offset

Usage By Year Report

Usage By Month Report

Usage by Day Report

Transaction History Report

Active Ports Report

Access Code Reports

Access Code Report

Unused Code Report

Access Code History Report

Room Mappings Report

Room Mappings View List

Room Mappings Edit Record

RADIUS Report

Walled Garden Report

Viewing and Printing BBSM Reports

Reports of BBSM activities and functions can be viewed and printed on a site basis by using the Reporting Pages option under the Reports section of the BBSM Dashboard. The following are the reports you can select:

•Usage

•Transaction History

•Active Ports

•Access Codes

•Room Mappings

•RADIUS

•Walled Garden

Use your Internet Explorer web browser to access the web pages to view or to print the available reports.

Accessing the Reporting Pages Interface

Use the following procedure to access the Reporting pages.

Step 1 For a multisite configuration, click the drop-down arrow on the BBSM Dashboard to select a site.

Step 2 Click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.)

Step 3 To request a report, click an option from the top of the BBSM Reporting web page. (See Figure 7-1.)

Figure 7-1 Building Broadband Service Manager Reporting Web Page

Once a report web page appears, you can sort the report by clicking on the underlined item in the header (light purple) button for any column. Clicking the same heading again switches between ascending and descending order. The sorting capability applies to all reports.

Usage Reports

Usage reports allow authorized personnel to study the use of the Internet facilities at the site. Figure 7-2 shows an example of the Usage Report web page for a site.

Figure 7-2 Usage Report Options

You can request three different reports from the Usage web page.

•Usage By Year

•Usage By Month

•Usage By Day

Usage Reports Calendar Day Offset

Charges posted to a PMS often do not correspond to calendar day boundaries. For example, if a hotel sends its PMS data to its data processing department at 4 a.m. each day, the charges posted will include data from the previous day after 4 a.m. up to the current day at 4 a.m. The calendar day offset feature makes it easier to reconcile BBSM accounting records with PMS records. Using the calendar day offset features, you can also choose to align the day boundaries with the checkout time at a site.

When requested, usage reports can provide reporting information for viewing by a calendar day offset. The calendar day offset can show data either from noon until noon or from a specified start time (24-hour period). Figure 7-3 shows an example of these two ways of displaying data as it occurs on 04/09/2001.

Figure 7-3 Calendar Day Offset Data Options

Usage By Year Report

The Usage By Year report lists a yearly summary of usage activity. Use the following procedure to view the report.

Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.)

Step 2 Click Usage. The Usage Report Options web page appears.

Step 3 To access the usage reports, choose one of these options:

•From the secondary navigation bar, click Usage By Year.

•From the Report Type drop-down menu, select Usage By Year.

The usage report appears. (Figure 7-4 shows an example Usage By Year usage report.)

Figure 7-4 Usage By Year Report

Step 4 If desired, use the Calendar Day Offset option to indicate the boundary of a day for reporting purposes. Typically, you set this to match the billing cycle of a hotel PMS system.

Step 5 To view the report, click Get Usage Report.

Usage By Month Report

The Usage by Month report lists the monthly activity for a specific year. Use the following procedure to view the report.

Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.)

Step 2 Click Usage. The Usage Report Options web page appears.

Step 3 To access the usage reports, choose one of these options:

•From the secondary navigation bar, click Usage By Month.

•From the Usage By Year report, click the number of the desired year to see the monthly usage for that year.

The usage report appears. (Figure 7-5 shows an example Usage By Month usage report.)

Figure 7-5 Usage By Month Report

Step 4 If desired, use the Calendar Day Offset to indicate the boundary of a day for reporting purposes. Typically, you set this to match the billing cycle of a hotel PMS system.

Step 5 To view the report, click Get Usage Report.

Usage by Day Report

The Usage by Day report lists all the usage days for the specified month. Use the following procedure to view the Usage By Day report.

Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.)

Step 2 Click Usage. The Usage Report Options web page appears.

Step 3 To access the usage reports, choose one of these options:

•From the secondary navigation bar, click Usage By Day.

•From the Usage By Month report, click the name of a month to see the daily usage for that month.

The usage report appears. (Figure 7-6 shows an example Usage By Day usage report.)

Figure 7-6 Usage By Day Report

Step 4 If desired, use the Calendar Day Offset to indicate the boundary of a day for reporting purposes. Typically, you set this to match the billing cycle of a hotel PMS system.

Step 5 To view the report, click Get Usage Report.

Transaction History Report

The Transaction History report lists one line per transaction showing the date/time, transaction type, IP address, previous status, new status, amount, port ID, MAC, room, duration, and bandwidth KBPS. shows an example of the report. Use the following procedure to view the report.

Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.)

Step 2 Click Transaction History. The Transaction History web page appears. (See Figure 7-7.)

Figure 7-7 Transaction History Report

Step 3 From the Start Date drop-down menu, select the desired start date for the report.

Step 4 From the End Date drop-down menu, select the desired end date for the report.

Step 5 Click Requery to view the results.

Active Ports Report

The Active Ports report shows the rooms that are connected to BBSM at the time the report is produced. Use the following procedure to view the Active Ports report.

Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.)

Step 2 Click Active Ports. The Active Ports web page appears. (See Figure 7-8.)

Figure 7-8 Active Ports Reports

Step 3 Click a column heading to sort the data in ascending or descending order.

Access Code Reports

Access Code reports list current, unused, and expired access codes. The following are the three access code report options:

•Access Code Report

•Unused Code Report

•Access Code History

Access Code Report

The Access Code report shows the current access codes assigned to a customer. Use the following procedure to view the Access Code report.

Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.)

Step 2 Click Access Codes. The Access Code Report web page appears. (See Figure 7-9.)

Figure 7-9 Access Code Report Web Page

Step 3 From the Customer Name drop-down menu, select the desired Customer Name.

Step 4 From the Codes Valid From drop-down menu, select the desired date.

Step 5 From the Codes Valid To drop-down menu, select the desired date.

Step 6 To view the report, click View Access Codes.

Unused Code Report

The Unused Code Report shows the unused access codes assigned to a customer. Use the following procedure to view the Unused Code report.

Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.)

Step 2 Click Access Codes. The Access Code Report web page appears. (See Figure 7-9.)

Step 3 Click Unused Code Report. The Unused Code Report appears. (See Figure 7-10.)

Figure 7-10 Unused Access Code Report Web Page

Step 4 From the Select Customer Name drop-down menu, select the desired customer.

Step 5 To view the report, click Find Codes.

Access Code History Report

The Access Code History report shows the access codes that have expired. Use the following procedure to view the report.

Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.)

Step 2 Click Access Codes. The Access Code Report web page appears. (See Figure 7-9.)

Step 3 Click Access Code History. The Access Code History web page appears. (See Figure 7-11.)

Figure 7-11 Access Code History Report Web Page

Step 4 From the Report Type drop-down menu, select the desired report type: Detailed or Summary.

Step 5 From the Customer Name drop-down menu, select the desired customer name.

Step 6 From the Codes Used On or After drop-down menu, select the start date.

Step 7 From the Codes Used Before drop-down menu, select the desired end date.

Step 8 To view the report, click Generate Report.

Room Mappings Report

The Room Mappings report lists room numbers with their corresponding port numbers and port configuration information. There are two options available from the secondary navigation bar:

•View List—Shows a complete list of mappings

•Edit Record—Allows you to change a selected record

Room Mappings View List

The View List option lists the room numbers and their associated port IDs. Use the following procedure to view the Room Mappings report.

Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.)

Step 2 Click Room Mappings. The View List of the Room Mappings report web page appears. (See Figure 7-12.)

Figure 7-12 Room Mappings Report

Step 3 To sort the data in ascending or descending order, click a column heading.

Room Mappings Edit Record

The Room Mappings Input Form allows you to edit data for an individual entry on the Room Mapping list. Note that administrator or operator privileges are required to view and use this form. Use the following procedure to edit the Room Mappings Input Form.

Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.)

Step 2 Click Room Mappings. The View List of the Room Mappings report web page appears. (See Figure 7-12.)

Step 3 From the Room column, select a room number.

Step 4 Do one of the following.

•From the secondary navigation bar, click Edit Record.

•Select a Port ID entry.

The Room Mappings Input Form web page appears. (See Figure 7-13.)

Figure 7-13 Room Mappings Input Form

Step 5 Enter changes as necessary.

Step 6 To save the changes, click Update.

Step 7 To return to the View List of the Room Mappings report, click Return.

RADIUS Report

The RADIUS report provides a history of all RADIUS sessions based on either a particular RADIUS server or user. Use the following procedure to view the report.

Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting web page appears.

Step 2 Click RADIUS. The RADIUS Session History web page appears. (See Figure 7-14.)

Figure 7-14 RADIUS Session History Options Web Page

Step 3 From one of the following drop-down menus, select the desired search criteria:

•RADIUS Server

•Customer Name

Step 4 From the Start Date drop-down menu, select the desired report start date.

Step 5 From the End Date drop-down menu, select the desired report end date.

Step 6 Click View RADIUS Report. The RADIUS Session report appears. (See Figure 7-15.)

Figure 7-15 RADIUS Session History Report

Walled Garden Report

The Walled Garden report displays all of the current walled garden configurations that you created using the Walled Garden web page of WEBconfig. Figure 7-16 shows an example of the report.

Use the following procedure to view the Walled Garden report.

Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.)

Step 2 Click Walled Garden. The Walled Garden report web page appears. (See Figure 7-1.)

Figure 7-16 Walled Garden Report

Step 3 To sort the data in ascending or descending order, click a column heading.

	Cisco BBSM 5.1 Software Configuration Guide
	7 - Viewing and Printing BBSM Reports
Cisco BBSM 5.1 Software Configuration Guide Cisco BBSM Software Configuration Guide Preface 1 - Overview 2 - Preconfiguration and Setup 3 - Basic BBSM Configuration (WEBconfig) 4 - Testing the PMS Interface (WEB PMS Test) 5 - Installing Service Packs, Patches, and Upgrades (WEBpatch) 6 - BBSM Operations 7 - Viewing and Printing BBSM Reports 8 - Customizing Your BBSM System 9 - Web Printing A - BBSM Basics B - Accessing the Dashboard C - Installing an SSL Certificate D - Using RADIUS Authentication, Authorization, and Accounting E - Understanding Port Hopping F - BBSD Feature G - Configuring a Laptop for Room Mapping Glossary Index	Download this chapter 7 - Viewing and Printing BBSM Reports Table Of Contents Viewing and Printing BBSM Reports Accessing the Reporting Pages Interface Usage Reports Usage Reports Calendar Day Offset Usage By Year Report Usage By Month Report Usage by Day Report Transaction History Report Active Ports Report Access Code Reports Access Code Report Unused Code Report Access Code History Report Room Mappings Report Room Mappings View List Room Mappings Edit Record RADIUS Report Walled Garden Report Viewing and Printing BBSM Reports Reports of BBSM activities and functions can be viewed and printed on a site basis by using the Reporting Pages option under the Reports section of the BBSM Dashboard. The following are the reports you can select: •Usage •Transaction History •Active Ports •Access Codes •Room Mappings •RADIUS •Walled Garden Use your Internet Explorer web browser to access the web pages to view or to print the available reports. Accessing the Reporting Pages Interface Use the following procedure to access the Reporting pages. Step 1 For a multisite configuration, click the drop-down arrow on the BBSM Dashboard to select a site. Step 2 Click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.) Step 3 To request a report, click an option from the top of the BBSM Reporting web page. (See Figure 7-1.) Figure 7-1 Building Broadband Service Manager Reporting Web Page Once a report web page appears, you can sort the report by clicking on the underlined item in the header (light purple) button for any column. Clicking the same heading again switches between ascending and descending order. The sorting capability applies to all reports. Usage Reports Usage reports allow authorized personnel to study the use of the Internet facilities at the site. Figure 7-2 shows an example of the Usage Report web page for a site. Figure 7-2 Usage Report Options You can request three different reports from the Usage web page. •Usage By Year •Usage By Month •Usage By Day Usage Reports Calendar Day Offset Charges posted to a PMS often do not correspond to calendar day boundaries. For example, if a hotel sends its PMS data to its data processing department at 4 a.m. each day, the charges posted will include data from the previous day after 4 a.m. up to the current day at 4 a.m. The calendar day offset feature makes it easier to reconcile BBSM accounting records with PMS records. Using the calendar day offset features, you can also choose to align the day boundaries with the checkout time at a site. When requested, usage reports can provide reporting information for viewing by a calendar day offset. The calendar day offset can show data either from noon until noon or from a specified start time (24-hour period). Figure 7-3 shows an example of these two ways of displaying data as it occurs on 04/09/2001. Figure 7-3 Calendar Day Offset Data Options Usage By Year Report The Usage By Year report lists a yearly summary of usage activity. Use the following procedure to view the report. Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.) Step 2 Click Usage. The Usage Report Options web page appears. Step 3 To access the usage reports, choose one of these options: •From the secondary navigation bar, click Usage By Year. •From the Report Type drop-down menu, select Usage By Year. The usage report appears. (Figure 7-4 shows an example Usage By Year usage report.) Figure 7-4 Usage By Year Report Step 4 If desired, use the Calendar Day Offset option to indicate the boundary of a day for reporting purposes. Typically, you set this to match the billing cycle of a hotel PMS system. Step 5 To view the report, click Get Usage Report. Usage By Month Report The Usage by Month report lists the monthly activity for a specific year. Use the following procedure to view the report. Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.) Step 2 Click Usage. The Usage Report Options web page appears. Step 3 To access the usage reports, choose one of these options: •From the secondary navigation bar, click Usage By Month. •From the Usage By Year report, click the number of the desired year to see the monthly usage for that year. The usage report appears. (Figure 7-5 shows an example Usage By Month usage report.) Figure 7-5 Usage By Month Report Step 4 If desired, use the Calendar Day Offset to indicate the boundary of a day for reporting purposes. Typically, you set this to match the billing cycle of a hotel PMS system. Step 5 To view the report, click Get Usage Report. Usage by Day Report The Usage by Day report lists all the usage days for the specified month. Use the following procedure to view the Usage By Day report. Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.) Step 2 Click Usage. The Usage Report Options web page appears. Step 3 To access the usage reports, choose one of these options: •From the secondary navigation bar, click Usage By Day. •From the Usage By Month report, click the name of a month to see the daily usage for that month. The usage report appears. (Figure 7-6 shows an example Usage By Day usage report.) Figure 7-6 Usage By Day Report Step 4 If desired, use the Calendar Day Offset to indicate the boundary of a day for reporting purposes. Typically, you set this to match the billing cycle of a hotel PMS system. Step 5 To view the report, click Get Usage Report. Transaction History Report The Transaction History report lists one line per transaction showing the date/time, transaction type, IP address, previous status, new status, amount, port ID, MAC, room, duration, and bandwidth KBPS. shows an example of the report. Use the following procedure to view the report. Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.) Step 2 Click Transaction History. The Transaction History web page appears. (See Figure 7-7.) Figure 7-7 Transaction History Report Step 3 From the Start Date drop-down menu, select the desired start date for the report. Step 4 From the End Date drop-down menu, select the desired end date for the report. Step 5 Click Requery to view the results. Active Ports Report The Active Ports report shows the rooms that are connected to BBSM at the time the report is produced. Use the following procedure to view the Active Ports report. Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.) Step 2 Click Active Ports. The Active Ports web page appears. (See Figure 7-8.) Figure 7-8 Active Ports Reports Step 3 Click a column heading to sort the data in ascending or descending order. Access Code Reports Access Code reports list current, unused, and expired access codes. The following are the three access code report options: •Access Code Report •Unused Code Report •Access Code History Access Code Report The Access Code report shows the current access codes assigned to a customer. Use the following procedure to view the Access Code report. Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.) Step 2 Click Access Codes. The Access Code Report web page appears. (See Figure 7-9.) Figure 7-9 Access Code Report Web Page Step 3 From the Customer Name drop-down menu, select the desired Customer Name. Step 4 From the Codes Valid From drop-down menu, select the desired date. Step 5 From the Codes Valid To drop-down menu, select the desired date. Step 6 To view the report, click View Access Codes. Unused Code Report The Unused Code Report shows the unused access codes assigned to a customer. Use the following procedure to view the Unused Code report. Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.) Step 2 Click Access Codes. The Access Code Report web page appears. (See Figure 7-9.) Step 3 Click Unused Code Report. The Unused Code Report appears. (See Figure 7-10.) Figure 7-10 Unused Access Code Report Web Page Step 4 From the Select Customer Name drop-down menu, select the desired customer. Step 5 To view the report, click Find Codes. Access Code History Report The Access Code History report shows the access codes that have expired. Use the following procedure to view the report. Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.) Step 2 Click Access Codes. The Access Code Report web page appears. (See Figure 7-9.) Step 3 Click Access Code History. The Access Code History web page appears. (See Figure 7-11.) Figure 7-11 Access Code History Report Web Page Step 4 From the Report Type drop-down menu, select the desired report type: Detailed or Summary. Step 5 From the Customer Name drop-down menu, select the desired customer name. Step 6 From the Codes Used On or After drop-down menu, select the start date. Step 7 From the Codes Used Before drop-down menu, select the desired end date. Step 8 To view the report, click Generate Report. Room Mappings Report The Room Mappings report lists room numbers with their corresponding port numbers and port configuration information. There are two options available from the secondary navigation bar: •View List—Shows a complete list of mappings •Edit Record—Allows you to change a selected record Room Mappings View List The View List option lists the room numbers and their associated port IDs. Use the following procedure to view the Room Mappings report. Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.) Step 2 Click Room Mappings. The View List of the Room Mappings report web page appears. (See Figure 7-12.) Figure 7-12 Room Mappings Report Step 3 To sort the data in ascending or descending order, click a column heading. Room Mappings Edit Record The Room Mappings Input Form allows you to edit data for an individual entry on the Room Mapping list. Note that administrator or operator privileges are required to view and use this form. Use the following procedure to edit the Room Mappings Input Form. Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.) Step 2 Click Room Mappings. The View List of the Room Mappings report web page appears. (See Figure 7-12.) Step 3 From the Room column, select a room number. Step 4 Do one of the following. •From the secondary navigation bar, click Edit Record. •Select a Port ID entry. The Room Mappings Input Form web page appears. (See Figure 7-13.) Figure 7-13 Room Mappings Input Form Step 5 Enter changes as necessary. Step 6 To save the changes, click Update. Step 7 To return to the View List of the Room Mappings report, click Return. RADIUS Report The RADIUS report provides a history of all RADIUS sessions based on either a particular RADIUS server or user. Use the following procedure to view the report. Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting web page appears. Step 2 Click RADIUS. The RADIUS Session History web page appears. (See Figure 7-14.) Figure 7-14 RADIUS Session History Options Web Page Step 3 From one of the following drop-down menus, select the desired search criteria: •RADIUS Server •Customer Name Step 4 From the Start Date drop-down menu, select the desired report start date. Step 5 From the End Date drop-down menu, select the desired report end date. Step 6 Click View RADIUS Report. The RADIUS Session report appears. (See Figure 7-15.) Figure 7-15 RADIUS Session History Report Walled Garden Report The Walled Garden report displays all of the current walled garden configurations that you created using the Walled Garden web page of WEBconfig. Figure 7-16 shows an example of the report. Use the following procedure to view the Walled Garden report. Step 1 From the BBSM Dashboard, click Reporting Pages. The Reporting splash screen appears, followed by the BBSM Reporting web page. (You can click the splash screen to skip it.) Step 2 Click Walled Garden. The Walled Garden report web page appears. (See Figure 7-1.) Figure 7-16 Walled Garden Report Step 3 To sort the data in ascending or descending order, click a column heading.
	© 1992-2009 Cisco Systems, Inc. All rights reserved. Terms & Conditions \| Privacy Statement \| Cookie Policy \| Trademarks of Cisco Systems, Inc.