This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

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'

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

    pastedImage_0.png

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

    pastedImage_0.png

    --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

  • Awesome resource - but, how do you delete these 'dead' volumes from NPM?

    The only way we have been able to get rid of these is removing and re-adding the Node.

    Thanks

    *** EDIT - go to manage nodes, delete dead volumes there.