Were going to VMworld Barcelona from September 11th - 14th. Come visit us at booth number B524 and learn how SolarWinds® is making it easier to manage your systems and applications.

See how SolarWinds continues to improve our best-in-class hybrid IT management solutions built on the Orion® Platform. From managing and optimizing your VMware® environment to application and storage monitoring, SolarWinds has you covered.



COME LEARN ABOUT:

 

Performance Tuning and Monitoring for Virtualized Database Servers - Thomas LaRock & David Klee


Date: Wednesday September 13

 

Time: 12.30pm - 1.30pm

 

Where: VMworld Fira Barcelona Gran Via



Description: Come see Thomas LaRock share his experience in virtualizing data Platforms. You will learn how to validate your VMware environment and manage the performance properly. Scalability concerns will be addressed through discussions on scaling database VMs upwards and outwards as you work with the DBAs to manage the data lifecycle. Key talking points will help you learn how to perfect database virtualization from a technical, an organizational, and people level.

 

 

Join SolarWinds Head Geek Kong Yang for his VMworld Wrap-up Webinar

 

 

Kong Yang

 

SolarWinds Head Geek™

 

Date: Thursday September 14

 

Time: GMT (UTC+1): 2:00pm to 2:45pm
          CET (UTC+2): 3:00pm to 3:45pm

 

Where: WebEx - Register Here

 

Description: Join SolarWinds Head Geeks, Kong Yang and Thomas LaRock, and VMAN Product Manager Chris Paap, as they discuss hot topics from VMworld 2017 in Barcelona - premier thought leadership and education event for cloud infrastructure and digital workspace technology professionals. They will cover:

 

    • Hot topics and trends
    • Report from the show
    • Feedback from the event
    • Top questions
    • How could SolarWinds help

 

 

Customers don't forget to bring your e-mail invite to pick up your backpack from our stand, we can’t wait to see you!

One of the many reasons that modules based on the  SolarWinds® Orion® Platform like Server & Application Monitor (SAM), Network Performance Monitor (NPM), and Network Configuration Manager (NCM) are so popular is because customers are able to see value straight out of the box. However, the power of the Orion Platform can easily be taken to the next level by customizing aspects such as reports, alerts, and views. And the cherry on top is that you can also create custom templates for what you manage and monitor! In these posts, we will look at how by not re-inventing the wheel and importing customizations created by other THWACK® members, you can quickly and easily expand your SolarWinds deployment with these best practices.

 

TL;DR:

 

Overall, the approach is fairly straightforward: on THWACK, our customers (and SolarWinds staff) can share content they have created so that others can re-use it. If you need to poll custom metrics or use existing polled data, it's always worth checking THWACK to see if there is a pre-existing poller that meets your needs rather than building one from scratch.

 

Later, we will look at how this content can be created, but once it's in THWACK, it's generally straightforward to either load the customizations either directly in Orion itself, or indirectly by downloading from THWACK and then importing them into Orion. This approach can be very useful if your Orion server is not connected to the internet.

 

 

Pollers within NPM

 

 

First, we will look at how to use pollers for NPM. Essentially, they are two types: you have pollers created via the Device Studio and Universal Device Pollers (UnDPs). Device studio pollers cover technologies such vendor name, CPU, and memory, should devices not support standard polling OIDs, whereas UnDPs tend to be used for more "metric" types.

 

With Device Studio pollers, you can:

  • Poll devices that do not support any of the OIDs polled for by SolarWinds pollers
  • Poll devices that return incorrect data when polled by SolarWinds pollers
  • Override polled values to display custom static values

 

Device studio pollers can be both created and imported in the Orion console itself, and we'll see that these are fairly typical use cases. (More information on the use case is covered over in the online documentation).

The easiest way to find what's already built is to open the device studio ("Settings->"Manage Pollers") in Orion, and then select "Thwack Community Pollers".

From here you can simply select the Poller you wish to use, and then "Assign" to node. On the next screen, you can then scan the nodes for matching OIDs, and you can then enable as needed.

 

Import from Thwack Directly into Orion

 

 

The indirect approach has a few more steps. You would navigate to THWACK from an internet-connected machine, download the template you need, and then re-import to the Orion Platform.

 

