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.

Custom Chart with UNDP Counter values (SQL)... Is that possible?

I'm trying to show multiple values on a chart. No matter what time range I provision, there's always a spike at the beginining of the graph, resulting in unproportional scaling of the graph:

pastedImage_0.png

The spike corresponds to the initial value before difference being calculated.

Here's the data source query:

SELECT 
    cpsd.DateTime,
    cpsd.RawStatus as 'rctRfRxQualityForwardedTsbkIspCount',
    n.Caption
    FROM [SolarWindsOrion].[dbo].[CustomPollerStatistics_Detail] cpsd
        INNER JOIN [SolarWindsOrion].[dbo].[CustomPollerAssignment] cpa
            ON cpsd.CustomPollerAssignmentID = cpa.CustomPollerAssignmentID
        INNER JOIN [SolarWindsOrion].[dbo].[CustomPollers] cp
            ON cpa.CustomPollerID = cp.CustomPollerID
        INNER JOIN [SolarWindsOrion].[dbo].[Nodes] n
            ON cpa.NodeID = n.NodeID
    WHERE cp.UniqueName = 'rctRfRxQualityForwardedTsbkIspCount'
    AND n.caption LIKE '%Rpt01Sc01'
GROUP BY cpsd.DateTime,cpsd.RawStatus,n.caption
ORDER BY n.caption

The chart definition:

pastedImage_3.png

The UNdP poll definition:

pastedImage_6.png

As soon as I use the Zoom button, I get correct scaling (that I would have expected on the first load):

pastedImage_5.png

Anybody would have an idea to get rid of that spike so I can regain some sleep? emoticons_wink.png

Currently running: Orion Platform 2016.2.100, NPM 12.0.1, SAM 6.3.0, DPA 10.2.0, IVIM 2.1.2, NetPath 1.0.1, QoE 2.2.0, NTA 4.2.1

  • Is there a way to force the zoom level to something specific? (ie: load 25 hours worth of data but have automagically the 24hr zoom level)?

  • cobrien​ Do you believe this is a bug? should I have a ticket opened or would you see any workaround to my issue?

  • Hi Guys,

    I was struggling with this today and tried to convert it to SWQL.

    Below query is working with NPM 12.5. I am still thinking of how to include label from undp.

    ----------

    SELECT  

        cpsd.DateTime, 

        cpsd.RawStatus as [vSConns], 

        n.Caption 

        FROM Orion.NPM.[CustomPollerStatistics] cpsd 

            INNER JOIN Orion.NPM.[CustomPollerAssignment] cpa 

                ON cpsd.CustomPollerAssignmentID = cpa.CustomPollerAssignmentID 

            INNER JOIN Orion.NPM.[CustomPollers] cp 

                ON cpa.CustomPollerID = cp.CustomPollerID 

            INNER JOIN Orion.[Nodes] n 

                ON cpa.NodeID = n.NodeID 

        WHERE cp.UniqueName = 'yyyyyy'  -- please change

        AND n.caption = 'eeeeee'   -- please change

    GROUP BY cpsd.DateTime,cpsd.RawStatus,n.caption 

    ORDER BY n.caption 

  • do you mean the label for the Row in a tabular poller?

    try this to see the data, adjust as necessary for your needs:

    SELECT TOP 1 
    cp.CustomPollerName
    ,cp.CustomPollerStatistics.DateTime
    ,cp.CustomPollerStatistics.RawStatus
    ,cp.Node.Caption
    ,l.RowID
    ,l.Label
    FROM Orion.NPM.CustomPollerAssignmentOnNode cp
    JOIN Orion.NPM.CustomPollerLabels l ON l.CustomPollerAssignmentID = cp.CustomPollerStatistics.CustomPollerAssignmentID AND l.RowID = cp.CustomPollerStatistics.RowID
    WHERE cp.CustomPollerStatistics.DateTime > (GETUTCDATE() -1)
  • For the data label it's in Orion.NPM.CustomPollerLabels for SWQL.

    Otherwise if you're looking for just the poller name it's UniqueName in Orion.NPM.CustomPoller.

  • Hi zackm​ and jrouviere

    Thanks for your suggestions and query. Yes, I was referring to the Labels defined in the UnDP (Orion.NPM.CustomPollerLabels)

    I managed to create a query, which is showing me what I need, but everything points to a bug in the NPM 12.5, which is not allowing me to create a custom chart from my query.

    More info is available here:

    Issue with Custom Chart with SWQL+UnDP

    Kind regards,

    Marcin.