cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Allow UCS Power Supply and Fan Hardware Status on Main UCS Display

Allow UCS Power Supply and Fan Hardware Status on Main UCS Display

Currently the only way for the hardware status modules to be diplayed on the main UCS page is if the main UCS system is using the same IP as the fiber interconnect.  I currently am required to drill into the chassis to see the hardware status.  Since I am using redundant fiber interconnects using one IP is not an option.

5 Comments

If this looks ok to you then drop me a note and I'll send you the SWQL to use. Depending if your UCS are on their own node details page by MachineType, "Cisco" you will see this either for just them or on all your node detail pages. For that reason I made a new left-side navigation page and put these there. Benefit is when you are viewing the UCS manager page it will show you both FI statuses.

Its just as easy to list out chassis status as well with similar code.

Screen Shot 2014-07-03 at 11.47.46 PM.png

Level 8

This is wat I was looking for. Can you share the SWQL Please

Thanks

mileage may vary as SWQL custom queries are acting strange for me in core 2015.1

three resources and a forthcoming alert once I get it re-written.

UCS PSU or Fans Problems Resource

SELECT

n.caption as Node

, '/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a' + ToString(n.nodeid) AS [_LinkFor_Node]

, '/Orion/images/StatusIcons/Small-' + n.StatusLED AS [_IconFor_Node]

, p.Power

, p.Status

, p.Model

, p.Name FROM Orion.NPM.UCSPsus p

inner join Orion.npm.UCSFabrics u on p.parentid=u.id

inner join Orion.Nodes n on u.nodeid=n.nodeid

where p.parenttype = 1 and p.status <> 'operable'

UNION ALL

(

SELECT

n.caption as Node

, '/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a' + ToString(n.nodeid) AS [_LinkFor_Node]

, '/Orion/images/StatusIcons/Small-' + n.StatusLED AS [_IconFor_Node]

,f.Power

, f.Status

, f.Model

,f.Name FROM Orion.NPM.UCSfans f

inner join Orion.npm.UCSFabrics u on f.parentid=u.id

inner join Orion.Nodes n on u.nodeid=n.nodeid

where f.parenttype = 1 and f.status <> 'operable'

)

UCS Power Supplies

SELECT

n.caption as Node

, '/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a' + ToString(n.nodeid) AS [_LinkFor_Node]

, '/Orion/images/StatusIcons/Small-' + n.StatusLED AS [_IconFor_Node]

,'    ' + ToString(p.Name) as Name

, '/Orion/NPM/Images/UCS/psu.gif' AS [_IconFor_Name]

, p.Power

--,'Module' + ToString(p.Module) AS [Chassis Module]

, p.Status as State

FROM Orion.NPM.UCSPsus p

inner join Orion.npm.UCSFabrics f on p.parentid=f.id

inner join Orion.Nodes n on f.nodeid=n.nodeid

where parenttype = 1 and

(

hostnodeid = ${nodeid} or

f.nodeid = ${nodeid}

)

UCS Fans Resource

SELECT n.caption as Node

, '/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a' + ToString(n.nodeid) AS [_LinkFor_Node]

, '/Orion/images/StatusIcons/Small-' + n.StatusLED AS [_IconFor_Node]

,'    ' + ToString(p.Name) as Name

, '/Orion/NPM/Images/UCS/fan.gif' AS [_IconFor_Name]

--, p.Model

,'Module' + ToString(p.Module) AS [Chassis Module]

, p.Status as State

--,p.Power

FROM Orion.NPM.UCSfans p

inner join Orion.npm.UCSFabrics f on p.parentid=f.id

inner join Orion.Nodes n on f.nodeid=n.nodeid

where parenttype = 1 and

(

hostnodeid = ${nodeid} or

f.nodeid= ${nodeid}

)

Not sure why I retyped that - I forgot that and the alert was here:

Re: Cisco UCS | Advice on configuring alerts

Not sure that SQL:Select will work now in web-based alert console. Pull a power supply and let me know

Level 8

Works like a charm!!

I will remember you in my will and name my first born child after you.

Got any more SWQL to share. I am just learning here.

I have VMware, Hyper V and Windows servers that I need to setup hardware and storage monitoring.

Don