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

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.

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

Thanks

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

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