1 of 1 people found this helpful
Related to that, we also have a resource to show us unresponsive volumes which we delete as needed during our morning checkouts:
--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]
, 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
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.
*** EDIT - go to manage nodes, delete dead volumes there.