5 Replies Latest reply on Feb 1, 2017 3:55 AM by whitwa

    Overall Configuration Changes Snapshot

    whitwa

      Hi,

       

      We would like to obtain the Overall Configuration Changes Snapshot data via the SolarWinds API.

       

      Note we want the actual data and not to embed the SolarWinds widget in our user interface.

       

      Please can you assist.

       

       

      Regards,

      Andrew

        • Re: Overall Configuration Changes Snapshot
          whitwa

          Anyone have any ideas whereabouts I would look for this information within SWQL Studio?

           

          Regards,

          Andrew

            • Re: Overall Configuration Changes Snapshot
              tdanner

              I asked the NCM dev team to answer this question. Hopefully you'll have an answer soon.

                • Re: Overall Configuration Changes Snapshot
                  whitwa

                  Much appreciated - I will await their answer.

                   

                  Regards,

                  Andrew

                    • Re: Overall Configuration Changes Snapshot
                      tdanner

                      And here's the query:

                       

                      select distinct
                        CASE
                          WHEN CacheResults.DiffFlags = 1 THEN 'changed'
                          WHEN CacheResults.DiffFlags = 0 THEN 'unChanged'
                          ELSE 'unknown'
                        END as NCMNodeStatus,
                        NCMNodeProperties.NodeID,
                        Nodes.NodeID as CoreNodeID,
                        Nodes.VendorIcon,                                           
                        Nodes.Caption,
                        Nodes.IPAddress,
                        CacheResults.DiffFlags,
                        Nodes.DetailsUrl,
                        Nodes.Status,
                        Nodes.ChildStatus,
                        Nodes.Vendor,
                        Nodes.Icon,
                        OrionVendors.Icon,
                        ConfigType
                      FROM Cirrus.NodeProperties as NCMNodeProperties
                      join Orion.Nodes as Nodes on Nodes.NodeID=NCMNodeProperties.CoreNodeId
                      join Orion.NodesCustomProperties as OrionCustomProperties on Nodes.NodeId= OrionCustomProperties.NodeId
                      inner join Orion.Vendors AS OrionVendors ON Nodes.Vendor=OrionVendors.Name
                      left join
                      (
                        select
                          DiffFlag as DiffFlags,
                          NodeID,
                          ConfigType
                        from Cirrus.LatestComparisonResults          
                        where ComparisonType=4
                        ) as CacheResults
                      on NCMNodeProperties.NodeID=CacheResults.NodeID              
                      ORDER BY Nodes.Caption ASC