Creating custom capacity and relationship reports

You can create custom reports that show capacity and relationship information for resources in the Cognos® Analytics reporting tool. Capacity and relationship reports can contain detailed information about the properties of monitored resources, and the available space and capacity of those resources. You access custom capacity and relationship reports from IBM Spectrum® Control, and you create the reports in the Cognos Analytics reporting tool.

Before you can create a custom report about capacity and relationships, ensure that data was collected from the resources. The following table shows where the data must be collected from for each resource:

Resource Prerequisite
Fabric Data must be collected from the fabric by a CIM agent or SNMP agent.
Switch Data must be collected from the switch by a CIM agent or SNMP agent.
Server

Data must be collected from the server by the Storage Resource agent, or by an agentless server.
Hypervisor Data must be collected from the VMware ESX server.
NAS Data must be collected from any NetApp or IBM® Scale Out Network Attached Storage resources that are in your storage environment.
Storage virtualizer Data must be collected from the any of the following storage virtualizers that are in your storage environment:
  • IBM Storage FlashSystem® family
  • Storwize® V7000
  • Storwize V7000 Unified
  • SAN Volume Controller
  • Hitachi Universal Storage Platform V
Storage system
Data must be collected from the storage system, or any of the following systems that are configured as back-end storage:
  • IBM Storage FlashSystem family
  • Storwize V7000
  • Storwize V7000 Unified
  • SAN Volume Controller
  • Hitachi Universal Storage Platform V
Restriction: If you create a custom report that includes properties from both Servers to Storage Systems and Fabrics and Switches, the relationships between resources are not displayed correctly.
Tip: Before you run a report, you can preview the report with no data.
  1. Go to the URL for your Cognos Analytics server. The format of the URL is similar to this URL: http://myhostname:9300/bi
  2. Depending on the type of report that you want to see, complete one of the following steps:
    • To create a basic report with limited formatting about the capacity and relationships of resources, complete the following steps:
      1. Click New Image shows the New icon. in the Welcome portal.
      2. Click Other, then click Query Studio.
      3. Click IBM Spectrum Control Packages‬, then click the Capacity and Relationships package.
    • To create a report about the capacity and relationships of resources and apply advanced formatting features to the report, complete the following steps:
      1. In the Welcome portal, click Team Content .
      2. Click IBM Spectrum Control Packages.
      3. Right-click Capacity and Relationships, then click Create report.
      4. Click a template for the report.
  3. Expand IBM Spectrum Control in the list of data sources.
  4. Expand Servers to Storage Systems or Fabrics and Switches in the list.
  5. Explore the folders in the list to locate the resources, properties, and statistics that you want to include in the report.
  6. Depending on your browser, do one of the following steps to add properties and statistics to the report:
    • In Internet Explorer, drag the items that you want to see information about to the work area.
    • In Firefox, select the items that you want to see information about, and then click Insert.
  7. Click Save.