-
Re: Deleting specific unnecessary mass volumes?
Nandish Oct 31, 2011 8:27 AM (in response to ctopaloglu)I think going to settings-->Manage Nodes and selecting volumes is not going to help here. Would you open a support ticket to get the SQL Query and please post back the ticket# along with the solution.This should be a great help to this community.
-
Re: Deleting specific unnecessary mass volumes?
ctopaloglu Oct 31, 2011 8:38 AM (in response to Nandish)
I think going to settings-->Manage Nodes and selecting volumes is not going to help here. Would you open a support ticket to get the SQL Query and please post back the ticket# along with the solution.This should be a great help to this community.
I opened a case like you suggested.(Case # 282804)
-
Re: Deleting specific unnecessary mass volumes?
Nandish Oct 31, 2011 10:12 AM (in response to ctopaloglu)Thank you and will be great to see the SQL query posted back.
-
Re: Deleting specific unnecessary mass volumes?
ctopaloglu Oct 31, 2011 11:08 AM (in response to Nandish)1 of 1 people found this helpfulResponse from SolarWinds Support
--Run this SQL Query to generate the delete statement
select 'Delete from Volumes where Volumeid=' as [Deletion Script], V.VolumeID, '--', Nodes.Caption as [Node Name], V.Caption as [Volume Name] from Volumes v inner join Nodes on V.NodeID=Nodes.NodeID where V.Caption='/proc/bus/usb' or V.Caption='/proc/sys/fs/binfmt_misc'or V.Caption='/var/lib/nfs/rpc_pipefs' Order by Nodes.Caption, V.Caption
--Once this has been executed, run the results if the Caption of the Node Name and the Volume name correspond to what you want to delete
--Run this after running the deltion statement generated from the 1st sql query. This will remove the volume from being polles.
DELETE FROM Pollers WHERE (NetObject LIKE 'V%') AND (SUBSTRING(NetObject, 3, 10) NOT IN (SELECT VolumeId FROM Volumes))I tried. It works! Thanks.
-
Re: Deleting specific unnecessary mass volumes?
sean.martinez Oct 31, 2011 11:31 AM (in response to ctopaloglu)I got a little creative with the above query, but I wanted to make sure that the Node Name and the Volume Name were displayed before you deleted the information to prevent accidental deletion. This query should Translate over very easily for Interfaces or Nodes as well.
-
Re: Deleting specific unnecessary mass volumes?
ctopaloglu Oct 31, 2011 11:37 AM (in response to sean.martinez)
I got a little creative with the above query, but I wanted to make sure that the Node Name and the Volume Name were displayed before you deleted the information to prevent accidental deletion. This query should Translate over very easily for Interfaces or Nodes as well.
Thanks for your help Sean.
-
-
-
-
-