Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

Home > Success Center > Network Performance Monitor (NPM) > Volume capacity alert not triggered correctly

Volume capacity alert not triggered correctly

Table of contents
Created by Magdalena.Markova, last modified by MindTouch on Jun 23, 2016

Views: 1,550 Votes: 1 Revisions: 6

Overview

After upgrading from SolarWinds NPM 11.5 or 11.5.1 to SolarWinds NPM 11.5.1 or 11.5.2, the Alert Me When Volume Has Less Than 60 Days of Capacity Left is triggered not for volumes, but for interfaces that have less than 60 days of capacity left.

Resolution

Run the attached SQL query in the SolarWinds Database Manager.

Note: You can also execute the query using Microsoft SQL Server Management Studio.

 

  1. Launch the SolarWinds Database Manager in your SolarWinds Orion > Advanced Features program folder.
  2. If not available, add the SQL server hosting your SolarWinds Orion Database.
  3. Right-click the SQL server and select New Query.
  4. Copy the code below and paste it into the Query tab.
  5. Click Execute Query.

You will now be notified when your volumes have less than 60 days of capacity left.


IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[AlertConfigurations]')
and (dbo.GetCoreDbVersion() >= 20150101))
BEGIN
update [dbo].[AlertConfigurations]
set [Trigger] = '<ArrayOfAlertConditionShelve xmlns="http://schemas.datacontract.org/2004/07/SolarWinds.Orion.Core.Models.Alerting" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><AlertConditionShelve><AndThenTimeInterval i:nil="true"/><ChainType>Trigger</ChainType><ConditionTypeID>Core.CustomSwql</ConditionTypeID><Configuration>&lt;AlertConditionCustomSwql xmlns="http://schemas.datacontract.org/2004/07/SolarWinds.Orion.Core.Alerting.Plugins.Conditions.Swql" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"&gt;&lt;Command&gt;LEFT JOIN Orion.Nodes nodes on nodes.NodeID = VolumesForecastCapacity.NodeID
LEFT JOIN Orion.Settings s ON s.SettingID = ''ForecastMinDays''
WHERE
  VolumesForecastCapacity.DaysToCapacityAvg &amp;lt;= 60
  AND VolumesForecastCapacity.MetricName = ''Forecast.Metric.PercentDiskUsed''
  AND DayDiff(VolumesForecastCapacity.MinDateTime, VolumesForecastCapacity.MaxDateTime) &amp;gt;= ISNULL(s.CurrentValue, 7)
  AND  nodes.Unmanaged = false&lt;/Command&gt;&lt;/AlertConditionCustomSwql&gt;</Configuration><ConjunctionOperator>None</ConjunctionOperator><IsInvertedMinCountThreshold>false</IsInvertedMinCountThreshold><NetObjectsMinCountThreshold i:nil="true"/><ObjectType>Orion.VolumesForecastCapacity</ObjectType><SustainTime i:nil="true"/></AlertConditionShelve></ArrayOfAlertConditionShelve>'
  where [AlertRefID] = '71e1c640-5b3b-4002-a061-444bea49bc91'

END
Last modified

Tags

Classifications

Public