Active IQ Unified Manager Discussions

SANscreen DWH Switch Port Report

salalonde

I would like to make a simple report as follows:

Data Center, Switch Name, Blade, (Port) Number, Connected to Name

I can find:

Data Center, Switch Name, Blade, (Port) Number

In the Inventory data mart, but not Connected to Name.

I can find:

Data Center, Switch Name, Connected to Name

In the Port Capacity data mart, but not Blade and Port Number.

Am I missing something?  Is there somewhere I can have it all?  I might like to include the Application and BU of the host as well.

Thanks,

Sam

1 REPLY 1

moechnig

I've managed to perform the query you're looking for.  I joined through the port_connectivity table.  The necessary where clause will look something like this:

switch_port.ID = port_connectivity.portID and

port_connectivity.type = "SWITCH_PORT" and

port_connectivity.connectedType = "HOST_PORT" and

port_connectivity.connectedID = host_port.ID and

host_port.hostID = host.ID

You should be able to get from that host.ID to the application and BU annotations via the object_to_annotation and annotation_value tables. 

Note that I'm using SQL directly to the Inventory data mart; translating this to work in the GUI I'll leave to you. 

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

Public