17 Replies Latest reply on Aug 13, 2013 4:51 PM by tzotz

    Customizing the UnDP Summary Chart Bubble

    tzotz

      Hi,

       

      I created a number of UnDPs in NPM using the standard Orion Universal Device Poller utility , in all of them the returned value is transformed dividing it by 100 to yield a dd.dd formatted value (see picture labeled # 3 in the attached file),

       

      However, the UnDP summary display bubble shows (when hovering with the mouse) a truncated value (only dd) (please see picture labeled  # 2)

       

      The Top CPU by percent load (see picture #1) displays the bubble as I expected the #2 picture to do.

       

      What gives? How can I customize the bubble display,

       

      Thank for your help people.

        • Re: Customizing the UnDP Summary Chart Bubble
          zbynek.botlo

          Hi,

           

          To customize the chart tooltip little bit please use Universal Device Poller Custom Chart resource instead. Go to edit page of this resource and specify custom unit. Specifying custom unit will also override our default formatter which isn't working well in your case so you'll see the value as you want (not truncated).

           

          undp_custom_chart.png

          undp_custom_chart_final.png

            • Re: Customizing the UnDP Summary Chart Bubble
              tzotz

              A million thanks Zbynek,

              I'm new to SolarWinds Orion, so please pardon my, maybe trivial, question:

              I need to display a table summarizing the update status returned by the pollers for a node, something like the attached screen shot that was done using the Custom Summary Top Menu option, but I want to add it as part of a view so it would display for whatever node is chosen.

              Thanks again for your great help,

              Itzhak

               

              Date: Wed, 7 Aug 2013 02:57:44 -0500

              From: solarwindscommunityteam@communications.solarwinds.com

              To: tzotz@hotmail.com

              Subject: Re: - Customizing the UnDP Summary Chart Bubble

                                                                                              thwack

                                                       

               

                                                  

                                                  

                                                       

                  Customizing the UnDP Summary Chart Bubble

               

               

                  created by zbynek.botlo in Network Performance Monitor - View the full discussion

               

               

               

              Hi,

              To customize the chart tooltip little bit please use Universal Device Poller Custom Chart resource instead. Go to edit page of this resource and specify custom unit. Specifying custom unit will also override our default formatter which isn't working well in your case so you'll see the value as you want (not truncated).

                http://thwack.solarwinds.com/servlet/JiveServlet/downloadImage/2-208628-12167/450-377/undp_custom_chart.png

              http://thwack.solarwinds.com/servlet/JiveServlet/downloadImage/2-208628-12168/450-333/undp_custom_chart_final.png

               

               

               

                   Reply to this message by replying to this email -or- go to the message on thwack

                   Start a new discussion in Network Performance Monitor by email or at thwack

                • Re: Customizing the UnDP Summary Chart Bubble
                  zbynek.botlo

                  If you place the Universal Device Poller Status resource on some Node Details view you'll see pollers and it's values based on the currently selected node.

                    • Re: Customizing the UnDP Summary Chart Bubble
                      tzotz

                      Hi,

                      Thank you for your help,  BUT, and I'm sure I'm missing something here, if I take the Universal Device Poller Status resource for object R_J_M_001 as in the screen capture I attached, and place it on a generic node view, it always displays the pollers status (responses) for THAT object whereas I want this table to reflect the UnDP statuses of the object whose details are being displayed .  I hope I explained myself.

                      Thanks, Itzhak

                       

                      Date: Wed, 7 Aug 2013 06:21:48 -0500

                      From: solarwindscommunityteam@communications.solarwinds.com

                      To: tzotz@hotmail.com

                      Subject: Re: - Customizing the UnDP Summary Chart Bubble

                                                                                                      thwack

                                                               

                       

                                                          

                                                          

                                                               

                          Customizing the UnDP Summary Chart Bubble

                       

                       

                          created by zbynek.botlo in Network Performance Monitor - View the full discussion

                       

                       

                       

                      If you place the Universal Device Poller Status resource on some Node Details view you'll see pollers and it's values based on the currently selected node.

                       

                       

                       

                           Reply to this message by replying to this email -or- go to the message on thwack

                           Start a new discussion in Network Performance Monitor by email or at thwack

                        • Re: Customizing the UnDP Summary Chart Bubble
                          zbynek.botlo

                          From the screenshot I can see you are using Custom Object Resource and in that case the resource will always show data for one particular entity only.

                           

                          You need to look for Universal Device Poller Status resource on the node details view which doesn't need to select specific node. This resource doesn't require any additional configuration, you just place it on the node details view and it will automatically show all the UnDPs assigned to currently displayed node.

                            • Re: Customizing the UnDP Summary Chart Bubble
                              tzotz

                              Hi Zbynek,

                              Great, thank you. 

                              Last question (on this topic): As most pollers statuses displayed are the actual "raw" status returned by the poller and its "transformed" (for display purposes) "Twin" - can I filter out the "raw" value and retain only the "transformed" one?

                              Thanks again, you've been a great help, saved me a lot of time and effort.

                              Best,

                              Itzhak

                               

                              Date: Wed, 7 Aug 2013 10:38:15 -0500

                              From: solarwindscommunityteam@communications.solarwinds.com

                              To: tzotz@hotmail.com

                              Subject: Re: - Customizing the UnDP Summary Chart Bubble

                                                                                                              thwack

                                                                       

                               

                                                                  

                                                                  

                                                                       

                                  Customizing the UnDP Summary Chart Bubble

                               

                               

                                  created by zbynek.botlo in Network Performance Monitor - View the full discussion

                               

                               

                               

                              From the screenshot I can see you are using Custom Object Resource and in that case the resource will always show data for one particular entity only.

                              You need to look for Universal Device Poller Status resource on the node details view which doesn't need to select specific node. This resource doesn't require any additional configuration, you just place it on the node details view and it will automatically show all the UnDPs assigned to currently displayed node.

                               

                               

                               

                                   Reply to this message by replying to this email -or- go to the message on thwack

                                   Start a new discussion in Network Performance Monitor by email or at thwack

                                • Re: Customizing the UnDP Summary Chart Bubble
                                  zbynek.botlo

                                  Unfortunately this resource doesn't allow any additional filtering. However it's relatively simple tabular resource and for situations like this you can usually use Custom Query Resource and specify the filter within the custom query. I can help you to do that if you tell me which version of NPM do you have.

                                    • Re: Customizing the UnDP Summary Chart Bubble
                                      tzotz

                                      Hi Zbynek,

                                      Thank you for your help.

                                      I'd like very much to try what you suggest, our NPM version is 10.5.

                                      Best regards,

                                      Itzhak

                                       

                                      Date: Thu, 8 Aug 2013 08:08:14 -0500

                                      From: solarwindscommunityteam@communications.solarwinds.com

                                      To: tzotz@hotmail.com

                                      Subject: Re: - Customizing the UnDP Summary Chart Bubble

                                                                                                                      thwack

                                                                               

                                       

                                                                          

                                                                          

                                                                               

                                          Customizing the UnDP Summary Chart Bubble

                                       

                                       

                                          created by zbynek.botlo in Network Performance Monitor - View the full discussion

                                       

                                       

                                       

                                      Unfortunately this resource doesn't allow any additional filtering. However it's relatively simple tabular resource and for situations like this you can usually use Custom Query Resource and specify the filter within the custom query. I can help you to do that if you tell me which version of NPM do you have.

                                       

                                       

                                       

                                           Reply to this message by replying to this email -or- go to the message on thwack

                                           Start a new discussion in Network Performance Monitor by email or at thwack

                                        • Re: Customizing the UnDP Summary Chart Bubble
                                          zbynek.botlo

                                          Ok so you need to place the Custom Query resource on the node details view. Edit this resource and insert following text as a Custom SWQL Query:

                                           

                                          SELECT c.UniqueName AS [Poller Name], s.Status AS [Current Status], ToLocal(s.DateTime) AS [Last Polled]

                                          FROM Orion.NPM.CustomPollerAssignment a

                                          JOIN Orion.NPM.CustomPollers c ON a.CustomPollerID = c.CustomPollerID

                                          JOIN Orion.NPM.CustomPollerStatus s ON a.CustomPollerAssignmentID = s.CustomPollerAssignmentID

                                          WHERE c.PollerType <> 'F' AND a.NodeID = ${NodeID}

                                           

                                          Let me know how it works for you.

                                            • Re: Customizing the UnDP Summary Chart Bubble
                                              tzotz

                                              Hi Zbynek,

                                              Thank you very much for your help.

                                              The query worked but selected the RAW values rather then the transformed values that I need.  Please see the screen shots where the values I'd like to keep are displayed bounded by the red frame.  Another thing is the "Last Polled" formatting is too long and results in an extra line in the display.

                                              Can this be corrected?

                                              Thank you again,

                                              Best regards,

                                              Itzhak

                                              Date: Fri, 9 Aug 2013 06:05:20 -0500

                                              From: solarwindscommunityteam@communications.solarwinds.com

                                              To: tzotz@hotmail.com

                                              Subject: Re: - Customizing the UnDP Summary Chart Bubble

                                                                                                                              thwack

                                                                                       

                                               

                                                                                  

                                                                                  

                                                                                       

                                                  Customizing the UnDP Summary Chart Bubble

                                               

                                               

                                                  created by zbynek.botlo in Network Performance Monitor - View the full discussion

                                               

                                               

                                               

                                              Ok so you need to place the Custom Query resource on the node details view. Edit this resource and insert following text as a Custom SWQL Query:

                                              SELECT c.UniqueName AS , s.Status AS , ToLocal(s.DateTime) AS

                                              FROM Orion.NPM.CustomPollerAssignment a

                                              JOIN Orion.NPM.CustomPollers c ON a.CustomPollerID = c.CustomPollerID

                                              JOIN Orion.NPM.CustomPollerStatus s ON a.CustomPollerAssignmentID = s.CustomPollerAssignmentID

                                              WHERE c.PollerType <> 'F' AND a.NodeID = $

                                              Let me know how it works for you.

                                               

                                               

                                               

                                                   Reply to this message by replying to this email -or- go to the message on thwack

                                                   Start a new discussion in Network Performance Monitor by email or at thwack

                                              • Re: Customizing the UnDP Summary Chart Bubble
                                                tzotz

                                                Hi Zbynek,

                                                Thank you very much for your help.

                                                The query worked but selected the RAW values rather then the transformed values that I need.  Please see the screen shots where the values I'd like to keep are displayed bounded by the red frame.  Another thing is the "Last Polled" formatting is too long and results in an extra line in the display.

                                                Can this be corrected?

                                                Thank you again,

                                                Best regards,

                                                Itzhak

                                                Date: Fri, 9 Aug 2013 06:05:20 -0500

                                                From: solarwindscommunityteam@communications.solarwinds.com

                                                To: tzotz@hotmail.com

                                                Subject: Re: - Customizing the UnDP Summary Chart Bubble

                                                                                                                                thwack

                                                                                         

                                                 

                                                                                    

                                                                                    

                                                                                         

                                                    Customizing the UnDP Summary Chart Bubble

                                                 

                                                 

                                                    created by zbynek.botlo in Network Performance Monitor - View the full discussion

                                                 

                                                 

                                                 

                                                Ok so you need to place the Custom Query resource on the node details view. Edit this resource and insert following text as a Custom SWQL Query:

                                                SELECT c.UniqueName AS , s.Status AS , ToLocal(s.DateTime) AS

                                                FROM Orion.NPM.CustomPollerAssignment a

                                                JOIN Orion.NPM.CustomPollers c ON a.CustomPollerID = c.CustomPollerID

                                                JOIN Orion.NPM.CustomPollerStatus s ON a.CustomPollerAssignmentID = s.CustomPollerAssignmentID

                                                WHERE c.PollerType <> 'F' AND a.NodeID = $

                                                Let me know how it works for you.

                                                 

                                                 

                                                 

                                                     Reply to this message by replying to this email -or- go to the message on thwack

                                                     Start a new discussion in Network Performance Monitor by email or at thwack

                                                  • Re: Customizing the UnDP Summary Chart Bubble
                                                    zbynek.botlo

                                                    I edited the query little bit so now it shows only the transformations and time (hh:mm) instead of the date:

                                                     

                                                    SELECT c.UniqueName AS [Poller Name], s.Status AS [Current Status], ToString(Hour(ToLocal(s.DateTime))) + ':' + ToString(Minute(ToLocal(s.DateTime))) AS [Last Polled]

                                                    FROM Orion.NPM.CustomPollerAssignment a

                                                    JOIN Orion.NPM.CustomPollers c ON a.CustomPollerID = c.CustomPollerID

                                                    JOIN Orion.NPM.CustomPollerStatus s ON a.CustomPollerAssignmentID = s.CustomPollerAssignmentID

                                                    WHERE c.PollerType = 'F' AND a.NodeID = ${NodeID}

                                                      • Re: Customizing the UnDP Summary Chart Bubble
                                                        tzotz

                                                        Hi Zbynek,

                                                        Thanks again, it is almost perfect.  The time output needs a little work:

                                                        Time of 15:03 displayed as 3:3, it has to be either 3:03 PM or 15:03.  I tried to figure out how to change the SQL, even called Google for help but it didn't work.

                                                        Thanks, best regards, Itzhak

                                                         

                                                        Date: Mon, 12 Aug 2013 05:17:58 -0500

                                                        From: solarwindscommunityteam@communications.solarwinds.com

                                                        To: tzotz@hotmail.com

                                                        Subject: Re: - Customizing the UnDP Summary Chart Bubble

                                                                                                                                        thwack

                                                                                                 

                                                         

                                                                                            

                                                                                            

                                                                                                 

                                                            Customizing the UnDP Summary Chart Bubble

                                                         

                                                         

                                                            created by zbynek.botlo in Network Performance Monitor - View the full discussion

                                                         

                                                         

                                                         

                                                        I edited the query little bit so now it shows only the transformations and time (hh:mm) instead of the date:

                                                        SELECT c.UniqueName AS , s.Status AS , ToString(Hour(ToLocal(s.DateTime))) + ':' + ToString(Minute(ToLocal(s.DateTime))) AS

                                                        FROM Orion.NPM.CustomPollerAssignment a

                                                        JOIN Orion.NPM.CustomPollers c ON a.CustomPollerID = c.CustomPollerID

                                                        JOIN Orion.NPM.CustomPollerStatus s ON a.CustomPollerAssignmentID = s.CustomPollerAssignmentID

                                                        WHERE c.PollerType = 'F' AND a.NodeID = $

                                                         

                                                         

                                                         

                                                             Reply to this message by replying to this email -or- go to the message on thwack

                                                             Start a new discussion in Network Performance Monitor by email or at thwack

                                                          • Re: Customizing the UnDP Summary Chart Bubble
                                                            zbynek.botlo

                                                            This is probably the best result I can give you right now. Last polled column display complete date with time as previously but I think it should not take an extra line since it'll show only the transformations which don't have such long names. This query isn't regular SQL but our SWQL (SWIS query) and the list of provided functions is limited. I wasn't able to figure out how to format the date correctly.

                                                             

                                                            SELECT c.UniqueName AS [Poller Name], s.Status AS [Current Status], ToLocal(s.DateTime) AS [Last Polled]

                                                            FROM Orion.NPM.CustomPollerAssignment a

                                                            JOIN Orion.NPM.CustomPollers c ON a.CustomPollerID = c.CustomPollerID

                                                            JOIN Orion.NPM.CustomPollerStatus s ON a.CustomPollerAssignmentID = s.CustomPollerAssignmentID

                                                            WHERE c.PollerType = 'F' AND a.NodeID = ${NodeID}

                                                              • Re: Customizing the UnDP Summary Chart Bubble
                                                                tzotz

                                                                Hi Zbynek,

                                                                Thank you, I'll go with what you suggest.

                                                                Please indulge me for another question:

                                                                Is there a way to associate custom colors with nodes on the map according to some TBD conditions as for instance one or more objects being up/down or maybe a polled value exceeding pre determined threshold? If so can you point me to where it's documented?

                                                                Thank you again for your patience and great help.

                                                                Best regards,

                                                                Itzhak

                                                                 

                                                                Date: Tue, 13 Aug 2013 02:52:33 -0500

                                                                From: solarwindscommunityteam@communications.solarwinds.com

                                                                To: tzotz@hotmail.com

                                                                Subject: Re: - Customizing the UnDP Summary Chart Bubble

                                                                                                                                                thwack

                                                                                                         

                                                                 

                                                                                                    

                                                                                                    

                                                                                                         

                                                                    Customizing the UnDP Summary Chart Bubble

                                                                 

                                                                 

                                                                    created by zbynek.botlo in Network Performance Monitor - View the full discussion

                                                                 

                                                                 

                                                                 

                                                                This is probably the best result I can give you right now. Last polled column display complete date with time as previously but I think it should not take an extra line since it'll show only the transformations which don't have such long names. This query isn't regular SQL but our SWQL (SWIS query) and the list of provided functions is limited. I wasn't able to figure out how to format the date correctly.SELECT c.UniqueName AS , s.Status AS , ToLocal(s.DateTime) AS FROM Orion.NPM.CustomPollerAssignment aJOIN Orion.NPM.CustomPollers c ON a.CustomPollerID = c.CustomPollerIDJOIN Orion.NPM.CustomPollerStatus s ON a.CustomPollerAssignmentID = s.CustomPollerAssignmentIDWHERE c.PollerType = 'F' AND a.NodeID = $

                                                                 

                                                                 

                                                                     Reply to this message by replying to this email -or- go to the message on thwack

                                                                     Start a new discussion in Network Performance Monitor by email or at thwack

                                                                  • Re: Customizing the UnDP Summary Chart Bubble
                                                                    zbynek.botlo

                                                                    Node status is represented by the icon with some specific color which is determined only based on the ICMP ping. We introduced new feature UnDP on Maps in current release NPM 10.6 which allows you to put some UnDP on the map and see it's status (color) based on some pre-defined thresholds. More info here:

                                                                     

                                                                    NPM 10.6 RC2 IS HERE - UNDP ON MAPS, NEW OPENSTREET MAPS, NEW REPORTING

                                                                      • Re: Customizing the UnDP Summary Chart Bubble
                                                                        tzotz

                                                                        Thanks again Zbynek, I'll look into it,

                                                                        Best, Itzhak

                                                                         

                                                                        Date: Tue, 13 Aug 2013 08:29:58 -0500

                                                                        From: solarwindscommunityteam@communications.solarwinds.com

                                                                        To: tzotz@hotmail.com

                                                                        Subject: Re: - Customizing the UnDP Summary Chart Bubble

                                                                                                                                                        thwack

                                                                                                                 

                                                                         

                                                                                                            

                                                                                                            

                                                                                                                 

                                                                            Customizing the UnDP Summary Chart Bubble

                                                                         

                                                                         

                                                                            created by zbynek.botlo in Network Performance Monitor - View the full discussion

                                                                         

                                                                         

                                                                         

                                                                        Node status is represented by the icon with some specific color which is determined only based on the ICMP ping. We introduced new feature UnDP on Maps in current release NPM 10.6 which allows you to put some UnDP on the map and see it's status (color) based on some pre-defined thresholds. More info here: NPM 10.6 RC2 IS HERE - UNDP ON MAPS, NEW OPENSTREET MAPS, NEW REPORTING

                                                                         

                                                                         

                                                                         

                                                                             Reply to this message by replying to this email -or- go to the message on thwack

                                                                             Start a new discussion in Network Performance Monitor by email or at thwack