SANscreen DWH Switch Port Report

salalonde — Thu, 05 Jun 2025 06:52:43 GMT

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

SANscreen DWH Switch Port Report

moechnig — Mon, 20 Jun 2011 19:10:18 GMT

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.

topic SANscreen DWH Switch Port Report in Active IQ Unified Manager Discussions

SANscreen DWH Switch Port Report

SANscreen DWH Switch Port Report