User's Manual

Examples 469
3 Select the History tab of the Reports dialog box and select the generated
report in the table.
4 Click Save to CSV and choose a location for the CSV file.
5 Open the saved file in Microsoft Excel.
6 Select 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.
7 Holding down Ctrl, do the same with the Total Ports and Ports Available
columns.
8 Select Chart from the Insert menu.
9 Use the defaults of Chart Type: Column and Subtype: Clustered Column
and click Next.
10 Click Next on the Chart Source Data wizard step.
11 Click on the Titles tab on this wizard step, enter Network Capacity as the
chart title and click Next.
12 Choose 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
Running the Same
Agent Version
3Com recommends that all units in a stack are running the same agent
version to avoid performance issues. You can generate a report providing
this information using the Custom Report Types feature. To do this:
1 Launch the Reports dialog box from Tools > Reports.
2 Click Custom Type Reports.
3 Click Add to create a new custom report type.
4 Select 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