This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

What Resources are defined for a Node?

How can I determine what Resource IDs are available to a Node from the Resources table?

Let me ask this a different way?  If I have a node,  Solarwinds defines how performance data can be collected, it then stores that information in some table which specifies the type of data to collect.  I would assume that table has a Resource ID associated to the collection definition so that it can then be displayed on the Orion Page of Widgets. 

Which table is that?

Message was edited by: Charles Gura

Parents Reply Children
  • This information is not stored in any one table.  You need to look at the Nodes table then join to the interfaces table and volumes table on NodeID.  Hardware resources are stored separately too.

    Hope this helps

    Stuart

  • nodes

    interfaces

    volumes

    apm_hardwareitem

    all can be joined on the NodeID

    if you have custom pollers (UnDPs) it can get a lot more complicated

  • Let me ask this a different way?  If I have a node,  Solarwinds defines how performance data can be collected, it then stores that information in some table which specifies the type of data to collect.  I would assume that table has a Resource ID associated to the collection definition so that it can then be displayed on the Orion Page of Widgets.  

    Which table is that? 

  • I'm still not sure I'm understanding your question, but if my answer above is not what you are looking for my other train of thought is you are asking about how things are displayed on the web page?  Each page is a "view" in the views table.  A view contains many resources (the widgets as you put it)  These are stored in the resources table with links the veiwid, the viewcolumn and position, and a reference to the resource file found in the filesystem (/orion/Netperfmon/Resources/ and sub directories) when they are added to the view.  The list of available resources are obtained from the above mentioned filesystem and cached when you run the website configuration wizard.

    As far as performance data goes, data about interfaces goes in the Interfaces table,  volumes in volumes table and cpu and response time in nodes table.

    Am I getting closer to what you are looking for?

    Stuart

  • Let me explain why I am asking:  We have a current Operator Portal that maintains our inventory of devices and deployments.  This database has devices stored in a table.   Each device has monitoring setup with our legacy monitoring system.  In there we have a table with different monitor types such as Interface monitoring, CPU/Memory/Disk monitoring.  There is a join table which has the device and all the different monitor types that can be collected for that device.  We also have another table which has graph definitions that are associated to the monitor types.

    So what I need is to try and determine how SolarWinds does this type of mapping.  The association that I have made is device table (Orion.Nodes), Graph Definitions table (Orion.Resources)  and Monitor Types  (Orion.XXXXXX)     Join Devices to Monitor Types (Orion.XXXXXXXX)

    Does this clarify things?