Firstly, navigate to THWACK (if you are reading this, you are already there!) and browse to "Product Forums --> Network Performance Monitor." Then select "Content Exchange.”

 

Thwack Forum

 

From here, you can then navigate to the "Device Pollers" category and ensure the "Documents" filter is applied. From here, it's just a matter of selecting the poller you require and then clicking on "Download."

 

Download Content from Thwack

 

Once you download the file, you can then import it to the Orion Platform in the Device Studio, except instead of selecting the "THWACK Community Pollers," use the Local Poller Library.

 

UnDPs work slightly differently, in that they are still managed via a Win32 application on the Orion server itself, but you can still utilize the import function to benefit from UnDP templates on THWACK. The approach is virtually the same as for the device studio pollers, except instead of selecting the "device pollers" category, you select the "Universal Device Pollers" category. As before, just download the template, copy to the Orion server, and then import.

Universal Device Poller (UnDP)

<insert UnDP screenshot>

 

Stay Tuned

 

In the next posts, we will look at application templates within SAM and device templates within NCM.

Hello Folks,

 

Got a Requirement today to generate a report on CPU, Disk and Memory Usage, Usually this report is used by the Infrastructure teams to access current usage and forecast capacity

 

Hence I spend some time on Research,

 

Found a Helpful Article, Custom Report: Hourly average CPU and memory usage - SolarWinds Worldwide, LLC. Help and Support

 

  1. Click Settings > Manage reports.
  2. Click Create new Report:
    • Select Custom Table and click Select and Continue.
    • Set the Data Selection as follows, and click Add to layout:
      • For Selection method use - Specific Objects
      • Select the nodes for the report.
  3. To setup the Custom table, click Add Column. Add the following:
    • Node Name
    • Average CPU Load
    • Average Memory Used
  4. Set Timestamp to hourly.
  5. Set Sort and Group Results By to - Node.
  6. Set From option to Last 24 hours.
  7. Finish the report wizard.

 

The Steps mentioned above give you a perfect report on CPU and Memory Usage, I choose to aggregate it for last 24 hours and the sample is shown  below:

 

This was good now, i wanted to get the Disk report,

 

Hence found a helpful thread, which lists down the SQL query to get the disk report ( Logical Disk)

 

SELECT

   N.NodeID AS 'Node ID'

  ,N.Caption AS 'Server Name'

  ,I.IPAddress as 'IP Addresses'

  ,V.Caption AS 'Volume Name'

  ,V.VolumeDescription AS 'Volume Description'

  ,V.VolumeType AS 'Volume Type'

  ,V.VolumeTypeID AS 'Volume Type ID'

  ,ROUND(V.VolumeSize/1073741824,0) AS 'SIZE /GB'

  ,ROUND(V.VolumePercentUsed,0) AS 'Percent Used'

  ,ROUND(V.VolumeSpaceUsed/1073741824,0) AS 'USED /GB' --VolumeSpaceUsed is calculated in Bytes (/ by 1073741824 to get GB)

  ,ROUND(V.VolumeSpaceAvailable/1073741824,0) AS 'FREE /GB' --VolumeSpaceAvailable is calculated in Bytes (/ by 1073741824 to get GB)

  ,CASE

  WHEN V.VolumePercentUsed >= 95 THEN 'WARNING Less than 5% Free'

  ELSE ' '

  END AS 'Warning'

 

FROM dbo.Nodes AS N

  INNER JOIN dbo.NodeIPAddresses AS I

  ON N.NodeID = I.NodeID

  INNER JOIN dbo.Volumes AS V

  ON N.NodeID = V.NodeID

 

 

WHERE

  V.VolumeTypeID = (4)

 

 

Order BY

  N.Caption ASC

 

Output Sample :

This two reports were really helpful, but then the requirement was to show the data in one single report, i tried hands on another Advanced Reporting option

 

So using the Advance Report Editor,

Selection Method was Specific Object (Static Selection ) Choose Windows as a group

Now while Specifying columns, Average CPU Load, Disk Usage, Memory Usage got the error below

 

 

I believe, this may be achievable using the Advanced SQL Query Editor, however not sure of the Implications this may cause and the data might be fetched from different buckets and might cause performance issues.

SolarWinds uses cookies on its websites to make your online experience easier and better. By using our website, you consent to our use of cookies. For more information on cookies, see our cookie policy.