HP Network Direr Software Products manual Choose to Place chart As new sheet and click Finish

Examples 469

3Select the History tab of the Reports dialog box and select the generated report in the table.

4Click Save to CSV and choose a location for the CSV file.

5Open the saved file in Microsoft Excel.

6Select the IP Address column, by drag-clicking the cell entry with the column title IP Address all the way down to the end of the IP Address data.

7Holding down Ctrl, do the same with the Total Ports and Ports Available columns.

8Select Chart from the Insert menu.

9Use the defaults of Chart Type: Column and Subtype: Clustered Column and click Next.

10Click Next on the Chart Source Data wizard step.

11Click on the Titles tab on this wizard step, enter Network Capacity as the chart title and click Next.

12Choose to Place chart As new sheet and click Finish.

This gives you a graph showing at a glance how many ports you have free across your range of 3Com devices and where the servers could be best connected. You can also use Excel’s sorting feature to sort the table data by Ports Available, for example.

Ensuring Stacks are 3Com recommends that all units in a stack are running the same agent Running the Same version to avoid performance issues. You can generate a report providing

Agent Version this information using the Custom Report Types feature. To do this:

1Launch the Reports dialog box from Tools > Reports.

2Click Custom Type Reports.

3Click Add to create a new custom report type.

4Select the columns you wish to view in your custom report. Device name is already an included column. Select any combination of the following columns and add them to the report:

■Device type

■IP address

■Number of units

■Agent version