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

    Top 10 Volume filter - only active volumes?


      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?

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


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

              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