Reports

This portlet’s summary screen lists the available reports that you can run with Open Manage Network Manager.The report Icon, Name, Template, and Subtitle appear in the columns in this summary screen. Generally speaking, the report selects the target equipment, and the template configures the layout and attributes reported. If the Interface details panel is empty, then the Interface reports will have no contents. Some devices have ports, but no interfaces. Use the Ports report for such devices.

Open Manage Network Manager generates reports with only the first 5,000 records by default. Larger reports warn that they have reached the maximum, and have only those first 5,000 records.

You can change the maximum with the property com.dorado.red­cell.re­ports.max.re­port.query.size=5000

Larger numbers have an impact on the performance of the report and database.

You must have Adobe’s Acrobat reader installed to view reports.

Right-click a selected report to do the following:

New / Edit / Copy  -- This opens the Report Editor, described below, to configure a new report, edit or copy an existing, selected report. Copy automatically renames the selected report.

New Group --  Creates a collection of reports. See Group Reports for details about how to configure these.

Schedule --  Opens a scheduler screen to automate report creation.

Execute Report --  When you execute a report, a numbered message notification appears, and a link to the report appears in the Messages panel to notify you the report is ready for viewing. Click the magnifying glass to the right of the notification to view either the audit trail or the report.

Lengthy Reports may take a some time to appear onscreen without much indication that they are in process. This is an artifact of the Acrobat plug-in, and outside the scope of Open Manage Network Manager to influence. Acrobat also produces an error if a report has too much data to display meaningfully.

Execute Report (Advanced) -- Also lets you schedule configure a few other things with reports. When you View or Execute Report (Advanced), by right clicking either a listed report or a historical instance of that report, a configuration screen appears that lets you select several parameters.

These include the following:

Report Email / Export Type -- Select the export file type from the pick list. Options include CSV, HTML, PDF, XLS, and XLSM.

Programs other than Open Manage Network Manager let you manipulate mail outside the scope of Open Manage Network Manager. For example IFTTT (If This Then That) could save mail attachments like reports to Dropbox accounts.

Overwrite Existing -- Check to activate overwriting any existing report.

Save -- Check to activate saving the report to the database.

Notify -- Check to activate emitting a notification event.

Email Address -- Enter an e-mail destination for the generated report, and click the plus (+) to list it. You can enter several such e-mails.

Export Directory -- Enter directory destinations for saved reports as you would e-mail destinations.x

Click Add Schedule to schedule the report for future or repeated execution, Execute to run the report immediately, or Save to preserve this report’s configuration. The Job Viewer tab displays the report’s progress if you click Execute.

Reports can be large. Typically the limitations on e-mail within your system are what limit the size of deliverable reports. Best practice is to use filters and a limited number of targets to make reports succinct rather than comprehensive.

Aging Policy -- If you automate report generation, you may also want to configure a Database Aging Policy to insure the volume of reports does not overwhelm your storage capacity. See Redcell > Database Aging Policies (DAP) for more about doing that.

Delete -- Removes the selected report from the list display

Delete History --  Removes the selected report’s history.

To change reports’ appearance and contents, you must configure their Report Templates. Also, see Branding Reports for instructions about changing the default report logo.

 

Expanded Reports Portlet

Clicking the plus (+) icon displays the expanded portlet. the expanded portlet adds Add / Remove Column to the menu options available in the summary screen.Available columns are the same as the summary screen’s. The Reference Tree snap panel displays the selected report’s connection to devices, historical reports and any report template. Right-click to view the reports in the Historical Reports node.

Reports Snap Panels

The Snap Panels for reports display a Reference Tree of connections between the selected report and target equipment, and between the report and any Report Template.

The Report History Snap Panel displays the selected report’s Run Date, Row Count and the User who ran the report. Right-click a row in this panel, and you can Delete, Print (the report history) or Export (the report history), View (the report) or View (Advanced). If you View the report, a message with a link to the report appears in the bottom left of the screen.

Generate a Report

The following steps configure, then generate, a report.

1. In the Reports portlet, right-click and select New.

2. Name the report (for example: Test Juniper Router Report)

3. Enter a title / subtitle for the report (“Juniper Routers”)

4. Select a template for the report in the pick list. (For example, the template configured in How to: Create a Report Template.)

If you create a template, the first report you create after making that template automatically selects the newly created template.

5. In the Filters tab, you can create a filter to confine the reports input to certain devices, locations, and so on. (Here, select the existing All Juniper Routers filter)

6. Click Save.

7. Locate the newly created report in the Reports portlet.

8. Right-click and select Execute.

9. Click the My Alerts panel in the lower left corner of the portal.

10. Click the magnifying glass icon to the right of the Report is now ready for viewing message.

11. The report appears onscreen.

12. Hover your cursor over the lower right corner of the report to see a set of icons that let you expand, zoom out and in, save, or print the report.

For an example of a standard system report, see User Login Report.