4 Replies Latest reply on Oct 21, 2017 9:20 AM by keeirin

    Server Discovery

    keeirin

      I am attempting to do an updated server list for my network. I would like to include all volumes and services Solarwinds are currently monitoring for this, but I am unable to find any report that pulls this type of information. Can someone please help me out or at least point me in the right direction? Thank you!

        • Re: Server Discovery
          mesverrum

          So I've seen a few requests like this lately and due to the bug where the report tool won't accept SWQL with unions I figured I would see what I could put together using a SQL based report with some HTML embedded instead of the SWQL I usually use.  Let me know if this does the job for you.

           

          Create a new report with a table, for the data source choose advanced SQL and paste the below script in as shown here

           

           

          Add in all the columns, organize them in this order. The "blank" column with a single space is first, the two space version goes next to status.  Columns 1,2 and 5 need to have the allow html boxes checked, and column 7 should be hidden.

           

          This is the end result, the ip addresses listed by the node is the one we poll on, it will attempt to map any additional IP's to the correct interface.  If someone was reallllly motivated you could union in all the types of pollers from list resources but that would be a lot of work, and I already have a separate report that shows those so I wasn't that eager.

           

          SELECT

          '<img src="/netperfmon/images/vendors/'+ n.VendorIcon+'">' as [ ]

          ,'<a href="/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N:'+cast(n.nodeid as varchar)+'">'+n.caption+'</a>' as Node

          ,n.ip_address as IP_Address

          ,n.ObjectSubType as Polling_Method

          ,'<img src="/Orion/images/StatusIcons/Small-' + n.StatusLED+'">' AS [  ]

          ,n.StatusDescription as Status

          ,n.nodeid as [order]

          FROM Nodes n  

           

          UNION (

          SELECT

          '<img src="/netperfmon/images/interfaces/' + i.InterfaceIcon +'">' AS [ ]

          ,' <a href="/Orion/Interfaces/InterfaceDetails.aspx?NetObject=I:'+cast(i.interfaceid as varchar)+'"> - '+i.caption+'</a>' as Interface  --Note that due to the way thwack handles html you might want to replace the white spaces before the i.caption with the html space character, &nbsp followed by a ; or else it wont indent more than the one space

          ,CASE WHEN inip.IPAddress is not null then inip.IPAddress

          ELSE ip.IPAddress

          END AS IP_Address

          ,NULL as Polling_Method

          ,'<img src="/Orion/images/StatusIcons/Small-' + i.Statusled+'">' AS [_IconFor_Status]

          ,concat(cast(InPercentUtil as varchar),'% RX Utilization, ',cast(OutPercentUtil as varchar),'% TX Utilization') as Status

          ,i.nodeid as [order]

          FROM Interfaces I

          left join NodeIPAddresses inip on inip.nodeid=i.nodeid and inip.interfaceindex=i.interfaceindex

          left join NodeIPAddresses ip on ip.NodeID=i.NodeID and ip.IPAddressType='IPv4' and ip.interfaceindex is null

          )

           

          UNION (  

          SELECT

          '<img src="/NetPerfMon/images/Volumes/' + V.VolumeTypeIcon +'">' AS [ ]

          ,'  <a href="/Orion/NetPerfMon/VolumeDetails.aspx?NetObject=V:'+cast(v.volumeid as varchar)+'">   - '+v.caption+'</a>' as Volume --Note that due to the way thwack handles html you might want to replace the white spaces before the v.caption with the html space character, &nbsp followed by a ; or else it wont indent more than the one space

          ,NULL as IP_Address

          ,NULL as Polling_Method

          ,'<img src="/Orion/images/StatusIcons/Small-' + v.StatusLED+'">' AS [_IconFor_Status]

          ,concat(round(v.VolumePercentUsed,0),'% of ',round(v.volumespaceavailable/1073741824,0),' GB total') as Status

          ,v.nodeid as [order]

          FROM Volumes V  

          )

           

          UNION (  

          SELECT

          '<img src="/orion/apm/images/statusicons/Small-App-Blank.gif">' as [ ]

          ,'  <a href="/Orion/APM/ApplicationDetails.aspx?NetObject=AA:'+cast(A.Applicationid as varchar)+'">     - '+a.Name+'</a>' as Application --Note that due to the way thwack handles html you might want to replace the white spaces before the a.Name with the html space character, &nbsp followed by a ; or else it wont indent more than the one space

          ,NULL as IP_Address

          ,NULL as Polling_Method

          ,'<img src="/Orion/images/StatusIcons/Small-' + A.availability+'.gif">' AS [_IconFor_Status]

          ,a.availability as Status

          ,a.nodeid as [order]

          FROM APM_ApplicationAlertsData A 

          )  

           

          ORDER BY [Order], node desc

           

          -Marc Netterfield

              Loop1 Systems: SolarWinds Training and Professional Services