3 Replies Latest reply on Jan 17, 2018 11:52 AM by orioncrack

    Top 10 Volume filter - only active volumes?

    sotherls

      Has anyone cracked this yet? I am using the following filter on the Top 10 Volumes resource but want to also filter only active volumes.

       

      volumetype = 'fixed disk' and volumepercentused > 80

       

      I have tried several combinations but have not stumbled on the 'one'

        • Re: Top 10 Volume filter - only active volumes?
          prawij

          This is what we use for our Top 10 Windows volumes:

           

            • Re: Top 10 Volume filter - only active volumes?
              prawij

              Related to that, we also have a resource to show us unresponsive volumes which we delete as needed during our morning checkouts:

               

               

              --begin code

               

              --Query from volumes and nodes tables with icons and links

              SELECT  v.Caption as VolumeName,'/Orion/NetPerfMon/VolumeDetails.aspx?NetObject=V%3a' + ToString(v.volumeid) AS [_LinkFor_VolumeName]

              , '/NetPerfMon/images/Volumes/' + v.icon AS [_IconFor_VolumeName]

              , VolumeResponding

              , v.lastsync

              , VolumeType

              , n.caption as Node, '/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a' + ToString(n.nodeid) AS [_LinkFor_Node]

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

              FROM Orion.Volumes v

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

               

              --filter on not unmanaged and not responding and Fixed or Network disk

              where n.status <> '9' and

              volumeresponding = 'N' and

              type in ('Fixed Disk', 'Network Disk')

               

              --sort by age

              order by ToLocal(v.lastsync) desc

               

              --end code

              1 of 1 people found this helpful