In the Report Explorer, right-click the
template under , then select .The Edit Report Template dialog box is displayed.
Click the
tab, select a filter or group to use when you generate reports based on this template.Click the Section 5.4, View Customization
tab and select a view. Use the buttons adjacent to the list to add or edit a view. SeeClick the Field Filter Tab.
tab. Use the drop-down lists to specify query parameters. SeeClick
.In the Report Explorer, right-click
and select .Schedule the report for
, and accept the default of the .Click
.The report instance, shown as the date and time the report was generated, is displayed under the report template in the Report Explorer and the report is previewed in the Document Viewer, showing the servers that meet your consolidation requirements.
In the Report Explorer, right-click the
report template for Hardware Utilization - Peak and select on the menu.The Edit Report Template dialog box is displayed.
On the Step 1.
tab, make the same selection you made inOn the
tab, select the table view and click .The Create View dialog box is displayed.
On the
tab, select the (applied to columns containing calculated data) you want to create in the report.Click
.The Edit Report Template dialog box is displayed again.
On the
tab, set the date and time range to view utilization expressions for all servers that were monitored.On the Step 1.
tab, use the drop-down lists to specify the same query parameters you selected inOn the
tab, select .Click the
drop-down list and a type:Average: Average of all hourly values across business days and business hours.
Peak Hour: A calculation based on the highest hourly value.
Total: Sums all the data points in the time frame. For example, Disk IOs per second for a 1-hour period equates to 10 disk IOs per second X 60 seconds X 60 minutes = 36000. Select the
to create in the report of the columns containing calculated data.Click
.In the Report Explorer, under Analysis, right-click the previously edited Hardware Utilization - Peak report template and click
on the menu. Accept the default of the .Click
.The report instance, shown as the date and time the report was generated, is displayed under the report template in the Report Explorer and the report is previewed in the Document Viewer.
Comparing and contrasting the two reports generated in Step 1 and Step 1 will help you determine your consolidation needs.
To help with this, while viewing a generated report, click a cell to display a customizable chart for that server/workload metric. For more information see Section 5.1, Chart Viewer.