Cloud Insights Data Warehouse Schema Diagrams

Contributors netapp-alavoie Download PDF of this page

This document provides the schema diagrams for the Data Warehouse Database. You can also download a file containing the schema tables.

The Reporting feature is available in Cloud Insights Premium Edition.

Inventory Datamart

The following images describe the inventory datamart.

Storage

storage

Storage Node

storage node

SAN Fabric

fabric

Port Connectivity

connectivity

VM

vm

NAS

nas

Paths and Violations

logical

Annotations

annotations

Applications

apps annot

Storage and Storage Pool Capacity

Storage and Storage Pool Capacity Fact

Volume Capacity

Volume Capacity

VM Capacity

VM Capacity Fact

Internal Volume Capacity

Internal Volume Capacity Fact

Qtree Capacity

Qtree Capacity Fact

Storage Capacity Efficiency

efficiency

Storage and Storage Pool Capacity

Storage and Storage Pool Capacity Fact

File System Utilization

fs util

Port Capacity

ports

Chargeback

Chargeback Fact

Disk Group Capacity

Disk Group Capacity

Performance Datamart

The following images describe the performance datamart.

Application Volume Hourly Performance

application performance fact

Internal Volume Hourly Performance

host performance fact

Internal Volume Hourly Performance

internal volume performance fact

Internal Volume Daily Performance

internal volume daily performance fact

Volume Hourly Performance

vmdk hourly performance fact

Volume Daily Performance

volume daily performance fact

Qtree Daily Performance

QtreeDailyPerformanceFact

Switch Hourly Performance for Host

switch performance for host hourly fact

Switch Hourly Performance for Port

switch performance for port hourly fact

Switch Hourly Performance for Storage

switch performance for storage hourly fact

Switch Hourly Performance for Tape

switch performance for tape hourly fact

VM Performance

vm hourly performance fact

VM Daily Performance for Host

vm daily performance fact

VM Hourly Performance for Host

vm hourly performance fact

VM Daily Performance for Host

vm daily performance fact

VM Hourly Performance for Host

vm hourly performance fact

VMDK Daily Performance

vmdk daily performance fact

VMDK Hourly Performance

vmdk hourly performance fact

Storage Node Hourly Performance

storage node hourly performance fact

Disk Daily Performance

disk daily performance fact

Disk Hourly Performance

disk hourly performance fact