SOLVED: Display 3750 Stack member report on node summary page?

Physical Entity type of reports are from NCM if I'm not mistaken. Can you confirm how you tried or where you pulled that report?

I believe you are correct, but I found it on the Reports link under the Home tab.

The "Cisco 3750 Stacks" report was a custom report that I created.

I've also found that you can do the same with the 3850 as well, which is great as there is currently no stack info,

I've recently asked the question as I was after displaying the entities on the node, which i presume is the what you are trying to do? This for me was a better solution:

SELECT EntityID, EntityName, EntityDescription AS [Description], Serial, ContainedIn, EntityClass AS [Class], Position, HardwareRevision, FirmwareRevision, SoftwareRevision,  Manufacturer, Model, Alias, AssetID, FieldReplaceable,

NodeID, Nodes.NodeCaption

FROM NCM.EntityPhysical
INNER JOIN  NCM.Nodes ON EntityPhysical.NodeID =  Nodes.NodeID

WHERE Nodes.CoreNodeID = ${NodeID} AND EntityPhysical.EntityClass=3

Remove the bit in bold above if you want to show the whole lot otherwise it will displayed this:

Did you build this in the Orion Report Writer? If so, which type of report did you use to build it?

no on the node as a custom query, which you select choosing resources, let me know if you need more info

Woohoo! Thank you so much!

Is there a way to adjust the column widths, and what is the Field Replaceable column?

HI there

sorry we dont use 'field replaceable' column, we have removed it but its in the query as its in the table, remove them as you see fit. So far I haven't found a way of reducing the column widths, no doubt someone with SQL skills might be able to

No worries! Thank you so much for your help!

You're welcome