Reporting Manager is a powerful custom reporting tool which allow Administrators to use SQL database queries to generate reports from Cisco Communications Manager.
Browsing the Communications Manager Database:
- Log into Provisioning Manager as an Administrator
- Select Report Builder from the System menu
- Select a Service Group
- Search for a database table or select on from the list
- Click on the table name to view the table schema
- Click on either Custom Query or Visual Query to build a report (Visual Query will provide visual guidance constructing an SQL query)
- User Visual Query to build the desired query and click Run Query
- Provide a report name and title
- Select the Enable checkbox to enable the report for scheduling
- Click Save to save the report in the Report List
- Optionally click on Export CSV to export the result
Scheduling a Report
Any Report that has been enabled can be scheduled. To schedule a report:
- In the Reporting Manager menu select Schedule
- Click Add
- Select the Report
- Select the Frequency
- Set the Starting Date
- Set the run Time
- Set the Notification Email where the report will be delivered
- (Optional) Add an Email List
Post your comment on this topic.