Working with reports

A Rack U-Space report can be generated to review the amount of available positions in specified racks. For equipment that takes up one or more U-positions a Contiguous Free U-Space report can be generated. For both reports the following applies:   The report will include data based on The filter selections Rooms Tags*   The calculations are based on equipment positioned in the rack layout and, if you have IT Advisor: Change installed, any equipment in pending state, even if it has not been added yet (Pending Add), or if it has been marked for deletion (Pending Delete), or to be moved (Pending Move).   The reports calculate the number of Front (free, used), Rear (free, used), Full Depth (free, used) u-positions. Front and Rear do not take the depth of equipment into consideration. This is done in the full-depth calculation.   *Tags included in this report are tags on racks. If more tags have been assigned to a rack, the rack will only be included in the report if all tags assigned to it have been selected in the report options.   102240483_360038496233.png

You can generate an Audit Trail report that lists actions recorded in the application, whether those actions were in response to work orders, or changes made to the data center model.   The Audit Trail report is available if you have IT Advisor: Change.   The Audit Trail report is available from Analytics > Reports. It can also be generated for individual components and racks in Operations > Data Center. Right-click a component or rack in the layout, and select Asset Audit.   102240412_360037994554.png

Use the Reports tool, accessed by clicking Analytics>Reports in the Application bar, to generate report data for any server room's floor or rack-mountable equipment, or for the contents of store rooms. At any time, you can generate reports from the application. The amount of available reports depends on your system setup, as some reports require specific module licenses. In addition to the overview reports generated from Analytics>Reports in the Application bar, asset inventory and audit reports can also be generated for individual components and racks by right-clicking a component or rack in the layout, and selecting Asset Inventory or Asset Audit (the audit report is available if you have IT Advisor: Change installed). 102240482_360038496713.png 123 Steps to... Generating a report You can generate various reports based on standard or customized report designs. From the Application bar, select Analytics>Reports. In All Reports View pane, select a report type from Available Reports. Use the Report Filter Options to define the filter for what data to include in the report, for example: Select the time range that you want the report to cover. Select the rooms that you want to include information about in the report. Select one or more tags if you want the report to only include information for specified equipment in specified room(s). TIP: You do not need to select these options every time you generate a report. You can save the selected options as a filter and apply the filter the next time you need to generate a report with the same filter options. Select Generate Report. The generated report displays in the Report View. You can now use the Report View toolbar to navigate the report pages on the screen (arrow icons), or to print or export the report to a file in any of the available formats (Export icon, down arrow for selection of format).  Currently, csv and xls export is not supported for reports containing graphs.

You can save the selected filter options as a template to generate reports with the same settings, for example, a monthly inventory report for a specific room. Creating a report filter template In Available Reports, select a report type. In Report Filter Options, select the data that you want to include when you generate a report based on these settings. Click Save Filter As... in the top right corner of the options section. Some data is required for certain report types. If you try to save without this data, you will be prompted to select the required options. In the Save dialog box, type a name for the report filter template. The saved report filter template now appears in the list of available reports as a sub type to the selected report type. Applying a previously saved report template In Available Reports, click the + symbol next to the report type to expand the list and see the available report filter templates. Select the report filter template to apply. You can now see the filter settings of the selected template. Select Generate Report. The generated report displays in the Report View. You can now use the Report View toolbar to navigate the report pages on the screen (arrow icons), or to print or export the report to a file in any of the available formats (Export icon, down arrow for selection of format).

The reports are localized into the supported languages according to the locale set on the server. However, the built-in report names in the list of Available Reports are only updated accordingly when you select to restore the default design. Click the arrow down icon, and select Restore Default Designs. 102240486_360037995774.png You can also specify the report name yourself. Changing the name of the available reports will only change the name in the list.  Right-click the report name in the list of Available Reports, select Rename, and type the new name.

An Energy Cost report can be generated to calculate the costs for running specified equipment used for charge back and efficient budgeting. The report will include data based on The filter selections Time period Rooms Tags* The entered kWh price The entered overhead factor 102240469_360038495753.png The system uses the best available data for the calculations. Measured load values: These values are used if the IT devices have been set up to report live measured data from an external monitoring system such as Data Center Expert server. Estimated load values from saved KPI data: These values are used if there is no measured data available and the system has been set up to save KPI data (Capacity History preferences). The saved KPI estimated load values result in a more accurate report than if only the present time estimated load is available. It allows for using the estimated load throughout the specified time period. Present time estimated load values: These values are used if there is no measured data or KPI data available in the system, or if the manufacturer's nameplate value is all that is available to the system, this is the value that will be used. The manufacturer's nameplate values are based purely on the manufacturer's nameplate of the specified equipment without taking any power loss into account. The overhead factor can be used to adjust the costs to real world power usage effectiveness (PUE). Any changes done during the specified time period will not be reflected in the report, which makes the report less accurate. For example, if you remove a piece of equipment in between the start and end date, its estimated load value will be completely left out of the calculations. If you add a piece of equipment in between the start and end date, its estimated load value will be included in the calculations as if it was in the solution throughout the entire time period. For information about the energy efficiency concepts, such as Power Usage Effectiveness (PUE), go to: the Green Grid and read the White Papers. WP-157: Selecting an Industry-Standard Metric for Data Center Efficiency WP-154: Electrical Efficiency Measurement for Data Centers WP-114: Implementing Energy Efficient Data Centers WP-113: Electrical Efficiency Modeling for Data Centers *Tags included in this report are tags on racks. If you include a piece of tagged rack-mounted equipment and select to include this tag in the report, it will not be included in the report calculation. Only if the rack that the piece of equipment is positioned in is tagged and selected for the report, it will be included.