I need help locating the following aspects in SWQL Studio

Question

Kevin (KMSigma) suggested I move this to a separate thread...

I know where to find the Volume Utilisation section in SWQL Studio but I am struggling with identifying the rest That said, I think the top one is here: "Orion.HardwareHealth.HardwareCategoryStatus".

Purpose: the main aim here is so that I can learn to play (safely in our LAB environment) and understand how to manipulate these sections via simple SWQL queries so that I can add / delete / etc them directly without troubling the SolarWinds GUI.

stuartd · Answer

[quote userid="2109" url="~/product-forums/the-orion-platform/f/orion-sdk/91508/i-need-help-locating-the-following-aspects-in-swql-studio/291447#291447"] If you'd like to send me some of your gear to use in my own lab, I'm sure I could be of more assistance.[/quote]LOL ....

Thanks Kevin - really appreciate your knowledge and insights here.

So method of attack here is to understand the pollers first and then I'll go a hunting and digging with the hardware health side.

KMSigma.SWI · Answer

If you are looking to add/delete these, they are in the Orion.Pollers entity.

Here's an example of a node's resources:

And the associated entries from Orion.Pollers:

This particular entity (by it's nature) doesn't have a Navigation Property, so you'll need to 'connect' it with other entities using a traditional JOIN clause with an added filter for the NetObjectType.

SELECT [Node].NodeID
     , [Node].ObjectSubType
     , [Node].IPAddress
     , [Node].Caption
     , [Poller].PollerID
     , [Poller].PollerType
     , [Poller].Enabled
     , [Poller].Uri
FROM Orion.Nodes AS [Node]
INNER JOIN Orion.Pollers AS [Poller]
  ON [Node].NodeID = [Poller].NetObjectID
 AND [Poller].NetObjectType = 'N' -- This indicates that we are looking for 'node' level pollers
WHERE [Poller].Enabled = 'TRUE'

Hardware Health is handled by a different entity.

There are four verbs available in the Orion.HardwareHealth.HardwareInfo entity to handle most work you'd need to do here.  Unfortunately, I don't have any gear in my home lab that has anything that supports hardware polling (it's nearly all virtualized).  That means I don't have good examples of the data to show.  If you'd like to send me some of your gear to use in my own lab, I'm sure I could be of more assistance.