Server Discovery

Question

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!

mesverrum · Accepted Answer

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 '

' as [ ] ,''+n.caption+'' as Node ,n.ip_address as IP_Address ,n.ObjectSubType as Polling_Method ,'

' AS [ ] ,n.StatusDescription as Status ,n.nodeid as [order] FROM Nodes n UNION ( SELECT '

' AS [ ] ,' - '+i.caption+'' 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, 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 ,'

' 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 '

' AS [ ] ,' - '+v.caption+'' 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, followed by a ; or else it wont indent more than the one space ,NULL as IP_Address ,NULL as Polling_Method ,'

' 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 '

' as [ ] ,' - '+a.Name+'' 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, followed by a ; or else it wont indent more than the one space ,NULL as IP_Address ,NULL as Polling_Method ,'

' 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 LinkedIN: Loop1 Systems Facebook: Loop1 Systems Twitter: @Loop1Systems

Server Discovery

Top Replies