7 Replies Latest reply on Sep 25, 2018 7:59 PM by jenniebyu

    Report on discovered nodes?

    stefanIT

      Has anyone successfully created a report on nodes discovered but not imported or added to the ignore list? I'd love to know how to do this. Have experimented with various SWIS queries, but can't seem to find the "DateFound" parameter anywhere.

        • Re: Report on discovered nodes?
          zackm

          Here you go:

           

          SELECT
                d.IPAddress AS "DISCOVERED IP ADDRESS",
                d.SysName AS "DISCOVERED DEVICE"
          FROM
                DiscoveredNodes d
          JOIN
            Nodes n ON d.IPAddress=n.IP_Address
          WHERE
                n.IP_Address is NULL
          AND
                d.IgnoredNodeID IS NULL
          
          

           

           

          You can use that to make a Custom SQL report in either the legacy Report Writer or the new Web-based.

           

          Basic Function:

               Look at all of your discovered nodes that are not in the ignored list. Compare that data against all the current nodes that are already in SolarWinds. If the IP_Address field in the Nodes table is NULL, then the node has not been imported yet.

           

          If you have multiple discovery profiles running, you can further edit/enhance this report by finding the ProfileID from the DiscoveryProfiles table and then adding a statement at the end of your report (this can be helpful if you are trying to report on regions/teams/etc that have their own discoveries running)

           

          SELECT
               ProfileID,
               Name,
               Description
          FROM
               DiscoveryProfiles
          
          

           

           

          AND
               d.ProfileID = 'INSERT # HERE'
          
          

           

           

           

          ZackM

          www.loop1systems.com

          • Re: Report on discovered nodes?
            jenniebyu

            Thanks for the initial post @stefanIT! That saved me a lot of time! This is my modification recommendation. This shows the same devices listed under "Found" in Scheduled Discovery Results.

             

            SELECT *

            FROM

                 DiscoveredNetObjectStatuses dnos

            JOIN

                 DiscoveredNodes dn on dn.profileid = dnos.profileid

                 and dn.nodeid = dnos.DiscoveredObjectID

            WHERE

                 ManagedNetObjectID is null and IgnoredNodeID is null

             

            -OR-

             

            SELECT *

            FROM

                 DiscoveredNetObjectStatuses dnos

            JOIN

                 DiscoveredNodes dn on dn.profileid = dnos.profileid

                 and dn.nodeid = dnos.DiscoveredObjectID

            WHERE

                 ImportStatus != 33 and IgnoredNodeID is null

             

            ImportStatus 33 seems to be that there is a ManagedNetObjectID.

             

            Here was my first attempt which was a modification off the initial post. Just in case this process helps anyone else looking for a similar report.

             

            SELECT

            n.IPAddress,

            nn.IP_Address, 

            d.IPAddress AS "DISCOVERED IP ADDRESS",

                  d.SysName AS "DISCOVERED DEVICE",

                 d.Hostname AS "DISCOVERED HOSTNAME",

                 d.DNS AS "DISCOVERED DNS",

                 d.MachineType,

                 d.SysDescription

            FROM

                  DiscoveredNodes d

            LEFT JOIN

              NodeIPAddresses n ON d.IPAddress=n.IPAddress

            LEFT JOIN

              Nodes nn ON d.IPAddress=nn.IP_Address

             

            WHERE

                  d.IgnoredNodeID IS NULL  and n.IPAddress is NULL and nn.IP_Address is NULL and d.IPAddress not like '%.0'

            1 of 1 people found this helpful