9 Replies Latest reply on Oct 10, 2017 1:45 PM by anil.singh

    Missing Node Name in Volume Capacity Forecast Report

    anil.singh

      I searched, raised cases with Vendor but no luck.

      Is anyone able to get the Node name while pulling volume capacity forecast report (only fixed disk). For CPU & MEMORY it is working , but no option I could find from where I can insert the Node name or even Node ID.

      Capacity forecasting template is also not available in report writer. Need help.. very urgent....

       

      Thanks in advance...!!!

        • Re: Missing Node Name in Volume Capacity Forecast Report
          mesverrum

          For some reason they made some weird choices with the Volume forecast tables so they don't join up as easily as one would hope in the GUI.

           

          This is the custom SWQL query I use for keeping an eye on disk volumes, hopefully you can adjust it for what you need

           

           

          SELECT n.caption as [Node]

          , v.Caption as [Volume]

          , round(v.VolumePercentUsed,1) as [Space Used]

          ,round(v.volumespaceavailable/1073741824,1) as [Free GB]

          ,case when f.DaysToCapacityPeak is null then 'No Forecast'

          when f.DaysToCapacityPeak<0 then 'Full'

          when f.DaysToCapacityPeak<91 then tostring(f.DaysToCapacityPeak)

          when f.DaysToCapacityPeak>90 then '>90 Days'

          end as [Days til Full],

          v.DetailsUrl as [_linkfor_Volume]

          , n.DetailsUrl as [_linkfor_Node]

          ,'/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Node]

          , case when fc.WarningThreshold is null and v.VolumePercentUsed > (Select CurrentValue AS [col1] FROM Orion.Settings WHERE SettingID = 'NetPerfMon-DiskSpace-Error') then '/Orion/images/StatusIcons/Small-Critical.gif'

          when fc.WarningThreshold is null and v.VolumePercentUsed > (Select CurrentValue AS [col1] FROM Orion.Settings WHERE SettingID = 'NetPerfMon-DiskSpace-Warning') then '/Orion/images/StatusIcons/Small-Warning.gif'

          when v.VolumePercentUsed>f.CriticalThreshold then '/Orion/images/StatusIcons/Small-Critical.gif'

          when v.VolumePercentUsed>f.WarningThreshold then '/Orion/images/StatusIcons/Small-Warning.gif'

          end as [_Iconfor_Space Used]

          ,'/Orion/images/StatusIcons/Small-' + v.StatusIcon AS [_IconFor_Volume]

           

          from orion.Volumes v

          join orion.nodes n on n.nodeid=v.nodeid

          left join Orion.ForecastCapacitySettings fc on fc.InstanceId=v.VolumeID and fc.metricid=3

          left join Orion.ForecastCapacity f on f.InstanceId = v.VolumeID and f.EntityType='Orion.volumes'

           

          where (v.volumetype like 'fixed%' or v.volumetype like '%network%' or v.volumetype like '%mount%') and v.volumesize>500000000

          and v.volumepercentused > case when fc.WarningThreshold is null then (Select CurrentValue AS [col1] FROM Orion.Settings WHERE SettingID = 'NetPerfMon-DiskSpace-Warning')

          else fc.CriticalThreshold end

          --and v.customproperties.SupressVolume=0

          --and v.FullName like '%${SEARCH_STRING}%'

           

          order by currentvalue desc

           

           

          -Marc Netterfield

              Loop1 Systems: SolarWinds Training and Professional Services

            • Re: Missing Node Name in Volume Capacity Forecast Report
              anil.singh

              thanks mesverrum,

                   can you add total disk size & disk used percentage column.??? And filter nodes by nodes custom properties. That will really help. !!

                • Re: Missing Node Name in Volume Capacity Forecast Report
                  mesverrum

                  SELECT n.caption as [Node]

                  , v.Caption as [Volume]

                  , round(v.VolumePercentUsed,1) as [Space Used %]

                  ,round(v.volumesize/1073741824,1) as [Total GB]

                  ,round(v.volumespaceavailable/1073741824,1) as [Free GB]

                  ,case when f.DaysToCapacityPeak is null then 'No Forecast'

                  when f.DaysToCapacityPeak<0 then 'Full'

                  when f.DaysToCapacityPeak<91 then tostring(f.DaysToCapacityPeak)

                  when f.DaysToCapacityPeak>90 then '>90 Days'

                  end as [Days til Full],

                  v.DetailsUrl as [_linkfor_Volume]

                  , n.DetailsUrl as [_linkfor_Node]

                  ,'/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Node]

                  , case when fc.WarningThreshold is null and v.VolumePercentUsed > (Select CurrentValue AS [col1] FROM Orion.Settings WHERE SettingID = 'NetPerfMon-DiskSpace-Error') then '/Orion/images/StatusIcons/Small-Critical.gif'

                  when fc.WarningThreshold is null and v.VolumePercentUsed > (Select CurrentValue AS [col1] FROM Orion.Settings WHERE SettingID = 'NetPerfMon-DiskSpace-Warning') then '/Orion/images/StatusIcons/Small-Warning.gif'

                  when v.VolumePercentUsed>f.CriticalThreshold then '/Orion/images/StatusIcons/Small-Critical.gif'

                  when v.VolumePercentUsed>f.WarningThreshold then '/Orion/images/StatusIcons/Small-Warning.gif'

                  end as [_Iconfor_Space Used %]

                  ,'/Orion/images/StatusIcons/Small-' + v.StatusIcon AS [_IconFor_Volume]

                   

                  from orion.Volumes v

                  join orion.nodes n on n.nodeid=v.nodeid

                  left join Orion.ForecastCapacitySettings fc on fc.InstanceId=v.VolumeID and fc.metricid=3

                  left join Orion.ForecastCapacity f on f.InstanceId = v.VolumeID and f.EntityType='Orion.volumes'

                   

                  where (v.volumetype like 'fixed%' or v.volumetype like '%network%' or v.volumetype like '%mount%') and v.volumesize>500000000

                  and v.volumepercentused > case when fc.WarningThreshold is null then (Select CurrentValue AS [col1] FROM Orion.Settings WHERE SettingID = 'NetPerfMon-DiskSpace-Warning')

                  else fc.CriticalThreshold end

                  and n.customproperties.[yourproperty]='yourcommenthere'

                  --and v.FullName like '%${SEARCH_STRING}%'

                   

                  order by currentvalue desc

                  2 of 2 people found this helpful