7 Replies Latest reply on Feb 20, 2014 2:42 PM by c.gura

    What Resources are defined for a Node?

    c.gura

      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

        • Re: What Resources are defined for a Node?
          zackm

          are you looking specifically for resources that can only be applied to nodes?

           

          select resourceid, resourcename, resourcefile from resources where resourcefile like '%node%' order by resourcefile
          

           

           

          that's probably a good starting point

            • Re: What Resources are defined for a Node?
              c.gura

              I would like to know what resources are defined for a specific node id.   So I have NodeID = 1  and I want to know which Resources are being monitored for that node.

                • Re: What Resources are defined for a Node?
                  stuartwhyte

                  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

                    • Re: What Resources are defined for a Node?
                      zackm

                      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

                        • Re: What Resources are defined for a Node?
                          c.gura

                          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? 

                            • Re: What Resources are defined for a Node?
                              stuartwhyte

                              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

                                • Re: What Resources are defined for a Node?
                                  c.gura

                                  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?