This chapter provides information about CSV file format BAT reports that you can generate. You can customize BAT reports for phones and user device profiles but reports for users, managers, assistants, and gateways have a fixed format and can not be customized.
Cisco Unified Communications Manager Bulk Administration (BAT) provides reports to help you manage records effectively. You can create and save reports that provide information about phones, users, user device profiles, managers and assistants, and gateway records. You can save these reports with a filename and store them in a folder on the first node server to review and print.
You can customize BAT reports for phones and for user device profiles to meet your particular needs by choosing items from a list of device fields and line fields. You can also choose how to arrange the fields in the report. The system generates the report in the CSV file format. Because reports for users, managers, assistants, and gateways have a fixed format, you cannot customize them.
You need to have a list of all the directory numbers with their forwarding destinations by phone model. You can generate a Phone Report for the Cisco Unified IP Phone 7960 and choose these query details: Device Name, Directory Number, Forward Busy Destination, Forward No Answer Destination, and Label. You can arrange the report fields, so the Label field follows the Directory Number field and precedes the two forward destination numbers.
Generate phone reports
You can generate reports for phones and other IP telephony devices.
In the first Find Phone where drop-down list box, choose the field to query such as Model or Directory Number.
In the second drop-down list box, choose the search criteria such as begins with, contains, or is empty.
In the search field/list box, either choose or enter the value that you want to locate, such as the model name from the list or directory number range.
Specify the appropriate search text, if applicable, and click Find.
To generate a report for all phones that are registered in the database, click Find without entering any search text.
To further define your query and to add multiple filters, check the Search Within Results check box, choose AND or OR from the drop-down box, and repeat Steps Step 2 through Step 5.
A list of discovered phones displays.
To choose details for your type of report, click Next. The Generate Phone Report Configuration window displays and shows the Query that you chose.
If you want to change the type of query, click Back.
In the Report File Name field, enter your name for this report (required).
In the Available Device Fields drop-down list box, choose a device item and click the arrow to move the item into the Selected Fields for this Report list. You must specify at least one device field to generate a report. You can choose multiple fields to include in your report. For a list of device and live fields, see the Phone and IP telephony device reports.
To rearrange the order of the items in the Selected Device Fields for this Report list, choose an item and click the Up arrow or Down arrow to move the item to another position in the list.
In the Available Line Fields drop-down list box, choose a line item and click the arrow to move the item into the Selected Fields for this Report list. You must specify at least one line field to generate a report. You can choose multiple fields to include in your report.
To rearrange the order of the items in the Selected Line Fields for this Report list, choose an item and click the Up arrow or Down arrow to move the item to another position in the list.
If you want to include IP phone services fields in your report, check the check boxes for Speed Dial Services and/or IP Phone Services.
In the Job Information area, enter the Job description.
Choose when to generate the report. Do one of the following:
Click Run Immediately to generate the report immediately.
Click Run Later to generate the report at a later time.
To create a job for inserting the phone records, click Submit. Use the Job Configuration window to schedule and/or activate this job.
What to Do Next
You can search and download the report file using the Upload/Download Files option in the Bulk Administration menu.
BAT generates log files for each report transaction and stores them on the first node of Cisco Unified Communications Manager server. You can find a link to log files from the Job Configuration window for any job that generated a report. Click the link in the Log File Name column that corresponds to the job with the log file you want to view.